title: Data load with Teradata TPT failing
body: <p>Here i'm trying load a csv file into teradata tables using TPT utility
  ,but is filing with an error:</p>
  
  <p><strong>Here is my TPT script:</strong> </p>
  
  <pre><code>DEFINE JOB test_tpt
  DESCRIPTION 'Load a Teradata table from a file'
  (
  DEFINE SCHEMA SCHEMA_EMP_NAME
  (
  NAME VARCHAR(50),
  AGE VARCHAR(50)    
  );
  
  DEFINE OPERATOR od_EMP_NAME
  TYPE DDL
  ATTRIBUTES
  (
  VARCHAR PrivateLogName = 'tpt_log',
  VARCHAR LogonMech      = 'LDAP',
  VARCHAR TdpId          = 'TeraDev',
  VARCHAR UserName       = 'user',
  VARCHAR UserPassword   = 'pwd',
  VARCHAR ErrorList      = '3807'
  );
  
  DEFINE OPERATOR op_EMP_NAME
  TYPE DATACONNECTOR PRODUCER
  SCHEMA SCHEMA_EMP_NAME
  ATTRIBUTES
  (
  VARCHAR  DirectoryPath= '/home/hadoop/retail/',
  VARCHAR  FileName = 'emp_age.csv',
  VARCHAR  Format   = 'Delimited',
  VARCHAR  OpenMode = 'Read',
  VARCHAR  TextDelimiter =','
  );
  
  
  DEFINE OPERATOR ol_EMP_NAME
  TYPE LOAD
  SCHEMA *
  ATTRIBUTES
  (
  VARCHAR LogonMech           = 'LDAP',
  VARCHAR TdpId          = 'TeraDev',
  VARCHAR UserName       = 'user',
  VARCHAR UserPassword   = 'pwd',
  VARCHAR  LogTable     =  'EMP_NAME_LG',
  VARCHAR  ErrorTable1  =  'EMP_NAME_ET',
  VARCHAR  ErrorTable2  =  'EMP_NAME_UV',
  VARCHAR  TargetTable  =  'EMP_NAME'
  );
  
  STEP stSetup_Tables
  (
  APPLY
  ('DROP TABLE EMP_NAME_LG;'),
  ('DROP TABLE EMP_NAME_ET;'),
  ('DROP TABLE EMP_NAME_UV;'),
  ('DROP TABLE EMP_NAME;'),
  ('CREATE TABLE EMP_NAME(NAME VARCHAR(50), AGE VARCHAR(2));')
  TO OPERATOR (od_EMP_NAME);
  );
  
  STEP stLOAD_FILE_NAME
  (
  APPLY
  ('INSERT INTO EMP_NAME
  (Name,Age)
  VALUES
  (:Name,:Age);
  ')
  TO OPERATOR (ol_EMP_NAME)
  SELECT * FROM OPERATOR(op_EMP_NAME);
  );
  );
  </code></pre>
  
  <p><strong>Call TPT:</strong></p>
  
  <pre><code>tbuild -f test_tpt.sql
  </code></pre>
  
  <p><strong>Above TPT script is failing with following error:</strong></p>
  
  <pre><code>Teradata Parallel Transporter Version 15.10.01.02 64-Bit
  TPT_INFRA: Syntax error at or near line 6 of Job Script File 'test_tpt.sql':
  TPT_INFRA: At "NAME" missing RPAREN_ in Rule: Explicit Schema Element List
  TPT_INFRA: Syntax error at or near line 8 of Job Script File 'test_tpt.sql':
  TPT_INFRA: TPT03020: Rule: DEFINE SCHEMA
  </code></pre>
  
  <p>Compilation failed due to errors. Execution Plan was not generated.
  Job script compilation failed                                                                .</p>
  
  <p>Am i missing any detail in here? </p>