Search found 161 matches

by mctny
Mon Aug 15, 2011 1:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is $ISUSER available in server routines?
Replies: 3
Views: 2520

I am reopening this because I came across a small issue during a special case. When someone runs the job $ISUSER thing work but if the job is scheduled then $ISUSER is not available. I actually looked at the second log entries of the same job in director, one is when the job is run by any user and t...
by mctny
Thu Aug 04, 2011 11:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is $ISUSER available in server routines?
Replies: 3
Views: 2520

Thanks a lot Ray. That works.

----------
thank you,
Chad
by mctny
Wed Aug 03, 2011 12:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is $ISUSER available in server routines?
Replies: 3
Views: 2520

is $ISUSER available in server routines?

Hi,

I was wondering if I can use the $ISUSER environment variable ( either directly or via a function) in a server routine to get the user who execute the job? I am calling the routine from a user variables activity stage within a job sequencer.

Thanks,
Chad
by mctny
Sun Jun 19, 2011 10:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: vertical pivot for variable number of rows and columns
Replies: 7
Views: 4260

Thanks to you both, Yes I can do that and it will help me extract all the elements of the matrix with the order a,b, c, ..n, a1, b1, c1,... n1,a2,b2,c2,...cn... but I am not sure it will help me to achieve my desired output, it will only help me to concatenate ai, bi, ci ... ni ( where i is 1,2 .. n...
by mctny
Sun Jun 19, 2011 12:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: vertical pivot for variable number of rows and columns
Replies: 7
Views: 4260

Thanks Ray, it still does not help me because in that case, I have to create dynamic number of stage variables (equal to the number of delimiters which will be different for each run). if possible then the logic will be simple, when rows comes, I will keep concatenating the incoming value of the sta...
by mctny
Sun Jun 19, 2011 12:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: vertical pivot for variable number of rows and columns
Replies: 7
Views: 4260

Thanks Craig for the reply, That's the thing, as of now I don't have a safe number that I can assume as the maximum number of columns. ( I can go back to the business Analysts and ask if they can give me such a number) is it possible to do in a transformer with a loop where the loop limit is the num...
by mctny
Sat Jun 18, 2011 8:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: vertical pivot for variable number of rows and columns
Replies: 7
Views: 4260

vertical pivot for variable number of rows and columns

Hi I have an interesting requirement and I would like to find a systematic solution for it. I would appreciate if you could give me some hints to implement the logic. ( I searched the forum but could not find a good answer) input file is a sequential file with the format below zzzzz a b c ...... n d...
by mctny
Tue Jun 07, 2011 5:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Retain loop variable value in a transformer?
Replies: 2
Views: 3277

Retain loop variable value in a transformer?

Hi, I have a question, I need to store the last value of a loop variable so that I can use it in the output link ( or in the new loop) in a column for the other rows. The output link has a constraint which filter the row for which the loop variable is calculated. Loop value is reset to its initial v...
by mctny
Wed May 04, 2011 2:24 pm
Forum: General
Topic: before-job subroutine execSH
Replies: 3
Views: 2342

Thanks to you both. it works
by mctny
Wed May 04, 2011 12:19 pm
Forum: General
Topic: before-job subroutine execSH
Replies: 3
Views: 2342

before-job subroutine execSH

Can we run two commands consecutively in one line ( in before-job subroutine for the execSH)?
by mctny
Wed Apr 27, 2011 10:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transformer without Primary Input
Replies: 7
Views: 6446

I just wanted to pass some job parameters to some columns of a transformer so that I can pass those column values to a shared container. I guess I will have to use a row generator and then a transformer and then the shared container. looks like it is not possible with only a transformer and shared c...
by mctny
Wed Apr 27, 2011 8:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transformer without Primary Input
Replies: 7
Views: 6446

does this work for parallel jobs as well? I guess not, can someone confirm?
by mctny
Wed Mar 16, 2011 1:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XSLT Warning in XML transformer stage
Replies: 17
Views: 12646

Hi Ernie,

Not sure if I understood how to use the brute force approach. our html is not very big but the XSLTs are big, each has approximately 800 lines.
by mctny
Tue Mar 15, 2011 7:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XSLT Warning in XML transformer stage
Replies: 17
Views: 12646

Hi Vincent,

Yes we are using the newest XML pack. but even the newest does not support XSLT version 2, IBM told us it supports version 1 only. They asked us to open an enhancement PMR so that they can start working on supporting version 2 soon.
by mctny
Fri Mar 11, 2011 2:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XSLT Warning in XML transformer stage
Replies: 17
Views: 12646

Hi Ernie, the tool we use to send the email is the sendmail utility in linux. at the receiving end, the users who will read these emails are using MS outlook. I am not sure( don't really think) if Outlook can show the XML content even if we send the stylesheet with it. Do you think it is still possi...