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

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

    Hi,

    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.

    sjalis

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    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
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - 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
  •