All Forums Tools
gpolanch 46 posts Joined 12/11
13 Sep 2012
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
 

feinholz 1234 posts Joined 05/08
14 Sep 2012

Remove the "CASESPECIFIC" keyword.
It is not part of the syntax.
 

--SteveF

You must sign in to leave a comment.