DSNTIAUL (an assembler program used to process select statements dynamically) is used to unload the tables, or to get the results of an SQL select in the unload format. No details about the query will be displayed, just the resultset will be in the SYSPRINT. Unloading the whole table. //STEP0001 EXEC PGM=IKJEFT01 //STEPLIB DD DISP=SHR, [...]
-
Search
-
Easytrieve PDF
-
Topics
-
Easytrieve
- Variable declaration
- Working Storage variables
- COMP and COMP-3 equivalent variables
- Equivalent functionality for REDEFINES
- OCCURS clause
- FILE-STATUS and EOF (End of File)
- JOB INPUT statements
- Moving Numeric values between variables
- File Handling
- GET and PUT statements
- READ and WRITE statements
- Arithmetic and Logical operators
- Reading VSAM File
- Update RE-WRITE VSAM File
- Report creation sample
- Synchronized Files
- Using Files as Lookup tables
- Embedded DB2 SQL
- DO WHILE clause
- CASE WHEN statement
- Easytrieve Macros
- Keywords
-
DB2
- Logical Operators
- Using MAXASSIGNEDVAL from SYSIBM.SYSSEQUENCES (IBM DB2 for Z OS)
- Creating (Declaring), Inserting data into DB2 temporary tables
- Using IKJEFT01 for Binding a normal batch DB2 program
- Using IKJEFT01 for running a normal batch DB2 program
- Running DSNTIAUL using IKJEFT01 for batch unload
- Running DSNTEP2 / DSNTEP4 using IKJEFT01 for batch SQL(DB2) processing
-
Recent Comments
- Karthik on Moving Numeric values between variables in Easytrieve
- pavan on Moving Numeric values between variables in Easytrieve
- EDIT MASKS – Masking variables in Easytrieve on Easytrieve – Variable declaration
- Easytrieve – File Handling and File Declaration on Easytrieve MACROs (Copybook)
- Karthik on Easytrieve File matching : Synchronized Files
-
Subscribe