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;