Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006

    Unanswered: Urgent Help plz-File operation!!

    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



  2. #2
    Join Date
    Jun 2006


    export can be launched with a store proc : there is admin_cmd to do this
    have a look at doc regarding this sp
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Dec 2006
    thnx a lot guyprzytula...i really appreciate ur suggestion...wud try it ASAP..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts