The Question is:
Regards to the Wizard(s)!
I apologize beforehand if this question was already answered. I did search for
it but didn't find any answers.
In summary: I'm trying to create a text file so that I can ftp it out. This
file is a combination of fields from different tables.
I can get the fields from one table and create the text file, but how do I:
Join the RCCHATIT table (on a specific field)with two other tables, and add
certain fields from those tables into my resulting file.
Here is the procedure :
REDEFINE PROCEDURE RDA2_GET_RCCHATIT
SET DICTIONARY RDA2_CDD
READY RCCHATIT, RCTITLE, MAGCAT
FIND RCCHATIT WITH RCT_YEAR=0 AND
RCT_QUARTER=1 AND RCT_NATIONAL_CODE=102
ON location output_file
PRINT ALL RCT_YEAR||","||RCT_QUARTER||
The Answer is :
Create the text file however, then use CONVERT/FDL command to convert
the text file to a stream LF format file, then use COPY/FTP to copy
the file. If the target system is OpenVMS, you could also zip the
intermediate file(s) using the "-Vv" option, and transfer the zipfile.