Using MACROCHARSET in TPT

Tools

Using MACROCHARSET in TPT

Hello,

Is it possible to set the character set when doing DEFINE SCHEMA in a TPT script?  (as below)

DEFINE SCHEMA Stage_Schema

(

MY_ID       VARCHAR(18) MACROCHARSET (LATIN CASESPECIFIC),                    

MY_STR     VARCHAR(30)                                                   

);

When trying this with TPT 13.10.00.04 , I get the following error:

TPT_INFRA: Syntax error at or near line 27 of Job Script File 'O:\tpt_scripts\tbuild_td_stage.txt':

TPT_INFRA: At "CASESPECIFIC" missing RPAREN_ in Rule: Column Definition

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

Job script compilation failed.

If not, is it possible to create the table with the desired characer set prior to running TPT?  In the past, I have not had luck doing that.

Thanks,

-Greg

1 REPLY
Teradata Employee

Re: Using MACROCHARSET in TPT

Remove the "CASESPECIFIC" keyword.

It is not part of the syntax.

-- SteveF