Search found 161 matches
- 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...
- 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
- 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
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
- 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...
- 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...
- 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...
- 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...
- 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...
- Wed May 04, 2011 2:24 pm
- Forum: General
- Topic: before-job subroutine execSH
- Replies: 3
- Views: 2342
- 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)?
- 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...
- Wed Apr 27, 2011 8:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transformer without Primary Input
- Replies: 7
- Views: 6446
- 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
- 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
- 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...