Archives of the TeradataForum

Message Posted: Fri, 25 Feb 2011 @ 14:16:08 GMT

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

Dear users,

When I ran this script using Command Prompt I got below error. Any idea what I should fix to make this run?

Thank you for your continual support!

     DEFINE JOB Export_to_File
     DESCRIPTION 'Export 1000 account rows from the SYSDBA.accounts table.'
     (
      DEFINE SCHEMA SYSDBA_Schema
           (
      cast(cast(Account_Number INTEGER as format 'Z(9)9') as char(10))  '0D0A'xc,
     cast(cast(Number INTEGERas format 'Z(9)9') as char(10))  '0D0A'xc,
         Street CHARACTER(25),
         City CHARACTER(20),
         State CHARACTER(2),
      cast(cast(Zip_Code INTEGER as format 'Z(9)9)' as char(10))  '0D0A'xc,
         Balance_Forward DECIMAL(10, 2),
         Balance_Current DECIMAL(10, 2)
          );

     DEFINE OPERATOR Data_Connector
        TYPE DATACONNECTOR CONSUMER
        SCHEMA SYSDBA_Schema
        ATTRIBUTES
        (
        VARCHAR FileName = 'Export_10000',
        VARCHAR Format  = 'FORMATTED',
        VARCHAR OpenMode = 'Write',
        VARCHAR IndicatorMode = 'Y',
        VARCHAR TextDelimiter = '|'
        );




     C:\courses\Teradata Parallel Transporter\Lab Tests>tbuild -f fexp1000.txt
     Teradata Parallel Transporter Version 13.00.00.06 line 4: syntax error at "cast"
     missing RPAREN_ in Rule: Explicit Schema Element List
     TPT_INFRA: TPT03020: Error: Syntax error occurred in parse rule Rule: DEFINE SCH EMA
     TPT_INFRA: TPT03050: Error: Semantic error at or near job script line 17:
     Schema 'SYSDBA_Schema' is undefined.
     Schema cannot be resolved.
     TPT_INFRA: TPT03050: Error: Semantic error at or near job script line 29:
     Schema 'SYSDBA_Schema' is undefined.
     Schema cannot be resolved.
     Compilation failed due to errors. Execution Plan was not generated.
     Job script compilation failed.
     Job terminated with status 8.

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