Teradata Parallel Transporter Version 15.00.00.00 Job terminated with status 8. error while trying to export data from teradata table to flat file.
below is the code used;
DEFINE JOB EXPORT_Data_FILE
DESCRIPTION 'Export rows from a Teradata table to a file'
(
DEFINE SCHEMA CE_SCHEMA
(
Nm VARCHAR(50),
Nm1 VARCHAR(50)
);
DEFINE OPERATOR FILE_WRITER()
TYPE DATACONNECTOR CONSUMER
SCHEMA *
ATTRIBUTES
(
VARCHAR PrivateLogName = 'file_writer_privatelog',
VARCHAR FileName = 'CMSample.txt',
VARCHAR IndicatorMode = 'N',
VARCHAR OpenMode = 'Write',
VARCHAR Format = 'formatted'
);
DEFINE OPERATOR EXPORT_OPERATOR()
TYPE EXPORT SCHEMA CE_SCHEMA
ATTRIBUTES
(
VARCHAR PrivateLogName = 'export_privatelog',
INTEGER MaxSessions = 32,
INTEGER MinSessions = 1,
VARCHAR TdpId = Id,
VARCHAR UserName= 'username',
VARCHAR UserPassword='password',
VARCHAR AccountId,
VARCHAR SelectStmt = 'SELECT TRIM(CAST(Nm AS VARCHAR(50))) , TRIM(CAST(Nm1 AS VARCHAR(50))) FROM database.tablename;'
);
STEP export_to_file
(
APPLY TO OPERATOR (FILE_WRITER() )
SELECT * FROM OPERATOR (EXPORT_OPERATOR() [1] );
);
);
command used : C:\tbuild -f <filename.txt> logname.txt
Any Help on this?
