Search found 2 matches

by sagar.skhtt@gmail.com
Fri Apr 27, 2012 5:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creating Teradata table in the Datastage job
Replies: 10
Views: 8028

Re: Creating Teradata table in the Datastage job

Hi Anand,
in Mload Script tab -> Before use this syntax
DROP TABLE database.TableName;
CREATE TABLE database.TableName (
ID DECIMAL(12,0) NOT NULL,
NAME CHAR(5) NOT NULL,
)
PRIMARY INDEX (Keycolumns);


Regards,
Sagar.
by sagar.skhtt@gmail.com
Fri Apr 27, 2012 4:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creating Teradata table in the Datastage job
Replies: 10
Views: 8028

Re: Creating Teradata table in the Datastage job

Hi Anand,
Please use TeradataPX stage in General tab Create table aection put Generate DDL and Drop table action put Generate DDL . this will work each run Drop the table and Create it.

Regards,
Sagar.