DSXchange

I am facing the same problem in the V8.1 parallel job. Did you find any solution for the same

Thank you guys...

Hi,

I am using the shell script to trigger the datastage sequence with the below syntax

dsjob -run -jobstatus ProjectName JobName

The sequence is getting aborted after 50 warnings.
I want the sequence to run without abort after 50 warnings.
How to achieve this.

Thanks in advance.
Major

we cannot go for surrogate key stage as we need to maitain the referntial integrity of the keys. moreover we will use these keys in other jobs so as we cannot lose the values during runtime Sorry but I'm afraid I don't understand either sentence in this context. Does the first one refer to the ques...

we cannot go for surrogate key stage as we need to maitain the referntial integrity of the keys. moreover we will use these keys in other jobs so as we cannot lose the values during runtime

Hi, I have a datastage parallel Job where I need to generate keys based on the valus stored in the SDK_Sequences file using the KeyMgtGetNextValue server routine. By accessing this value I will generate keys based on the value in the file and insert the value in the table. Now i m tring to convert m...

Hi Guys,

Any help or suggestions.

Thanks
Major

Hi all, I have a requirement where users will send data as an attachment in csv format. Everytime I save the attachment in predefined folder and trigger the datastage job. Now a days I am getting more than 50+ requests like that. I would like to automate the process using datastage. Is there any way...

Wonderful chulett , I never knew this approach.

Hi,

Are you using same Datastage job to read and write the db2 table ?
Is there any other process whcih has locked your target table for processing?

Check for table locks with DBA and get them cleared after conforming that "killing" wont affect others job/process.

Thanks

Hi, You mean to say that your sources is Oracle and target is sqlserver. In that case just take substring of 19 for the Oracle timestamp for ex LnkFromOracle.Timestamp[1,19] assuming LnkFromOracle as your link name from oracle and Timestamp as your column name from oracle which has to be loaded to s...

Hi,

Did you check the Generate formatted output box in the options tab of XML output stage.
Please uncheck it and try.

Thanks,
Major

Yes

Hi all,

Can we call Mainframe Stored Procedure from DataStage , if yes caould you please explain that.

Thanks

I guess you cannot view the contents of those files.
Even if you view you can find a large C programs handling various functionalities..

My suggestion is to forget about the content of those files as it has nothing to do with your job design, let DataStage take care of it