Search found 42189 matches
- Sun Apr 28, 2013 8:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparing decimal value
- Replies: 3
- Views: 1563
- Sat Apr 27, 2013 4:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loop same record in transformer
- Replies: 4
- Views: 10919
- Fri Apr 26, 2013 3:54 pm
- Forum: General
- Topic: Telnet connection refused
- Replies: 10
- Views: 2177
- Fri Apr 26, 2013 3:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need logic to implement
- Replies: 12
- Views: 4853
- Fri Apr 26, 2013 2:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need logic to implement
- Replies: 12
- Views: 4853
- Fri Apr 26, 2013 9:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need logic to implement
- Replies: 12
- Views: 4853
It will work just fine. Nothing in the examples you've posted shows you needing to match multiple items. For example:
Would equate to:
Code: Select all
if CODE NOT IN ('A','B','C','D','E','F') then 'Y' else 'N'Code: Select all
If Index('ABCDEF',CODE,1) Then 'N' Else 'Y'- Fri Apr 26, 2013 9:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need logic to implement
- Replies: 12
- Views: 4853
Re: Need logic to implement
A couple of things. if CODE <> 'A' or CODE <> 'B' .......... or CODE <> 'F' Then 'Y' else 'N' Those would need to be ANDs to work, OR would always evaluate to TRUE. Secondly, what you were given was not a 'workaround' but the resolution to your question and works just fine without any additional cav...
- Fri Apr 26, 2013 7:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error in Unstructured Data stage in v9.1
- Replies: 7
- Views: 6542
- Fri Apr 26, 2013 6:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to get 30 days old date from current date
- Replies: 5
- Views: 3293
Look into the DateFromDaysSince() function, or if you are on 8.5+ there's DateOffsetByComponents() as well. Always a good idea to check the documentation first when you have a question like this. While there you'll also find functions like CurrentDate() or CurrentTimestamp() depending on what you ne...
- Fri Apr 26, 2013 6:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error in Unstructured Data stage in v9.1
- Replies: 7
- Views: 6542
So you are everyone at the moment. I really don't know the gory details of how the 'wrapper class' is configured or what exactly to look for but hopefully someone else does. The only thing that pops into my head on a Windows server when something works fine one day and doesn't the next is - are you ...
- Thu Apr 25, 2013 7:44 am
- Forum: General
- Topic: Routines reading list of parameters
- Replies: 8
- Views: 2137
There's no documentation on how to write routines. There are all of the examples to steal code from and then there's practice. I'm unclear exactly what you need help with. You have a file and you've said you know how to read it, after that it's just a matter of calling the appropriate API functions ...
- Thu Apr 25, 2013 7:37 am
- Forum: General
- Topic: Password Encryption Using Encrypt.bat
- Replies: 8
- Views: 4983
- Thu Apr 25, 2013 7:34 am
- Forum: General
- Topic: Sequential File path query
- Replies: 34
- Views: 8024
- Thu Apr 25, 2013 7:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Needed decimal value in 99,999,999 format
- Replies: 7
- Views: 1360
- Thu Apr 25, 2013 7:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Needed decimal value in 99,999,999 format
- Replies: 7
- Views: 1360