TPT Schema Error

Tools & Utilities

TPT Schema Error

Hi ,

 

I'm trying to create schema for TPT using Below command. But I'm getting an error.

DEFINE SCHEMA SUPPLEMENTARY FROM TABLE 'abc.SUPPLEMENTARY';

 

Log:

TPT_INFRA: Syntax error at or near line 6 of Job Script File '/tmp/v4/qstart.txt':
TPT_INFRA: At "FROM" missing LPAREN_ in Rule: Explicit Schema Element List
TPT_INFRA: Syntax error at or near line 6 of Job Script File '/tmp/v4/qstart.txt':
TPT_INFRA: TPT03020: Rule: DEFINE SCHEMA
Compilation failed due to errors. Execution Plan was not generated.
Job script compilation failed.

 

script


DEFINE JOB qstart
(

DEFINE SCHEMA SUPPLEMENTARY FROM TABLE 'abc.SUPPLEMENTARY';


Define OPERATOR FILE_WRITER()
TYPE DATACONNECTOR CONSUMER
SCHEMA *
ATTRIBUTES
(
VARCHAR FileName='SUPPLEMENTARY.txt',
VARCHAR OPENMODE = 'WRITE',
VARCHAR Format = 'Delimited',
VARCHAR TextDelimiter ='|'

);

 


DEFINE OPERATOR EXPORT_OPERATOR
DESCRIPTION 'TERADATA PARALLEL TRANSPORTER EXPORT OPERATOR'
TYPE EXPORT
SCHEMA SUPPLEMENTARY
ATTRIBUTES

( VARCHAR PrivateLogName='SUPPLEMENTARY_log',
INTEGER MaxSessions=20,
INTEGER MaxDecimalDigits=38,
VARCHAR TdpId = @TargetTdpId,
VARCHAR UserName = @TargetUserName,
VARCHAR UserPassword = @TargetUserPassword,
VARCHAR OSCMD = 'rm -f /tmp/v4/jobvar.txt',
VARCHAR SelectStmt='SELECT * from abc.SUPPLEMENTARY where mis_dt=''2016-06-30;'''
);

APPLY TO OPERATOR (FILE_WRITER())
SELECT * FROM OPERATOR (EXPORT_OPERATOR() [1]);
);

 

 

Please Help on the same.

Thanks.

3 REPLIES
Teradata Employee

Re: TPT Schema Error

What version of TPT are you using (I take you script and run it and it works for me)?

 

 

-- SteveF

Re: TPT Schema Error

Hi Feinz,

I'm using tpt version 13. will it not work ?

Thanks
Vignesh
Teradata Employee

Re: TPT Schema Error

No. That feature was introduced way after 13.

What documentation were you looking at?

We do not even support TPT 13.0 anymore.

-- SteveF