Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Question Unanswered: Insert using select between two subsytems

    Hi

    How to insert by select between two subsystems.

    insert into dbxx.table1 --> sub system dbxa, TSO1
    select * from dbyy.table1 --> sub system dbya, TSO2

    ofcouse the above will not work, as both of them belong to different system.

    Please advise, whether we can do like this or not.
    This is just to avoid unload and load.

    Advise on any chance to do using insert and select

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    One way to do this is to access the other DB2 subsystem on OS/390 using DDF (distributed data facitliy). Check out DDF in the manuals. DDF would need to be enabled by your DB2 systems programmer.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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