[Openroad-users] Conversion to OpenSQL

[Colin Hay]

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/8deac2db/attachment.html