TPT without schema for STREAM Operator

Tools & Utilities
Enthusiast

Re: TPT without schema for STREAM Operator

I get the following error. 

Teradata Parallel Transporter Version 14.10.00.10 

TPT_INFRA: TPT04129: Error: No DBS table name could be associated with the

  $INSERT macro in job step '$MAIN'.

Job script preprocessing failed.

Enthusiast

Re: TPT without schema for STREAM Operator

I got it working by specifying table name after $INSERT macro. I didn't find this information in the user guide document. I had to try different options to get it working. SO the final script is

USING CHARACTER SET @v_utf 

DEFINE JOB load_template 

(

  APPLY $INSERT @v_tablename TO OPERATOR ($STREAM() ATTR (TdpId=@v_tdpid, UserName=@v_userid, UserPassword=@v_password, MaxSessions=@v_sessions, DateForm = 'ANSIDATE', Pack = @v_pack, WorkingDatabase = @v_database))

  SELECT * FROM OPERATOR($FILE_READER(DELIMITED @v_tablename) ATTR (FileName=@v_file_name, Format=@v_format, TextDelimiter=@v_delimiter_value, OpenMode = 'Read', IndicatorMode = @v_mode));

);

Teradata Employee

Re: TPT without schema for STREAM Operator

Very good! That was going to be my next recommendation.

-- SteveF