soundex field name in schema
Posted: Wed Feb 08, 2012 9:49 am
we are using a generic job for loading the data from sequential file to a teradara(using RCP and schema file).
In our schema file we are having a field as "soundex" which has to be mapped to the target teradata table "soundex".
we can able to create the table in teradata by putting double quotes around soundex field in the ddl since soundex is a keyword/function in teradata.
Now the table got created but we cannot able to load the data because while insert into table datastage is throwing error as keyword soundex found in the generated insert statement.
As per our agreement we cannot rename the field name so how can we handle this??? Anything we can add escape sequence in schema file for soundex field...
In our schema file we are having a field as "soundex" which has to be mapped to the target teradata table "soundex".
we can able to create the table in teradata by putting double quotes around soundex field in the ddl since soundex is a keyword/function in teradata.
Now the table got created but we cannot able to load the data because while insert into table datastage is throwing error as keyword soundex found in the generated insert statement.
As per our agreement we cannot rename the field name so how can we handle this??? Anything we can add escape sequence in schema file for soundex field...