[Openroad-users] Conversion to OpenSQL

[Pete Rabjohns]

Hi Colin,

 

With the exception of DB Events (our application does not use them), we
took the approach of abstracting all of the non standard SQL into
classes that would manage the differences of the underlying DBMS via
EXECUTE IMMEDIATE (or DIRECT EXECUTE IMMEDIATE). The reason for this was
that you don't necessarily want to limit your SQL to OpenSQL to achieve
the right performance. This was especially true of UPDATE/FROM.

 

As an example, our application sits on top of SQL Server, Ingres &
Oracle, and all three of them support some kind of UPDATE/FROM syntax,
albeit in slightly different ways.

 

Sorry, cant help on the DBEVENT question.

 

Regards,

 

Pete

 

________________________________

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Colin Hay
Sent: 22 January 2008 03:31
To: International OpenROAD Users
Subject: [Openroad-users] Conversion to OpenSQL

 

Just starting a project whereby we have to make all our OpenROAD /
Ingres code OpenSQL compliant

 

I've identified the following statements that will not work:

 

*         COPY <tablename>

*         CREATE TABLE ... AS SELECT

*         CREATE TABLE (<column> ... WITH DEFAULT)

*         DECLARE GLOBAL TEMPORARY TABLE ... AS SELECT

*         DROP [TABLE|VIEW] :<tablename>

*         RAISE DBEVENT

*         REGISTER DBEVENT

*         SET LOCKMODE

*         SAVEPOINT

*         UPDATE <table> FROM

 

We can rewrite COPY's using StringObjects and UPDATE FROMs with SELECT
loops etc

but how does one handle DBEVENTs and SAVEPOINTs ??

 

Anyone had such experience of porting OpenROAD sp3 to run on DB2 ?

 

Colin Hay

Database Administrator
Fintechnix

Level 3,

55 Clarence Street,

Sydney


colin.hay at fintechnix.com <mailto:colin.hay at fintechnix.com>  
Phone: +61 2 8234 8276  

 


Specialist providers of back and front office systems for the financial
services industry.
Featuring: Fintechnix(r)
Disclaimer: 
Notice: This message contains privileged and confidential information
intended only for the use of the addressee named above. If you are not
the intended recipient of this message you are hereby notified that you
must not disseminate, copy or take any action in reliance on it.
Any views expressed in this message are those of the individual
sender,except where the sender specifically states them to be the views
of Fintechnix Pty Ltd.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20080122/53f55276/attachment.html