URGETN HELP PLZ!!
Posted by:
peter
Date: December 10, 2006 11:59AM
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 IN ADVANCE
Subject
Views
Written By
Posted
URGETN HELP PLZ!!
8247
December 10, 2006 11:59AM
5857
December 19, 2006 07:00AM
5829
March 28, 2007 12:11PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.