Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    10

    Unanswered: DB2 SQL Procedure

    Hi All

    Is there any way i can write a db2 SQL Stored procedure to import data from a file into a db2 staging table

    Can someone write me the script...Is it true that the IMPORT statement cannot be used in SQL Stored procedure

    As is am totally new to Db2 i would really appreciate if some one can help me out

    Thanks

    gsinha

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    ssinha,
    Check out this this article for doing what you want.

    IMPORT is a command, not a SQL statement.. That is why it cannot be called in a SP.

    HTH

    Andy

Posting Permissions

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