Teradata Parallel Transporter - queries

Tools
Enthusiast

Teradata Parallel Transporter - queries

Hi

I am using Teradata Parallel Transporter v13.10. I have few questions in this regard.

1. In MLOAD LAYOUT we can define .FILLER, which will not be sent to database. Can we define anything similar in TPT UPDATE also?

2. Running the following DDL step.

STEP DDL_STEP3

(

APPLY ('CREATE MULTISET TABLE DBNAME.SAMPLE2, NO FALLBACK (COL1 INTEGER NOT NULL,COL2 VARCHAR(20),COL3 DATE) PRIMARY INDEX(COL1) 

PARTITION BY RANGE_N(COL3 BETWEEN DATE '1980-01-01' AND DATE '2005-12-31' EACH INTERVAL '1' YEAR, NO RANGE) ; ')

TO OPERATOR (DDL_OPERATOR) ;

)

;

It is giving me error, '1980-01-01' missing RPAREN_ in rule. Can't we create a PPI table like the above using DATE ranges by TPT DDL operator?

3. Running the following TPT UPDATE script.

DEFINE JOB TPT_UPDATE_INSERT

DESCRIPTION 'TPT UPDATE OPERATOR TO INSERT DATA'

(

DEFINE SCHEMA SAMPLE1

(

C1 VARCHAR(10),

C2 VARCHAR(20)

)

;

STEP UPDATE_STEP

(

APPLY ('INSERT INTO DBNAME.SAMPLE1 VALUES (:C1, :C2) ') 

TO OPERATOR 

(

UPDATE_OPERATOR

TYPE UPDATE

SCHEMA *

ATTRIBUTES

(

VARCHAR PRIVATELOGNAME = 'UPDATE_LOG.txt',

VARCHAR LOGONMECH = 'LDAP',

VARCHAR TDPID = 'xxx',

VARCHAR USERNAME = 'yyy',

VARCHAR USERPASSWORD = 'zzz',

VARCHAR LOGTABLE = 'DBNAME.SAMPLE1_LOG',

VARCHAR TARGETTABLE = 'DBNAME.SAMPLE1',

VARCHAR ERRORTABLE1 = 'DBNAME.SAMPLE1_ET',

VARCHAR ERRORTABLE2 = 'DBNAME.SAMPLE1_UV',

VARCHAR WORKINGDATABASE = 'DBNAME'

)

)

SELECT * FROM 

OPERATOR

(

FILE_READER

TYPE DATACONNECTOR PRODUCER

SCHEMA SAMPLE1

ATTRIBUTES

(

VARCHAR PRIVATELOGNAME = 'FILE_READER_LOG.txt',

VARCHAR DIRECTORYPATH = 'C:\SAMPLE',

VARCHAR FILENAME = 'MLOAD_SAMPLE1.csv',

VARCHAR FORMAT = 'DELIMITED',

VARCHAR TEXTDELIMITER = ','

)

)

;

)

;

)

;

It is giving error, Operator 'UPDATE_OPERATOR' is undefined. Can't we define operators like this?

Responses from experts are appriciated.

Thanking You

Santanu Ghosh