Data Build Manual

Customizing SQL-LOAD Output
Customizing Data Build
099331 Tandem Computers Incorporated 6–11
7. The PROCLIB file, created by the GENERATE (F3) Step, contains code to convert
FIELDA (in place in the input record) and to move it to the output record.
FIELDA was deleted from the output record in step 4 above. Modify PROCLIB to
delete the following statement:
MOVE FIELDA OF input-rec TO FIELDA OF output-rec .
8. Add code to the USERLIB file in user-exit section U-OUT-filename-FIELDA, the
user exit after FIELDA is processed. The “after” exit is used so that the EBCDIC
input data will be converted to ASCII. The rest of the record processing and the
SQLCI loading of the record is bypassed by going to paragraph
P-IN-filename-EXIT.
?SECTION U-OUT- filename -FIELDA
IF FIELDA OF input-rec NOT = “xxx”
GO TO P-IN- filename -EXIT
9. Perform the CREATE (F4) Step and check the spooler output.
10. Perform RUN (F5) Step.
Modifying the
Generated COBOL85
Conversion Program
Some customizations may not be possible by adding user exit code to USERLIB or
modifying the generated procedures in PROCLIB. The generated source code is in file
ZZPROGM. If it is necessary to modify this code, ZZPROGM must be compiled
outside of Data Build because the CREATE (F4) step will rebuild ZZPROGM. The
following will compile ZZPROGM outside of Data Build:
Output Compiling ZZPROGM Outside of Data Build
SQL-INSERT or
SQL-LOAD
OBEY XSQLCMPL
ENSCRIBE COBOL85 /IN ZZPROGM, OUT $S.#PGMMOD/ ZZPROGMX
Customizing SQL-
LOAD Output
The following four subsections provide information on Data Build SQL-LOAD. The
information builds on itself leading to user-customization and includes:
The overall Data Build flow for SQL-LOAD processing and its use of SQLCI
How standard SQLCI loads nulls
The Data Build implementation for loading nulls
User-customization to extend the standard Data Build SQL null handling
SQL-LOAD Process
Overview
The following information applies to data conversions using the SQL-LOAD option.
For an SQL-LOAD operation, the generated COBOL85 Conversion Program feeds data
to a separate SQLCI process that loads the table. The Conversion Program code does
not perform any SQL operations.
In the RUN (F5) step, Data Build starts three processes:
Conversion program