Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007

    Unanswered: read from tables in 1 informix database server and write into another


    I have some tables which are in a database of 1 informix database server (say prodServer)

    I need to fetch data from tables in the prodServer and write into tables in another informix database server (say QAServer).

    The 2 servers have database connectivity with each other.

    My sql scripts will be in the QAServer.

    I would greatly appreciate your help. Thank you.


  2. #2
    Join Date
    Apr 2007
    Jundiai / SP - Brasil
    insert into table table_zyx
    select * from db1@prodServer:table_xyz

    If you need some logical process on data transfered from prodSever, maybe you need write a SPL (Stored Procedure) and work with cursors, variables, ifs,foreachs,....
    More about SPL, read the Informix SQL Syntax Manual...
    César Inacio Martins
    Jundiai / SP - Brasil - em Português - English (translated by Google).

Posting Permissions

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