TPT 14.00 DEFINE SCHEMA / DELIMITED option

Tools
Enthusiast

TPT 14.00 DEFINE SCHEMA / DELIMITED option

Can someone please explain the usage and the proper syntax for the the DEFINE SCHEMA 'name' DELIMTED 'tablename';  introduced in TPT 14.00 reference manual diagram on page 62 / Nov 2011 ?

I assume it is generating the proper schema based on an existing schema , but i could not get the syntax to work. For example

DEFINE SCHEMA sandbox

DESCRIPTION 'schema descr'

DELIMITED 'sandbox.tablename';

gets me

Teradata Parallel Transporter Version 14.00.00.07

TPT_INFRA: Syntax error at or near line 6 of Job Script File 'sandbox.tablename_timport.tpt':

TPT_INFRA: At "DELIMITED" missing LPAREN_ in Rule: Explicit Schema Element List

TPT_INFRA: Syntax error at or near line 6 of Job Script File 'sandbox.tablename_timport.tpt':

TPT_INFRA: TPT03020: Rule: DEFINE SCHEMA

Compilation failed due to errors. Execution Plan was not generated.

Job script compilation failed.

What is the proper syntax and can it be used to import a flat file (CSV) into teradata ?

Thank you.

Tags (2)
1 REPLY
Teradata Employee

Re: TPT 14.00 DEFINE SCHEMA / DELIMITED option

Please refer to the documentation for the proper syntax.

In this case it would be:

DEFINE SCHEMA sandbox DELIMITED 'sandbox.tablename';

-- SteveF