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),
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.