Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Nov 2012 @ 20:45:07 GMT


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


Subj:   Re: A TPT with Load operator
 
From:   JAMES PARK

Please discard my previous mail.

TD 13 on Windows.

I've run this script to load some sample data to a table using TPT with load operator and am getting an error. I don't know what has gone wrong.

Thank you for your advice.

     --TPT script--
     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_Operator
     Description 'TPT Load Operator'
     Type Load
     Schema *
     Attributes
     (
      Integer TenacityHours     = 0,
      Integer BufferSize        = 16,
      Integer ErrorLimit        = 1,
      Varchar Tdpid             = 'xxxxxx',
      Varchar UserName          = 'xxxxxx',
      Varchar WorkingDatabase  = 'SBX_DW_TBLS',
      Varchar UserPassword      = 'xxxxxx',
      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 OpenMode = 'Read',
      VARCHAR FORMAT   = 'Formatted',
      VARCHAR IndicatorMode
     );

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

     SELECT * FROM OPERATOR(DATACONN);
     );



     --Output--
     C:\JPARK\Teradata\TPT_Scripts>tbuild -f tptflatload.bat
     Teradata Parallel Transporter Version 13.10.00.04
     Job log: C:\Program Files\Teradata\client\13.10\Teradata Parallel
     Transporter/lo
     gs/jpark-71.out
     Job id is jpark-71, running on XXXXXX
     Teradata Parallel Transporter Load Operator Version 13.10.00.03
     Load_Operator: private log not specified
     Teradata Parallel Transporter DataConnector Version 13.10.00.04
     DATACONN: TPT19008 DataConnector Producer operator Instances: 1
     DATACONN: TPT19003 ECI operator ID: DATACONN-4224
     DATACONN: TPT19404 pmOpen failed. Requested file not found (4)
     DATACONN: TPT19304 Fatal error opening file.
     DATACONN: TPT19221 Total files processed: 0.
     Load_Operator: connecting sessions
     Load_Operator: preparing target table
     Load_Operator: entering Acquisition Phase
     Load_Operator: disconnecting sessions
     Load_Operator: Total processor time used = '1.34375 Second(s)'
     Load_Operator: Start : Wed Nov 14 15:16:23 2012
     Load_Operator: End   : Wed Nov 14 15:16:33 2012
     Job step MAIN_STEP terminated (status 12)
     Job jpark terminated (status 12)



     --input file content--
     7,"James"
     8,"Tom"

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: 15 Jun 2023