[Openroad-users] Dynamic SQL for conversion of COPY INTO statements

[Colin Hay]

We are currently converting our COPY INTO statements to run against DB2
 
I need to select the data into a String to write to a file
 
When getting the data, the columns and table names are dynamic
 
So I would like to do something like this -
 
SELECT :lv_columns
FROM :lv_table
{
    // Process each row of data into a String
};
 
 
Unfortunately (and not surprisingly) OpenROAD does not handle
:lv_columns as desired
 
Is there a simple answer or do I need to drop into 3GL or (gulp!) ABF -
 
e.g.
 
data_array = select * from :lv_table;
 
 
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/20080207/52c36360/attachment.html