The EXTTYPE command is used to specify an ‘external’ format for source date fields. Dates can be represented in several different ways in a source field/column. This command allows you to specify the format of the date, as it exists in the source field/column.
Syntax
EXTTYPE <source_date_field>, <date_format>;
Keyword and Parameter Descriptions
| Keyword | Description |
|---|---|
| <source_date_field> |
The name of the source date field/column. |
| <date_format> |
The format of the date within the source date field/column may be any one of the following:
|
Example
Set the external date type for source_field1 to YYMMDD format.
EXTTYPE source_field1, DTYYMMDD;