Results 1 to 3 of 3

Thread: Dynamic SQL?!

  1. #1
    Join Date
    Dec 2004
    Posts
    2

    Lightbulb Unanswered: Dynamic SQL?!

    Hi!!!

    I need to insert into a table the results of a query that is stored in another table's record... I know it could be done in Oracle, but I'm hoping I can develop it in Informix... I was plannig on creating a procedure that would read the field then execute the query and insert the records.

    Does anyone know if it can be done on Informix 9.x Dynamic Server?

    Thanks in advance.

  2. #2
    Join Date
    Nov 2004
    Posts
    143
    Hi,

    You can unload the data of the first query to a flat file using

    unload to temp.dat
    select x,y,z form table_abc;

    Then insert the data to the destination table using

    load from temp.dat
    insert into dest_table

    Hope it helps.

  3. #3
    Join Date
    Dec 2004
    Posts
    2
    I'll give it a try...

    Thanks.

Posting Permissions

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