TPT with Unicode columns in source.

Tools
Enthusiast

TPT with Unicode columns in source.

SCHEMA SECTION (NOT ALL COLUMNS):
--------------
DESCRIPTION 'TABLE table_ld ODBC SCHEMA'
  (
      SourceCol_1          NUMBER(38)
    , SourceCol_2          TIMESTAMP
    , SourceCol_3          VARCHAR(60) CHARACTER SET UNICODE
    , SourceCol_4          TIMESTAMP
    , SourceCol_5          VARCHAR(60) CHARACTER SET UNICODE
    , SourceCol_6          VARCHAR(60) CHARACTER SET UNICODE
    , SourceCol_7          TIMESTAMP
    , SourceCol_8          VARCHAR(20) CHARACTER SET UNICODE
    , SourceCol_9          VARCHAR(255) CHARACTER SET UNICODE
    , SourceCol_10         VARCHAR(20) CHARACTER SET UNICODE
    , SourceCol_11         VARCHAR(20) CHARACTER SET UNICODE
    , SourceCol_12         VARCHAR(255) CHARACTER SET UNICODE
    , SourceCol_13         VARCHAR(255) CHARACTER SET UNICODE
    , SourceCol_14         VARCHAR(60) CHARACTER SET UNICODE
    , SourceCol_15         VARCHAR(255) CHARACTER SET UNICODE
    , SourceCol_16         VARCHAR(60) CHARACTER SET UNICODE
    , SourceCol_17         VARCHAR(60) CHARACTER SET UNICODE
    , SourceCol_18         VARCHAR(255) CHARACTER SET UNICODE
    , SourceCol_19         VARCHAR(255) CHARACTER SET UNICODE
    , SourceCol_20         VARCHAR(255) CHARACTER SET UNICODE
    , SourceCol_21         VARCHAR(255) CHARACTER SET UNICODE
    , SourceCol_22         VARCHAR(255) CHARACTER SET UNICODE
    , SourceCol_23         VARCHAR(4000) CHARACTER SET UNICODE
    , SourceCol_24         VARCHAR(255) CHARACTER SET UNICODE
    , SourceCol_25         VARCHAR(60) CHARACTER SET UNICODE

APPLY SECTION:
-------------
APPLY
    (
      'INSERT INTO LoadTablesaa.branch_ld
      (
          id_num
        , created_date
        , created_by
        , last_modified
        , last_modified_by
        , lock_user
        , lock_date
        , state
        , cr_state
        , branch_type
        , release_target
        , cr_release_target
        , branch_name
        , responsible
        , cr_responsible
        , branch_manager
        , branch_steward
        , keywords
        , baseline_planned
        , baseline_actual
......
   )
      VALUES
      ( 
        :SourceCol_1
      , :SourceCol_2
      , :SourceCol_3
      , :SourceCol_4
      , :SourceCol_5
      , :SourceCol_6
      , :SourceCol_7
      , :SourceCol_8
      , :SourceCol_9
      , :SourceCol_10
      , :SourceCol_11
      , :SourceCol_12
      , :SourceCol_13
      , :SourceCol_14
      , :SourceCol_15
....
    )
    TO OPERATOR ( STREAM_OPERATOR[1])
    SELECT * FROM OPERATOR ( table_ld_READ_OPERATOR[1] );
 
TBUILD CALL:
-----------
tbuild -f $CTL_FILE -u "TDPassword = '$DSS_PWD', SRCPassword = '$SRC_PWD'" wsl-$LOAD_TABLE-$SEQUENCE >> $AUD_FILE

ERROR MESSAGE RECEIVED:
----------------------
TPT_INFRA: At "CHARACTER" missing { RPAREN_ COMMA_ MACROCHARSET_ METADATA_ OFFSET_ } in Rule: Column Definition

Compilation failed due to errors. Execution Plan was not generated
Job script compilation failed.
Teradata Parallel Transporter Version 14.10.00.02
Job terminated with status 8.

Hi,

We have been trying to load data using TPT from an oracle source that has unicode columns but have been getting errors while loading it. The problem we are getting is with the UNICODE columns.

Regards,

Indrajit

1 REPLY
Enthusiast

Re: TPT with Unicode columns in source.

Hi Indrajit,

The column definition should have the layout of the target table.

I believe you should define column Source_Col1 as INTEGER instead of NUMBER(38).

Thanks,

Aarsh