Search found 42189 matches

by chulett
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

Your input value, is that what View Data shows? And what happened when you tried to compare those values?
by chulett
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

Excellent - glad you found that as there was no way for us to know from what you posted. :wink:
by chulett
Fri Apr 26, 2013 3:54 pm
Forum: General
Topic: Telnet connection refused
Replies: 10
Views: 2177

telnet datatage:22
by chulett
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

OK... that's still not a substring match and you're not quite right on your changes. The extra steps are necessary if you want to check for codes like "AT" or "MATCH" against a larger string, say like "MATCHES". Both of those would give false positive return codes as th...
by chulett
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

Which is why I said that this "works just fine without any additional caveats as long as you're not doing substring matches". What you posted would be the shenanigans I was referring to. :wink:
by chulett
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:

Code: Select all

if CODE NOT IN ('A','B','C','D','E','F') then 'Y' else 'N'
Would equate to:

Code: Select all

If Index('ABCDEF',CODE,1) Then 'N' Else 'Y'
by chulett
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...
by chulett
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...
by chulett
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 ...
by chulett
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 ...
by chulett
Thu Apr 25, 2013 7:37 am
Forum: General
Topic: Password Encryption Using Encrypt.bat
Replies: 8
Views: 4983

I don't know if you can use an encrypted password in that file. That would be either a "try and see" thing or an "ask support" thing. We didn't worry about it being "visible" in the file, we made sure access to the file was locked down enough to satisfy our security fol...
by chulett
Thu Apr 25, 2013 7:34 am
Forum: General
Topic: Sequential File path query
Replies: 34
Views: 8024

We know what you've told us. Eric has already told you he tested it and it worked fine. You need to answer the questions asked. Don't just say "I put the command lines where you mentioned" as Eric told you to "adapt them to your needs". :!: Show us your exact commands (asking thi...
by chulett
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

Which means you simply include it in a BASIC Transformer as Ray mentioned. And I mentioned it to reinforce Ray's mention. :wink:
by chulett
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

I've always used FMT() for requirements like this.