Results 1 to 3 of 3

Thread: DB2 Stored Proc

  1. #1
    Join Date
    Nov 2011
    Posts
    87

    Unanswered: DB2 Stored Proc

    Hello,

    db2 9.7 / windows 2008

    I want to export a table data into CSV file daily. This is the sampe query.

    EXPORT TO C:\TEMP\MYDATA.DEL OF DEL
    SELECT NAME,DOB,ID FROM EMP.

    Is there anyway to create this query by Stored Procedure ?
    Then I can call the procedure by the scheduler.

    Please advise.
    Thanks.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5

  3. #3
    Join Date
    Nov 2011
    Posts
    87

    Thanks

    thanks Andy. Really helpfull.

Posting Permissions

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