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

    Unanswered: Inserting Data using a Stored Procedure

    In Microsoft SQL I can run the following command:

    insert into table execute proc1

    to insert data into a table.

    Is there a comparable way to do this in DB2?
    jaraba

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You could use a "table function":
    Code:
    insert into table select ... from table (proc1()) tbl
    See the application development manual for more info.

Posting Permissions

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