If the goal is to transfer data to the development system for testing purposes then an easy way is to save the necessary objects to a *SAVF, FTP the *SAVF to the development system, and restore the objects to the development libraries. This can be easily automated if you want periodic updates to the development system and is the process I use across my systems. This has the added benefit of isolating production data from development errors.
There are many other ways to also accomplish this.
Bruce Vining Services
Thank You, already familiar with this process. We are using SQL/Cobol so we can select records based on key information from multiple files in order to create a test environment for our programmers. Our code goes something like
INSERT INTO PGMRLIB/FILEA
SELECT *FROM PRODLIB/FILEA
WHERE IDKEY = ‘Key#’
Again things worked great when production and development were on one system, our issue is Connecting to 2 databases, 1 on each system.
It’s possible to connect easily to two different databases at the same time, but it requires a product to enable it.
In order to retrieve rows from one database and write into another with SQL yourself without additional products, you will need to code your SQL/COBOL using SQL CLI.