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.
Search found 2 matches
- 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
- 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.
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.