DSXchange

There is a SHORT DATETIME field u select from the datatypes selection. i have used this to load dates into SQL server tables. it works! :D

Bindu

Christina, DataStage 7.1 does not support parameterized Execute Command stage. We ran into this problem too and we were forced to clone our sequencer jobs and pass hardcoded paramaters. But, the good news is, in DataStage verion 7.5 and above it works fine!! We have successfully implemented it in ou...

Ray

I did check all available APT variables at the project level and did not see any generic APT_COMMIT*.
I will dig into the Parallel dev guide and see if i can find anything.

Thanks
BM

I am trying to do inserts into SQL server database using ODBC enterprise stage fron a PX job. I have to insert approx. 30 million rows of data into the SQL sever database. My input is a sequential file on AIX. The database is SQL server 2000. How do i set the number of rows to commit/transaction siz...