DSXchange

Thanks very much Guys....

oooo........So you guys mean to say that all the DataStage commands such as dsjob -run etc. will work in batch files also. Only thing which will change is the syntax from Unix to windows Batch programming??

From Where will I get to learn this batch programming.............Currently I dont have any knowledge in Batch programming

Hi Ray,

Actually I have a shell script which executes these jobs fine in Unix wherein I increament the Month by 1 and attach that month with all the Parameters by which all my parameters are updated with the latest.
But don't know how to do this in windows environment.

Hi All,

I have a DataStage job which needs to be executed 12 times with different set of parameters passed for each run.
I s there any way to loop this job for 12 times? If Yes, How can I do this?
I couldn't find any Start End Loop Activity in DS 6.0.

Thanks in Advance.

Thanks craig ....

Hi All, I have a job which executes around 15 Oracle procedures using 15 seperate ODBC stages. But they are interdependent and must be executed in a specific order. I have used a transformer before calling all these Procedures and set the Output Link Execution order as per the requirements. But does...

Yes Craig, Thats surely an alternative But I guess I will have to discuss with my seniors since there is a time constraint involved............
Thanks for your replies..................

Yes, I have checked and the parameter type is same as in the Procedure But for One of the OUT parameters the type in Procedure is of Reference Cursor, which we cannot declare in DataStage so I have declared it as a varchar. I think all the Problem is because of this reference Cursor type which is no...

Hi All, I am using DataStage 6.0 version. I have to call a stored Procedure through DataStage which has a In as well as Out Parameter. The out parameter is of Ref Cursor type. I am using ODBC stage to call this Procedure since we do not have SP Stage in 6.0 version. But I am not able to handle the O...

DataStage Job 1017 Phantom 4949
Program "DSD.StageRun": Line 544, Nonnumeric data when numeric required. Zero used.

The above warning is only shown when executed through sequencer and the job runs fine when executed individually.

Hi All, I have a DataStage Job which when executed individually through DS Director gets executed fine without any warnings. But when I execute this job through a sequencer which also calls other jobs along with this job. I get a Phantom Warning message for this job. I am not able to understand why ...

Thanks Ray,

Hi All, My sequencer sends around 25 emails to an email Id for diiferent sub-jobs executed as status email through E-mail Notification activity. I want to know if these mails sent are also stored on the DataStage Server? If yes at what path are these Emails stored. Will these create a space issue or...

thanks ray, Following is the output given by this command. I have posted the log shown for line 544 where i receive a phantom error. It would be helpful if any one can decode this 00541 013FE : 0F8 move "Status.Update" => _Too66 00541 01404 : 01E call "$PERF.NAME" _T0065 _T0066 0...