Valid for
Extract, Replicat
Description
Use EXPANDDDL
to format Enscribe data. Enscribe DDL definitions frequently contain occurs
, or array items. For example, a definition might contain:
05 GROUP1 OCCURS 3 TIMES. 10 FIELD1 PIC X(5) OCCURS 20 TIMES.
To reference items within arrayed structures in a WHERE
, FILTER
, or COLMAP
clause, you must identify the occurrence. The default syntax for doing so is: field_name
-occurrence
. For example, to retrieve the second occurrence of FIELD1
in the third group, the syntax would be GROUP1-3.FIELD1-2
The EXPANDDDL
parameter changes this array notation. For example:
EXPANDDDL USEBRACKETS
specifies field as GROUP1[3].FIELD1[2]
EXPANDDDL USETWOUNDERSCORES, ZEROFILL ARRAYWIDTH
specifies field as GROUP1__3.FIELD1__02
, when the maximum array width in GROUP1
is less than 10 (requiring at most one digit) and the maximum array width of FIELD1
is 20 (requiring two digits).
EXPANDDDL
also determines how field occurrences are output when or FORMATSQL
are specified.
Syntax
EXPANDDDL format [, ZEROFILL width | ARRAYWIDTH] [, INCLUDEREDEFS | OMITREDEFS] [, RESOLVEDUPINDEX] [, RESOLVEDUPGROUP] [, EXPANDGROUPARRAYS]
format
Can be one of the following:
USEDASH
— Reference array items by –n
, where n
is the occurrence number.
USEBRACKETS
— Reference array items by [n]
, where n
is the occurrence number.
USEUNDERSCORE
— Reference array items by _n
, where n
is the occurrence number.
USETWOUNDERSCORES
— Reference array items by __n
, where n
is the occurrence number.
ZEROFILL
width
| ARRAYWIDTH
Directs Extract to reference occurrences of each field adjusting for a maximum width.
INCLUDEREDEFS | OMITREDEFS
INCLUDEREDEFS
includes redefined fields.
OMITREDEFS
is the default. It excludes redefined fields, which has the following consequences:
Data is only output to columns that do not redefine another field.
When Extract specifies FORMATASCII
or FORMATSQL
, Extract does not output redefined fields.
RESOLVEDUPINDEX
Appends a numerical index to the end of each duplicate field or column. For example, END-DATE.YY
would become YY-2
in the output since it is the second occurrence of YY
in the definition.
RESOLVEDUPGROUP
Prefixes a duplicate field name with its group name and separator.
EXPANDGROUPARRAYS
Appends indexes to fields that do not necessarily occur multiple times, but which are part of groups that occur multiple times.