TPT ERROR: TPT19100 & TPT19015 help please!

Database
Enthusiast

TPT ERROR: TPT19100 & TPT19015 help please!

Hi

 

Am running TPT mainframe script to move the data from Mainframe file to Teredata database.

I can see job entering Acquisition Phase there is  some issues in FILE_READERÝ1¨.

So am getting following errors

FILE_READERÝ1¨: TPT19100 Unanticipated function failure. Function not implemented.'.Function return code is '134'.

FILE_READERÝ1¨: TPT19015 TPT Exit code set to 12.

 

Any one please help on this, here is my script

 

4 REPLIES
Enthusiast

Re: TPT ERROR: TPT19100 & TPT19015 help please!

file reader

DEFINE OPERATOR FILE_READER() DESCRIPTION 'TERADATA PARALLEL TRANSPORTER DATA CONNECTOR OPERATOR' TYPE DATACONNECTOR PRODUCER SCHEMA TPTLOYEE_SCHEMA ATTRIBUTES ( VARCHAR PrivateLogName = 'TPTT_dataconnoper_reader_privatelog', VARCHAR FileName = '&TPTT_FILENAM.', VARCHAR IndicatorMode = 'N', VARCHAR OpenMode = 'Read', VARCHAR Format = 'FORMATTED'

Teradata Employee

Re: TPT ERROR: TPT19100 & TPT19015 help please!

TPT script variables are referenced as @variable, not &variable. You can't reference JCL variables within the TPT script.

(You potentially can pass the value of the JCL variable to a script variable via command line parameter.)

Enthusiast

Re: TPT ERROR: TPT19100 & TPT19015 help please!

Thanks .

 

We can pass the mainframe PS file in filename like below. But i tried this but file it not opening

 

 

varchar FileName = '@**bleep**.**bleep**.**bleep**',

 

Please help how to pass the mainframe PS file ?

Enthusiast

Re: TPT ERROR: TPT19100 & TPT19015 help please!

Thanks

 

I got it. File name should be pass like below

 

Varchar FileName = 'DD:file.name