Previous Topic: SQL Procedure ExampleNext Topic: Premap Process


Work Records

To access the procedure parameters, the CA ADS dialog should include the <schema>.<procedure_name> as a work record. This record does not reside in the dictionary; it is automatically constructed by the CA ADS dialog compiler (ADSC or ADSOBCOM) when the dialog is compiled. The following DDDL syntax defines the global work area record:

ADD RECORD NAME GETPAREA-SQLPROC-GLOBAL-AREA.
 03 AREA-C                     PIC   X OCCURS 25.

The work records included in the mapless dialog GETPAREA are provided next: