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.rapaka89 wrote:Hey I have tried it already.. but not getting the desired output
Search found 42189 matches
- 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
- 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
- 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
- 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
- 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
- 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
- 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...
- 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
- 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
- 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
- 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...
- 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...
- 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
- 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...
- 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