How to run these commands in Datastage for Teradata.

xinhuang66 · Post by **xinhuang66** » Sun Jun 17, 2007 4:41 pm

For some purpose, I need to run below three commands in Datastage aftere a job for Teradata data loading .

collect stats on Schema.Table1 column column1;
collect stats on Schema.Table2 column column2;
collect stats on Schema.Table3 column column3;

Apart from put them into a command file, and run it from command line, is there any other way for us to run them.

Thanks.

ray.wurlod · Post by **ray.wurlod** » Sun Jun 17, 2007 8:32 pm

Why do you need to run them "in DataStage"?

DataStage is an ETL tool, not a reporting tool.

Run them in a script, under control of a job sequence if needed. You can retrieve the output from the script within the job sequence and do whatever you like with it afterwards.

vmcburney · Post by **vmcburney** » Sun Jun 17, 2007 10:45 pm

For some actions the Teradata Enterprise stage lets you put in a Before-SQL and an After-SQL statement that runs at the start of end of the DataStage job (not for every row). You might be able to use the After-SQL tab to update stats.

xinhuang66 · Post by **xinhuang66** » Mon Jun 18, 2007 5:13 pm

In Enterprise stage, it is called open command , close command, while in other teradata stage, it is before and after sql.

I tried that, and it looks like that DS couldn't recognize these commands.

thanks

BradJoss · Post by **BradJoss** » Wed Oct 07, 2009 12:05 pm

xinhuang66 wrote:In Enterprise stage, it is called open command , close command, while in other teradata stage, it is before and after sql.

I tried that, and it looks like that DS couldn't recognize these commands.

thanks

I know this is an old thread but I had to do this (company direction is not to mix DataStage and Scripts) as well and anyone that comes across this might like to know the answer. What I had to do was to issue one collect statistics statement then follow it with a COMMIT; then repeat the pattern.