Search found 68 matches

by urshit_1983
Thu Feb 15, 2007 10:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running job in MI
Replies: 9
Views: 2458

Thankyou so much guys. So let me summarize the points and then I will mark this issue resolved- Design 2 jobs 1st job -define parameters(invocation ids) -enable MI -write all intances to single hashed file with key @INROWNUM=invocation ids -Run this same job 5 times continuously without waiting for ...
by urshit_1983
Thu Feb 15, 2007 9:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running job in MI
Replies: 9
Views: 2458

Hmm. Thanks ray.

But as I have never done this before what should my primary steps ? Suppose I want to run the job in 5 instances then how shall I proceed , do I need to write some script or manually I have to run the job 5 times passing 5 different invocation ids each?
by urshit_1983
Wed Feb 14, 2007 6:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running job in MI
Replies: 9
Views: 2458

Ok so now how shall I do that ? Because I dont know how many instances it will need. I will have to do trial and error to minimize the run time till its affordable enough. My point was can I use some thing like using ExeSh as after job subroutine which will create each different file for each instan...
by urshit_1983
Wed Feb 14, 2007 4:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running job in MI
Replies: 9
Views: 2458

Sorry I didnt mention, I am only reading from hashed files and writing to seq file. Moreover there is only one Transformer in the job.( Thats why I used the same name ) As as you said only one process writes in seq file, I can write after job subroutine with different file names appended by some ID....
by urshit_1983
Wed Feb 14, 2007 3:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running job in MI
Replies: 9
Views: 2458

Running job in MI

I wanted to know how to use Multiple Instance in a job or when to check the box ? How the job will run and what is the importance of invocation ids ? I have bit idea but as I am a rookie I need more help to go. Please through some light on this. I am asking this becoz I have developed the job which ...
by urshit_1983
Fri Jan 05, 2007 9:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: calling shell script form datastage
Replies: 6
Views: 7168

First of all check your shell script if its executing properly, I mean you getting desired output by using >sh filename.sh. If your script is correct then change the mode of file by: >chmod 777 filename.sh After this open DS and select the Before or After job subroutine In the input values write : c...
by urshit_1983
Wed Aug 23, 2006 3:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: String aggregation
Replies: 11
Views: 4441

DSGuru I tried Row merger but getting confused. I am getting strange results. I have also never used this stage before so a bit ignorant on this. Your help would be appreciated.
by urshit_1983
Wed Aug 23, 2006 3:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: String aggregation
Replies: 11
Views: 4441

the variable method by rohit is not working. I have not tried the other two methods.

Will get back to you guys again...
by urshit_1983
Wed Aug 23, 2006 10:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: String aggregation
Replies: 11
Views: 4441

String aggregation

I am finding it hard to find out whether the following thing can be done in DS ?? Input is like :- Custname--------------Custid Mel --------------- 001 Dino----------------------002 Mel------------------------007 Dino-----------------------009 Jack------------------------100 Jack--------------------...
by urshit_1983
Wed Aug 23, 2006 8:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stop Job
Replies: 6
Views: 2531

kcbland can you throw some more light on DS.TOOLS ? Like after login what has to be done exactly and what commands to give to kill a particular job?
by urshit_1983
Tue Aug 22, 2006 4:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data Truncation Warning
Replies: 7
Views: 3778

Explain in detail so we can get idea. wot u want exactly ?

Is the string a part of any of ur field and you want to retain the whole string ??
by urshit_1983
Tue Aug 22, 2006 3:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: replace
Replies: 10
Views: 3348

Sorry the variable names ....

in1=Arg1
l=len(in1)
new=right(in1,l-1)
in2="XYZ"
Ans=cats(in2,new)

Now its ok.
by urshit_1983
Tue Aug 22, 2006 2:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: replace
Replies: 10
Views: 3348

Try to make a small sub-routine like:


in1=Arg1
l=len(in)
new=right(in,l-1)
in2="XYZ"
Ans=cats(in2,new)
by urshit_1983
Thu Aug 17, 2006 1:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compilation errors
Replies: 5
Views: 726

Sorry, due to formatting the Table1 and Table2 have moved to Source instead to Transformer.
by urshit_1983
Thu Aug 17, 2006 1:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compilation errors
Replies: 5
Views: 726

You said without doing lookup with the source ??? And why you need to build a hashed file if the table itself can be used for the lookup.. More over I guess you are doing the same thing by building the hashed file and then using it as look up .. So Correct me if i m wrong : your job is like - Source...