|
Field Qualification |
Scroll |
Qualifying a source/target field is accomplished specifying either a two (2) part or a three (3) part name for the field.
•A two (2) part name consists of the datastore alias and the field name.
•A three (3) part name consists of the datastore alias, description alias and the field name.
•Each of the parts must be separated by a period (.).
Example
The following example illustrates how to specify a two (2) part and three (3) part name for the target field FIELDA. The target datastore alias name is DS_OUT and the description alias is DESCR.
DESCRIPTION SQLDDL DD:DDLDESC AS DESCR;
DATASTORE DD:INPUT OF BINARY
AS DS_IN
DESCRIBED BY DESCR;
DATASTORE MQS:///OUTPUT_QUEUE
OF XMLCDC AS DS_OUT
DESCRIBED BY DESCR;
PROCESS INTO EMPL_OUT
SELECT
{
DS_OUT.FIELDA = DS_IN.FIELDA <== 2 part name qualification
DS_OUT.DESCR.FIELDA = DS_IN.DESCR.FIELDA <== 3 part name qualification
}
FROM DS_IN;
