Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   TPT04049: Error: Unmatched function parenthesis
 
From:   DAVID WILLIAMS

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016