Transferring data from a database file to a stream file

 

To transfer a file from a database file to a stream file on your system, follow these steps.

  1. Establish a connection to the system.

  2. Map a network drive to the appropriate path in the i5/OS® file system.

  3. From the iSeries™ Access for Windows® window, click Data Transfer From iSeries server .

  4. Select the system you want to transfer from.

  5. Select the file names, using the i5/OS database library and file name to copy from, and the network drive for the location of the resulting stream file. You can also click PC File Details to select the PC file format for the stream file. Data transfer supports common PC file types, such as ASCII text, BIFF3, CSV, DIF, Tab-delimited Text, or WK4.

  6. Click Transfer data from iSeries to run the file transfer.

You can also perform this data movement in a batch job with the data transfer applications. Proceed as above, but select the File menu option to save the transfer request. The Data Transfer To iSeries server application creates a .DTT or a .TFR file. The Data Transfer From iSeries server application creates a .DTF or a .TTO file. In the iSeries Access Family directory, two programs can be run in batch from a command line:

You can set either of these commands to run on a scheduled basis by using a scheduler application. For example, you can use the System Agent Tool (a part of the Microsoft® Plus Pack) to specify the program to run (for instance, RTOPCB MYFILE.TTO) and the time at which you want to run the program.

 

Parent topic:

Copying data using data-transfer functions