Search found 42189 matches

by chulett
Thu Jun 14, 2012 7:41 am
Forum: General
Topic: KeyMgtGetNextValueConcurrent() generating duplicate records.
Replies: 16
Views: 7374

True, that's a pretty common thing people seem to do - create an "Update Next Value" version of the routine, then all you have to do is "test" it to make the update.
by chulett
Thu Jun 14, 2012 7:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to get cumulative sum
Replies: 14
Views: 5940

So... resolved?
by chulett
Thu Jun 14, 2012 7:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue reading japnese characters
Replies: 7
Views: 2128

Any source? Can you not simply ask whomever delivered it? Failing that, whomever populated it? Typically this is controlled by the computer's Region and Language settings when it was created / populated.
by chulett
Thu Jun 14, 2012 7:15 am
Forum: General
Topic: Jobs not showing in Director
Replies: 8
Views: 2527

D'oh! Always check for the simplest answer first. :D
by chulett
Thu Jun 14, 2012 7:13 am
Forum: General
Topic: KeyMgtGetNextValueConcurrent() generating duplicate records.
Replies: 16
Views: 7374

As has been mentioned here many times, you never answer that question "Y". Always launch dssh from either DSEngine or a Project directory. For the former, LOGTO a Project, for the latter you are already logged into the project.
by chulett
Thu Jun 14, 2012 7:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue reading japnese characters
Replies: 7
Views: 2128

As Ray noted, the same one that was used to create it. Ask.
by chulett
Wed Jun 13, 2012 9:10 pm
Forum: General
Topic: Datastage Connectivity to multiple servers
Replies: 14
Views: 8171

If you have multiple IP addresses in your hosts file associated to the same name, more than likely the first listed will be chosen to resolve the hostname. I'm certain you can take out the "more than likely" part of that statement. This is just a text file with absolutely no intelligence ...
by chulett
Wed Jun 13, 2012 8:03 pm
Forum: General
Topic: Get and set variables
Replies: 2
Views: 1125

You'll need to be a little more explicit because I'm not really sure what you mean by 'send that output to a variable'. I could guess what you mean but I'd really rather not.

A variable where? That you would use in what fashion?
by chulett
Wed Jun 13, 2012 4:50 pm
Forum:
Topic: What font is best for Business Glossary .csv imports?
Replies: 7
Views: 2762

Usually this kind of thing comes from Microsoft's "smart quotes", they aren't apostrophes but rather the magical inward-facing versions that they defined and which don't have an equivalent in your characterset.
by chulett
Wed Jun 13, 2012 2:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Append Leading Zeros
Replies: 4
Views: 2024

Both of which are in the post I linked to. :wink:
by chulett
Wed Jun 13, 2012 1:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Append Leading Zeros
Replies: 4
Views: 2024

You need to emulate an lpad and ensure your target is a string.
by chulett
Wed Jun 13, 2012 1:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: concatenation of four column into a single column
Replies: 7
Views: 2121

Wrap each field in a NullToEmpty() call during the concatenation, no intermediate stage variables required..
by chulett
Wed Jun 13, 2012 1:13 pm
Forum: General
Topic: KeyMgtGetNextValueConcurrent() generating duplicate records.
Replies: 16
Views: 7374

I would imagine so if those are the appropriate values to use in Prod. Otherwise you can set them using the code you posted, modified properly of course.
by chulett
Wed Jun 13, 2012 11:27 am
Forum: General
Topic: KeyMgtGetNextValueConcurrent() generating duplicate records.
Replies: 16
Views: 7374

Did you edit the routine code? :?

From what I recall, it creates a Type2 hashed file and yet the posted code says 'DYNAMIC' as in Type30. Does it match with what you see for that same routine back on your 7.x server?
by chulett
Wed Jun 13, 2012 10:38 am
Forum: General
Topic: KeyMgtGetNextValueConcurrent() generating duplicate records.
Replies: 16
Views: 7374

Yes.