Issue with my first Teradata PT

Tools
Enthusiast

Issue with my first Teradata PT

Hi everybody,

I used the sample scripts that come with Teradata client for my first script.

What i succed to do is to create an empty table using these 2 scripts:

1*First script of configuration(jobvars1.txt):

 TargetTdpId          = 'XXX'

,TargetUserName       = 'YYYY'

,TargetUserPassword   = 'ZZZZ'

',DDLPrivateLogName    = 'ddlprivate.log'

,LoadPrivateLogName   = 'loadprivate.log'

,TargetErrorList      = ['3807']

,TargetTable          = 'EMP_TABLE'

,LogTable             = 'EMP_TABLE_LOG'

,ErrorTable1          = 'EMP_TABLE_E1'

,ErrorTable2          = 'EMP_TABLE_E2'

,SourceFileName       = 'flatfile1.dat'

,SourceFormat         = 'delimited'

,SourceTextDelimiter  = '|'

,OpenMode             = 'read'

2*Second script of configuration(jobvars1.txt):

DEFINE JOB qsetup1

(

APPLY

('DROP TABLE EMP_TABLE;')

,('CREATE TABLE EMP_TABLE(EMP_ID VARCHAR(10), EMP_NAME VARCHAR(10));')

TO OPERATOR ($DDL);

);

when i check in teradata using a basic SQL : select * from EMP_TABLE;

i have no records which is normal.

But when i execute the third script which is as follow:

DEFINE JOB qstart1

(

  APPLY $INSERT TO OPERATOR($LOAD)

  SELECT * FROM OPERATOR($FILE_READER);

);

and i execute the command "tbuild -f qstart1.txt -v jobvars1.txt -j qstart1" i have the following output:

$ tbuild -f qstart1.txt -v jobvars1.txt -j qstart1

Teradata Parallel Transporter Version 14.10.00.04

Job log: /opt/teradata/client/14.10/tbuild/logs/qstart1-27.out

Job id is qstart1-27, running on rgtdvdwhfr

Found CheckPoint file: /opt/teradata/client/14.10/tbuild/checkpoint/qstart1LVCP

This is a restart job; it restarts at step MAIN_STEP.

Teradata Parallel Transporter Load Operator Version 14.10.00.04

$LOAD: private log specified: loadprivate.log

Teradata Parallel Transporter $FILE_READER: TPT19006 Version 14.10.00.04

$FILE_READER Instance 1 directing private log report to 'dtacop-achouaf-22151170-1'.

$LOAD: connecting sessions

$FILE_READER: TPT19003 NotifyMethod: 'None (default)'

$FILE_READER: TPT19008 DataConnector Producer operator Instances: 1

$FILE_READER: TPT19003 ECI operator ID: '$FILE_READER-22151170'

$FILE_READER: TPT19222 Operator instance 1 processing file 'flatfile1.dat'.

$LOAD: preparing target table

$LOAD: entering Acquisition Phase

$LOAD: entering Application Phase

$LOAD: Statistics for Target Table:  'EMP_TABLE'

$LOAD: Total Rows Sent To RDBMS:      10

$LOAD: Total Rows Applied:            10

$LOAD: Total Rows in Error Table 1:   0

$LOAD: Total Rows in Error Table 2:   0

$LOAD: Total Duplicate Rows:          0

$FILE_READER: TPT19221 Total files processed: 1.

$LOAD: disconnecting sessions

$LOAD: Total processor time used = '0.403198 Second(s)'

$LOAD: Start : Thu Jan  8 10:37:13 2015

$LOAD: End   : Thu Jan  8 10:37:21 2015

Job step MAIN_STEP completed successfully

Job qstart1 completed successfully

Job start: Thu Jan  8 10:37:12 2015

Job end:   Thu Jan  8 10:37:21 2015

which means that everything went correctly however when i check my table i don't found any record in it.

Could anyone helps me on that please?

1 REPLY
Teradata Employee

Re: Issue with my first Teradata PT

Unfortunately, hard to help without more information.

You would need to provide screenshots of BTEQ commands or some other tool showing the before and after of the load of the target table (in a way, you have to prove to us that the rows are really not there).

It is pretty difficult to understand how the load can reflect that 10 rows were "applied" and yet they are not there. "Applied" means the database has indicated to the load tool that the rows are there.

-- SteveF