DSXchange

Hi Anil, you can delete the other duplicate post that been created.

Use Link partitioner to trigger each parallel link based on certain condition. You can have 10 parallel links with 10 OCI or ODBC stages to call procedures parallely.
Data source will be your schema.

Check you online manuals available in you client. You can find this documented under Basic Programing in Server Job Developers guide.

Though there will be performance lack with huge logging, it can be compromised with usefulness of the log obtained. It again depend on the type of log you produce.

There is a command available called 'dssearch' from command prompt.

Yes, the logs will be logged into single master job's hashed file log. Obviously if number of parallel instance jobs increases, the resource consumed will also be increased. But check if the log is one of the bottle neck. Set auto purging. Purging log before triggering each job will also not be poss...

Thanks again.
Just noticed that, my points have crossed the Number of post of Ray. Which I though would never happen.
I also knew that it wont last for long.

You can call a batch file which involves
set ORACLE_SID=orcl
sqlplus userid/pwd@schema
sqlplus "Call StroedProcedure"

Add 'PartitionNum' to the RowNum to get the unique value across partitions.

Thanks to all. :D
Kim, I remember you said the same when I was in 2000. Nothing changed.

Or if you are using BASIC code to call the job, you can check the status and based ont hat you can reset by DSJ.RUNRESET in DsRunJob().

Use Convert('abcdefghijklmnopqrstuvz','',Input.Col), you can add more character like any special character or you can even use Upper functon for case sensitive.

You still can convert the integer into date in you job.

View doesnt make any differenct with table with respect to Datastage. Query were made similar to table. If you were refering to creation of the Table or view, you dont have any direct option to create a view but using user defined query, you can. And passing the parameter as well.

Is the fomat of date mentioned in the job/Project varied?