How can I use the FileTransfer/OCX to download data from mulitple AS/400 files?
You can join data from several AS/400 files and download it to the PC using the TECA FileTransfer/OCX. To download data from multiple files you need to name those files in the select clause that’s entered in the Buffer property of the TECA FileTransfer/OCX. For instance, to join and download the data from two files named file1 and file2 in library datalib, you might enter the following SQL select statement in the Buffer property: SELECT * FROM datalib/file1, datalib/file2 WHERE T1.filekey = T2.filekey After setting the Buffer property you can set the ConvertAuto property to TF_TRUE, the FullFile property to TF_TRUE and the PCFile property to the name of your desired PC output file. Then evoke the SendRequest method followed by the RetreveRecords method. The two files will be joined on the filekey field and all of the data from both files will be downloaded to the PC. This simple example shows one option for downloading data from the AS/400. Many other options are also possible.
