Archives of the TeradataForum

Message Posted: Mon, 10 Jun 2013 @ 19:59:40 GMT

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

I am trying to run the below TPT script, written using templates. I am getting the error message below even though I count matching parenthesis. I am trying to copy a table from production to developement.

Can anyone see the problem.

Command Line: tbuild f tpt_copy_table.txt v tpt_var_file.txt

     File: tpt_copy_table.txt

     DEFINE JOB DATA_TRANSFER
     DESCRIPTION 'MOVE DATA FROM PRODUCTION TO DEVELOPMENT'
     (
     APPLY $INSERT 'DB_WRK.CUST_FACT_DAVID' TO OPERATOR($LOAD[2]) FROM OPERATOR ($export
     ('DB_WKR.CUST_FACT_DAVID')); );

     File: tpt_var_file.txt

     TARGETTDPID='TDDEV',
     TARGETUSERNAME='SYSDBA',
     TARGETUSERPASSWORD='xxxxxx',
     ERRORTABLE1='DB_WRK.CUST_FACT_ERROR1',
     ERRORTABLE2='DB_WRK.CUST_FACT_ERROR2',
     SOURCETDPID='TDPROD',
     SOURCEUSERNAME='SYSDBA',
     SOURCEUSERPASSWORD='xxxxxxx'

     Error:

     Teradata Parallel Transporter Version 13.10.00.05

     Job terminated with status 8.

     TPT_INFRA: TPT04049: Error: Line 6 of Job Script File 'tpt_copy_table.txt': Unmatched
     function parenthesis -- '(' -- for operator export.

     Job script preprocessing failed.

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