Modify column on a quoted column name

[jneasy]

Hi,

I am trying to rename a field using the following MODIFY spec.

Code: Select all

"MODE":string[50]=string_from_ustring(MODE);

But I get this error "Error parsing modify adapter"

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.

[asorrell]

You can't use quotes in column names in DataStage. The only legal special characters are dollar signs, underscores and periods.

I would think it is being translated to MODE when it enters DataStage. Try this for your specification:

NewName:string=MODE

To validate what names it is really using, turn on RCP and dump the Teradata Connector straight into a Peek. That will show the resulting column names in the Director log.

[jneasy]

I tried what you suggested asorrell - the peek named the column without quotes.

As a work around I renamed the target to an appropriate column name without double quotes then once the table was loaded I renamed the column back to the double quoted column name.

Cheers,
Joe

[asorrell]

A Column Alias without the quotes would also work...