TPT Extract not working for column name starting with FROM_

Tools

TPT Extract not working for column name starting with FROM_

I got the below mentioned error when I had column name starting with FROM_ in the table.

TPT_INFRA: TPT02932: Error: TPT_INFRA: TPT02934: Error: invalid token

 near line 193 (text was '_')

line 193: syntax error at "FROM" missing { REGULAR_IDENTIFIER_ EXTENDED_IDENTIFIER_ EXTENDED_IDENTIFIER_NO_N_ } in Rule: Regular Identifier

TPT_INFRA: TPT03022: Error: Syntax error occurred in parse rule Rule: Column Definition

TPT_INFRA: TPT03050: Error: Semantic error at or near job script line 233:

Schema 'SCHEMA_MBL_CARD_EVT_Config_dat_extract' is undefined.

  Schema cannot be resolved.

TPT_INFRA: TPT03050: Error: Semantic error at or near job script line 474:

Schema 'SCHEMA_MBL_CARD_EVT_Config_dat_extract' is undefined.

  Schema cannot be resolved.

Compilation failed due to errors. Execution Plan was not generated.

Job script compilation failed.

When I removed the column from the script, it just worked fine.

Is there anything I need to take care in order to make it work.

I know that I can have alias in the schema and export operator select. That is the work around I found but shouldnt tpt work for any columnname?

1 REPLY
Teradata Employee

Re: TPT Extract not working for column name starting with FROM_

As always, it would be helpful if you could post the version of TPT you are running and a copy of the script.

-- SteveF