DSXchange

Thanks Ray..

Hi,
Can a column in a composite primary key be a null? we have a primary key with combination of 2 key columns.In those 2 key columns , can anyone be null?
Database is DB29.Does it accept? Any ideas.

Thanks

Thanks Craig..

Thank you Brian..

Hi,
Can anyone post what commands can be issued by datastage administrator.Like CREATE.FILE , CLEAR.FILE, LIST.READU..
Any other commands ?

Thanks

Thanks for the replies...We are working on the advices you have given.
All really helping a lot.

Thanks

I am sorry to mention this in my previous post..
its taking long time to get message 4

thanks

I am posting the messages from log...It is taking longer time to get 5th message after 4th message.Where as when we run the same job separatly its taking less time to finish. 1>JOB_SEQUENCE_3..JobControl (DSWaitForFile): File'Source_files\cobol_file.txt' is already present 2>SEQUENCE_3 -> (COMPANY):...

The wait for file activity and execute command activities are running fine.Only the jobs are taking time to start.I checked the logs, a job(not other activities) is taking longer time to start from the job sequence than it takes when executed individually.

Thanks

We are using execute command activity at the end of sequence just to create a file indicationg sequence is success and using wait for file activity at the beginning of sequence..


Thanks

Hi Brian,
All jobs are running in the sequence.

Thanks

Thanks sree

Hi, We have 12 jobs in a job sequence.When we run that job sequence, the job activities in the sequence are taking long time to start and to get finished as well. But the same jobs which were called in job sequence are executing much faster when they are executed separatly(i mean out side sequence)....

Hi, We have 12 jobs in a job sequence.When we run that job sequence, the job activities in the sequence are taking long time to start and to get finished as well. But the same jobs which were called in job sequence are executing much faster when they are executed separatly(i mean out side sequence)....

Or We can do this, by specifying custom condition as
Activity variable.$jobstatus <= 2