Search found 42189 matches

by chulett
Sat Feb 05, 2011 7:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Variable not being assigned a value
Replies: 12
Views: 5282

rapaka89 wrote:Hey I have tried it already.. but not getting the desired output
I just corrected your syntax. As noted, without knowing the source data you are cutting that from, there's not much help anyone can give.
by chulett
Fri Feb 04, 2011 7:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Questions regarding Hash files and hash file stage
Replies: 54
Views: 42070

mavrick21 wrote:In that job the hashed file was used as reference and I couldn't find the job which populated it. Didn't want to waste my time creating a new job to clear it ;)
Well, I've seen plenty of places that have jobs that do just that. :wink:
by chulett
Fri Feb 04, 2011 7:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Questions regarding Hash files and hash file stage
Replies: 54
Views: 42070

Manager. The icon looks like a chemistry beaker from what I recall.
by chulett
Fri Feb 04, 2011 7:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do I fix performance bottleneck at Sort stage?
Replies: 12
Views: 5410

If you've been here for any length of time, you'd know Ray considers rows/second to be a particularly useless metric. :wink:
by chulett
Fri Feb 04, 2011 6:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer into Parallel Jobs
Replies: 7
Views: 4689

Because, as Ray noted, that is the one of the only stages that 'compile', the others generate OSH script.
by chulett
Fri Feb 04, 2011 4:04 pm
Forum: General
Topic: How to store Job start time,end time,job name in Oracle
Replies: 51
Views: 37920

You define 'DirName' and then don't use it anywhere except in the error messages. Append FileName to the end of it and then use that in your open statement.
by chulett
Fri Feb 04, 2011 4:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Questions regarding Hash files and hash file stage
Replies: 54
Views: 42070

Only if there is a VOC entry for the hashed file, from what I recall. That is, only if it is in an 'account' rather than a 'directory', that or you've manually created one for it using the SET.FILE command. There's also a 'Clear' option if you need to do that inside a job in the Hashed File stage bu...
by chulett
Fri Feb 04, 2011 3:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer into Parallel Jobs
Replies: 7
Views: 4689

Do you have the identical compiler configured in an identical manner in these other environments?
by chulett
Fri Feb 04, 2011 10:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Get count of rejected records without outputting them?
Replies: 4
Views: 4293

Ragunathan Gunasekaran wrote:I believe if i connect copy stage to a reject link and leave it with out a output link (to throw away the data from further processing) then i will get a compilation error( As a pre requisite the copy operator needs an output).
Try it and let us know.
by chulett
Fri Feb 04, 2011 8:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Handling Nulls
Replies: 8
Views: 4694

:!: You two - ramsubbiah & kalpanam - need to stop quoting everything when you reply. There is a perfectly lovely Reply to topic button down there, please use that unless there is a burning need to quote something.
by chulett
Fri Feb 04, 2011 8:03 am
Forum: General
Topic: How to store Job start time,end time,job name in Oracle
Replies: 51
Views: 37920

Echo the string and redirect that to your file of choice. Do that using the DSExecute() function. That or search here or in your docs for the Sequential File handling functions to OPENSEQ, WRITESEQ and CLOSESEQ a sequential file but the first way would be less... difficult. Here is Ray's all encompa...
by chulett
Fri Feb 04, 2011 7:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help needed in converting code which is in DS Server routine
Replies: 17
Views: 8678

Why two posts on the same subject? How is this different from your other post here? http://www.dsxchange.com/viewtopic.php?t=138503 Never mind the fact that we have no idea what you mean by 'convert' in this context or specifically what part of this large mess you are having an issue with. Other tha...
by chulett
Fri Feb 04, 2011 7:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Variable not being assigned a value
Replies: 12
Views: 5282

UNIXcmd = "echo ":KeyPos
by chulett
Fri Feb 04, 2011 7:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine Logic(If then else)
Replies: 2
Views: 2412

Your else doesn't make much sense as it stands right now and you are setting MGlAccount there to MGlAccount1 which does not exist. However, the only guess that anyone can hazard from what you posted as to why of 'the first part' of the IF is always firing is that Arg5 is always equal to 4. :? Add so...
by chulett
Thu Feb 03, 2011 10:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage jobs not compiling
Replies: 6
Views: 4116

The compiler comes into play for jobs with a Transformer stage in them. Do you only have this issue with those jobs? Or all jobs?