Search found 147 matches

by veera24
Mon Jan 12, 2009 12:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Summation in transformer
Replies: 11
Views: 5841

Stage variable using "+". SDK routine "RowProcRunningTotal". Or an Aggregator stage. :wink: ... Craig, I can view this routine in the palette but not in the column derivation.What shall i do?Should i compile the routine before? Your time would be highly appreciated. Thanks in ad...
by veera24
Fri Jan 09, 2009 10:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: @INROWNUM
Replies: 24
Views: 21736

When your original design with buffering on gives you a problem and that problem goes away with buffering off, then yes I'd say it was a "problem of buffering". Of course, you'd have to specifically test that and let us know. Actually we didn't touch the row buffering (i'm sure craig). We...
by veera24
Fri Jan 09, 2009 10:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: @INROWNUM
Replies: 24
Views: 21736

You suppose? Earlier when I asked you said "I didn't set any buffer alloaction". Check and be sure. If it is (and I'd really have to question why) run your tests again with it off as sug ... It's not like that craig. After our conversation only i had checked with my team.Because i forgot ...
by veera24
Fri Jan 09, 2009 10:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: @INROWNUM
Replies: 24
Views: 21736

You suppose? Earlier when I asked you said "I didn't set any buffer alloaction". Check and be sure. If it is (and I'd really have to question why) run your tests again with it off as sug ... It's not like that craig. After our conversation only i had checked with my team.Because i forgot ...
by veera24
Fri Jan 09, 2009 3:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: @INROWNUM
Replies: 24
Views: 21736

Couple of questions: 1) Do you have an active stage connected to another active stage? 2) Do you have row buffering enabled? I seem to recall having weird issues with row buffering many moons ago in one of the 7x releases. I don't remember if I ever saw it with @INROWNUM (might have), but I definit...
by veera24
Fri Jan 09, 2009 3:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: @INROWNUM
Replies: 24
Views: 21736

The actual upper limit is at least a fourteen digit number. It depends on settings such as EXACTNUMERIC and PRECISION. ... Ray, If i change the EXACTNUMERIC value in uvconfig file, will i face any problem?I mean will any normal/usual thing go wrong? Your time would be highly appreciated. Thanks in ...
by veera24
Thu Jan 08, 2009 8:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: @INROWNUM
Replies: 24
Views: 21736

Sorry, but I can't explain the behaviour you saw. I use the ROWNUM variables "all the time" and have never seeing this issue. Have you opened a case with your official support provider? What exact 7.x version do you have and on what UNIX platform? If it's earlier than 7.5.1a then the answ...
by veera24
Thu Jan 08, 2009 8:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: @INROWNUM
Replies: 24
Views: 21736

Sorry, but I can't explain the behaviour you saw. I use the ROWNUM variables "all the time" and have never seeing this issue. Have you opened a case with your official support provider? What exact 7.x version do you have and on what UNIX platform? If it's earlier than 7.5.1a then the answ...
by veera24
Thu Jan 08, 2009 10:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: @INROWNUM
Replies: 24
Views: 21736

Sorry, but it's my choice when I post "Premium" comments and when I don't. What "logic change" did you make that made it work - from what to what, precisely? ... Hi craig, Ofcourse craig its completely your wish to post your comments as premium or not. But if you would post that...
by veera24
Thu Jan 08, 2009 10:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Summation in transformer
Replies: 11
Views: 5841

Summation in transformer

Hi all,
Is there any function to sum up the value in the transformer stage itself?or should i go with Aggregator stage alone for summation?

Your time would be highly appreciated.

Thanks in advance,
Veera.....
by veera24
Thu Jan 08, 2009 10:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: @INROWNUM
Replies: 24
Views: 21736

I've explained in the thread about my design. No, you explained nothing about your job design, just stated you had a problem without providing any details. For example, do you have any kind of buffering enabled in your job? Did you post a list of the stages used or details of the transformations be...
by veera24
Thu Jan 08, 2009 10:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: @INROWNUM
Replies: 24
Views: 21736

I've explained in the thread about my design. No, you explained nothing about your job design, just stated you had a problem without providing any details. For example, do you have any kind of buffering enabled in your job? Did you post a list of the stages used or details of the transformations be...
by veera24
Thu Jan 08, 2009 7:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: @INROWNUM
Replies: 24
Views: 21736

In short, you edit your uvconfig file and then 'regen'. Why do you think you need to change it? ... I dont get you what you mean 'regen'. Could you explain? And one more thing i dont want to change it i just wanna how to do that. thats it. Anyways thanks for your info and time. And also, Could you ...
by veera24
Tue Jan 06, 2009 3:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: @INROWNUM
Replies: 24
Views: 21736

Never had a problem with either "ROWNUM" system variable. Please explain your job design and the nature of the "duplicate" value that it generated. Also, search for EXACTNUMERIC for discussi ... Could you tell me about how to change the default value of EXACTNUMERIC? Thanks, Vee...
by veera24
Mon Jan 05, 2009 4:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: @INROWNUM
Replies: 24
Views: 21736

@INROWNUM

Hi all, When i had used to generate the sequence number using inrownum function, DS itself have generated a duplicate value. Is it because of any buffer problem or what? Similarly i want to know whether there is any limit in the sequential number value assigned to the stage variable too? I mean, if ...