Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    2

    Question Unanswered: Insert data from an external file into a global temporary table

    Hi,
    anybody know how to insert data from an external file into a global temporary table ?

  2. #2
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141

    Insert data from an external file into a global temporary table

    - Declare the GTT in your program
    - open the file
    - read the file
    - while there are still more records, do
    - insert into GTT
    - read file
    end-while
    - close the file

    use the GTT

    HTH
    Rodney Krick

  3. #3
    Join Date
    Nov 2002
    Posts
    2

    Wink Re: Insert data from an external file into a global temporary table

    Hello,

    Thanks for the reply.

    I'm looking for some form of "bulk load" like import or load command.
    Sorry, i hadn't emphasize it.

    Regards,
    Steve

    Originally posted by RKrick
    - Declare the GTT in your program
    - open the file
    - read the file
    - while there are still more records, do
    - insert into GTT
    - read file
    end-while
    - close the file

    use the GTT

    HTH

Posting Permissions

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