Samples

The parts for Exceptions file data are as follows.

Examples of CREATE TABLE and LOAD statements are in library RKO2SAMP. The description files are in a format that can be loaded into Db2 tables.

The CREATE TABLE example can be used for building the Db2 tables into which File data sets can be loaded. The Db2 load utility control statements can be used for loading these File output records into Db2 tables.

The query in DGOEQFIL uses the sample view defined in DGOEVFIL.

Table 1. Parts for Exceptions file data
Type of data CREATE TABLE statements LOAD control statements Sample query Table description
Exception DGOECFIL DGOELFIL DGOEQFIL DGOEBFIL