Search found 42189 matches

by chulett
Wed Jun 25, 2008 7:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in Nested Condition Stage in DS7.5.2
Replies: 5
Views: 1473

Or an existing function, since it seems to be expecting a paren? :?
by chulett
Wed Jun 25, 2008 7:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Two inputs to the same hashed file
Replies: 14
Views: 2812

Sachin - if you have a specific question, please ask it. At the moment, I feel like I'm just repeating myself on the explanation, which I can't imagine is all that helpful. Rather than imagine your job design - build it. Run it. Check the outputs and the logs to see how it behaves with respect to t...
by chulett
Wed Jun 25, 2008 7:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Two inputs to the same hashed file
Replies: 14
Views: 2812

:? Again, what is unclear? The hashed file is cleared when the job starts and the stage is opened/initialized, not when the first record hits it. So, it gets cleared twice and then the records flow.
by chulett
Wed Jun 25, 2008 6:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Two inputs to the same hashed file
Replies: 14
Views: 2812

Sorry but elaborate on what aspect? What is unclear? Colin may need to be elaborating as well as we don't know the actual job design.
by chulett
Wed Jun 25, 2008 6:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSGetJobInfo for get sequence name
Replies: 4
Views: 2131

Check the online documentation for 'Macros'. At a high level, just... use it. We'd need more specifics about what exactly you are trying to do to give more specific advice.
by chulett
Wed Jun 25, 2008 6:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job stops running after some time
Replies: 13
Views: 5660

Post the other log messages. Reset the aborted job and post any 'From previous run...' message as well.
by chulett
Wed Jun 25, 2008 6:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Two inputs to the same hashed file
Replies: 14
Views: 2812

How can this be what? Working? The 'Clear' happens when a job starts and the stage 'opens' so guessing it is happening twice right up front when it doesn't matter.
by chulett
Tue Jun 24, 2008 11:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSGetJobInfo for get sequence name
Replies: 4
Views: 2131

If you are looking for a macro, a job can find out what is 'calling' it using the DSJobController macro. Same as via the DSGetJobInfo() function using the DSJ.JOBCONTROLLER Info Type.
by chulett
Tue Jun 24, 2008 10:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job stops running after some time
Replies: 13
Views: 5660

Automatically stops? Sounds like you are running this from the Director with a Row Limit of 100. If so, it would log an entry similar to this:

At row 100, link "X"
Run stopped
by chulett
Tue Jun 24, 2008 6:32 pm
Forum: General
Topic: ETL Specification
Replies: 8
Views: 6305

MattKeevil wrote:The FastTrack software looks like it's a POST development documentation tool

Nope. Pre. :wink:
by chulett
Tue Jun 24, 2008 5:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How do i compare ??
Replies: 12
Views: 2316

Never mind the fact that there's no indication of a need to delete anything, just detect.
by chulett
Tue Jun 24, 2008 5:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stings parameters w spaces passed in quotes when scheduled
Replies: 5
Views: 1420

Pretty sure someone has already posted on this issue, but I don't recall if there was anything in the way of a resolution. Curious what IBM Support comes up with.
by chulett
Tue Jun 24, 2008 1:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: wanna know the usage of the container
Replies: 5
Views: 996

It should only be 'greyed out' until you select / highlight an object on the right-hand side... like your shared container.
by chulett
Tue Jun 24, 2008 8:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: To get rid of special characters
Replies: 6
Views: 1644

Ack!... that's correct, I always use it to strip characters and forgot how the replace works. You need a string of spaces for the second argument as long as the string of special characters, as it is a one-to-one positional replacement.
by chulett
Tue Jun 24, 2008 8:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sysdate in the job
Replies: 2
Views: 905

I built a routine to leverage the former and call it in the Initial Value of a stage variable. That sets it once and then I can apply it to all records in the load.