International Software Products

Home  |   Products & Services  |  Support   |   Offices   |   Partners   |   Contact Us

FIRST Code

Sample FIRST Statements for selecting IDD Data

SAMPLE #3:

• The output file will be in Comma Separated Variable (ASCII delimited) format.
• Retrieve all LOADHDR-156 records from the LOAD area with names beginning with KC and OC.
• Select only the LOAD module name, VERSION, DATE and TIME fields.

PROC ASI2 OUT=TEST ;

SSNAME='IDMSNWKA' ;

REUSE ;

DB IDMSNWKA WITHIN IDMSNTWK VERSION 1. ;

OUTPUT TRANSFER ;

LOADHDR-156 SEQUENTIAL DDLDCLOD COMPLETE

WHEN LOADHDR-MODNAME-156 EQ KC*

OR LOADHDR-MODNAME-156 EQ OC*;

SELECT LOADHDR-MODNAME-156 LOADMOD ;

SELECT LOADHDR-VERS-156 LOADVER C ;

SELECT LOADHDR-DATE-156 LOADDATE;

SELECT LOADHDR-TIME-156 LOADTIME;

FIRST/FIRSTLR Sample 1

FIRST/FIRSTLR Sample 2

---

All Trademarks Acknowledged

Copyright 2012 International Software Products. All Rights Reserved.