HP OpenVMS Systems

Datatrieve, text file format, and FTP?

» close window

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.
 
Thank you
-----------------------
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
SET COLUMNS_PAGE=132
BEGIN
  ON location output_file
  PRINT ALL RCT_YEAR||","||RCT_QUARTER||
     ","||RCT_NATIONAL_CODE||
     ","||RCT_BIPAD||","||RCT_RDA_AGENT_CODE||
     ","||RCT_SUGGESTED_RETAIL_PRICE||
     ","||RCT_WHOLESALE_COST||
     ","||RCT_ISSUES_PER_YEAR||","||RCT_SALE||
     ","||RCT_RETAIL_DOLLARS||
     ","||RCT_CLAIMED_RDA_DOLLARS||
     ","||RCT_CLAIMED_RDP_DOLLARS||
     ","||RCT_CLAIMED_RDS_DOLLARS||
END
 
 

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.
 

  

     

     
answer written or last revised on ( 17-DEC-2003 )
     
» close window