Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Nov 2012 @ 17:46:40 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   A TPT with Load operator
 
From:   JAMES PARK

Esteemed DBAs,

TD 13 on Windows 2003 XP.

I am trying to load some sample data to a table using TPT with Load operator. Below is the script and the result.

Could you tell me what to fix in the script?


Thank you,

     --------------------------------------------------------------------
     Define Job TPT_LOAD_SOURCE
     Description 'Load the source_Emp_Table'
      (
        Define Schema Input_flat_file_Schema
        Description 'TPT Load Operator'
        (Emp_ID            Integer,
         Emp_Name          Char(10)
      );

     Define operator Load_Operatior
     Description 'TPT Load Operator'
     Type Load
     Schema *
     Attributes
     (Integer TenacityHours     = 0,
      Integer BufferSize        = 16,
      Integer ErrorLimit        = 1,
      Varchar Tdpid             = 'xxxxxxxx',
      Varchar UserName          = 'xxxxxx',
      Varchar Working Database  = 'SBX_DW_TBLS',
      Varchar UserPassword      = 'xxxxxxxx',
      Varchar TargetTable       = 'Source_EMP_Table',
      Varchar LogTable          = 'SBX_WK_TBLS.Source_LOG',
      Varchar ErrorTable1       = 'SBX_WK_TBLS.Source_ERROR1',
      Varchar ErrorTable2       = 'SBX_WK_TBLS.Source_ERROR2'
      );

     DEFINE OPERATOR DATACONN
     DESCRIPTION 'TPT Data Connector Operator'
     TYPE DATACONNECTOR PRODUCER
     SCHEMA Input_flat_file_schema
     ATTRIBUTES
     (
      VARCHAR FileName = 'C:\JPARK\Teradata\TPT_Scripts\testdata.txt',
      VARCHAR Open Mode = 'Read',
      VARCHAR FORMAT    = 'Formated',
      VARCHAR IndicatorMode
     );

     APPLY ('INSERT INTO SBX_DW_TBLS.SOURCE_EMP_TABLE
             (:Emp_ID,
              :Emp_name);')
     TO OPERATOR(Load_Operator [3])

     SELECT * FROM OPERATOR(DATACONN);

     --------------------------------------------------------------------
     C:\JPARK\Teradata\TPT_Scripts>tbuild -f tptflatload.bat
     Teradata Parallel Transporter Version 13.10.00.04
     TPT_INFRA: Syntax error at or near line 20 of Job Script File 'tptflatload.bat':

     TPT_INFRA: At "Varchar"; "Varchar" not in { LPAREN_ EQUALS_ ARRAY_
     VARCHAR_VARYING_ REGULAR_IDENTIFIER_ EXTENDED_IDENTIFIER_ EXTENDED_IDENTIFIER_NO_N_ }
     in Rule: Attribute Definition
     Compilation failed due to errors. Execution Plan was not generated.
     Job script compilation failed.
     Job terminated with status 8.

James Park
Database Specialist II



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016