DSXchange

I am running different sequencers which are calling the same job with a unique identification number.Is there any limitation on number of instances for a single job?

Order of execution is update and then insert

Either you can call the procedure in a select statement or you can write a shell script which calls the procedure.And you can call the shell script in external filter stage or you can create a wrapper stage

If the column is nullable and you are receiving nulls then you have to mention null feild value when you are using sequential file. I think using a dataset is a better option where you dont have to mention any null feild value. But if your requirement is to use a sequential file stage then you have ...

we get files from different sources.so as soon as we receive the file the job will be triggered.so if we get 10 files at a time then all the 10 sequencers will be triggered at same time. And in the common job multiple instance flag is set,so I think it should not be a problem when this job is called...

when you try to insert a null value into a column with nullable "YES" without null handling in seq stage records will be rejected.

I have 10 sequencers calling same job.when i tried to run all the sequencers parallely I am getting the following error

Controller problem: Error calling DSAttachJob(commonjob.14)
(DSOpenJob) Cannot get shared access to executable file for job commonjob

Thanks in advance