I am trying to rename a field using the following MODIFY spec.
Code: Select all
"MODE":string[50]=string_from_ustring(MODE);
I have a generic job using RCP to SELECT * from a DB2 then load into Teradata
DB2 --> Modify --> Teradata
The Teradata table defines the column with double quotes as "MODE" but I can't seem to define the column name with double quotes.
Any ideas?
Cheers,
Joe.