469,575 Members | 1,249 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,575 developers. It's quick & easy.

Urgent Help plz!!

4
Hi all
I would like to request for a help here.I am working with db2 databases

and currently been assigned a job to migrate from oracle to Db2.I have

been struggling with a problem and being struck at that point.Here I have

to read data from a temporary table to a delimited text file.In oracle

there is a file utility package (f_open,f_write,f_close)to perform this

operation but there is no such equivalent in db2.There is ofcourse an

export utility which could be used for writing to a del file but I have

been asked to deal only with a SQL interface that is through SQL Stored

procedures.One option I came across was to use an external UDF built

using C specfically using put_line.But when i created this function in

the sqllib directory and tried to compile it did.But on execution it

couldnt access the path.I am very much struck now and find noways to move

ahead.I find no clue to where to store that UDF or is there any other way

I can access this problem.Any kind of help/suggestions would be sincerely

appreciated.

Thanks
Dec 10 '06 #1
0 1009

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by yoshitha | last post: by
3 posts views Thread by shashank.aka.invi | last post: by
reply views Thread by ghaffar3 | last post: by
6 posts views Thread by Hope | last post: by
1 post views Thread by rooparaman | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.