Search found 42189 matches

by chulett
Tue Dec 13, 2011 7:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abort the job based on the condition
Replies: 11
Views: 4283

A parallel routine? How are your C++ programming skills? Regardless, I don't see the point - stick with whatever your current resolution is.
by chulett
Tue Dec 13, 2011 7:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: critical problem
Replies: 5
Views: 2166

And also - while all help is appreciated - you might want to find more recent posts to be helping with.
by chulett
Tue Dec 13, 2011 7:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsjob -run -mode RESET -wait returns. job is not fully reset
Replies: 7
Views: 5230

Those kind of messages are common for any Server job with hashed files when it is reset. Seems odd to me that it takes that long, I don't recall seeing that kind of behaviour. Wait however long seems appropriate in your environment, all I'm saying is I've always had to do the same thing... just not ...
by chulett
Mon Dec 12, 2011 5:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What job and stage create lookuptable.YYYYMMDD.* files
Replies: 3
Views: 1911

I believe that they are actually created on disk and then loaded to memory...
by chulett
Mon Dec 12, 2011 5:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abort the job based on the condition
Replies: 11
Views: 4283

I personally don't do the Y/N thing, preferring to treat the stage variable as a Boolean since the expression will automatically resolve to true or false. I'd also suggest you always use meaningful names for your stage variables. Stage Variable svItemIs100: Inlink.Item = 100 Constraint Good row: svI...
by chulett
Mon Dec 12, 2011 5:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: KeyMgtGetNextValueConcurrent routine
Replies: 8
Views: 4341

Those have transforms associated with them, from what I remember. Once those are in place they no longer appear in the list of routines.
by chulett
Mon Dec 12, 2011 12:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsjob -run -mode RESET -wait returns. job is not fully reset
Replies: 7
Views: 5230

I've seen the same thing which is why our dsjob wrapper script always waited after resetting. We only waited something like 5 seconds from what I recall, shouldn't need to be two minutes.
by chulett
Mon Dec 12, 2011 9:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abort the job based on the condition
Replies: 11
Views: 4283

Yes, you could, but I'm not sure I'd add the 'complexity' of a lookup when this can be solved with either the proper expression or a simple constraint to a reject row set to abort after 1 row.
by chulett
Mon Dec 12, 2011 8:03 am
Forum: General
Topic: Purging logs in Datastage using a UNIX Script
Replies: 7
Views: 3042

Interesting but that must be behaviour that was changed in 8.x: When Auto-purging is in use, all instances of a job will be purged, without checking for the success or fail status. Before 8 auto-purge only worked for successful runs. Regardless, I have some concerns that it seems you want to remove ...
by chulett
Mon Dec 12, 2011 7:38 am
Forum: General
Topic: Purging logs in Datastage using a UNIX Script
Replies: 7
Views: 3042

I want the script for the second part. that is for this condition "If it is a successful job then the log must be fully cleared, If it is an aborted job, then the log must clear for just one day." Two points: 1. We'll be glad to help you write one, don't expect someone to just hand one to...
by chulett
Mon Dec 12, 2011 7:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abort the job based on the condition
Replies: 11
Views: 4283

Wrap the abort function in an if-then-else.
by chulett
Mon Dec 12, 2011 7:13 am
Forum: General
Topic: Purging logs in Datastage using a UNIX Script
Replies: 7
Views: 3042

Ok, which part do you need help with? For the first requirement, why not just let 'Auto Purge' handle that?
by chulett
Mon Dec 12, 2011 7:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abort the job based on the condition
Replies: 11
Views: 4283

What have you tried, anything?

I'd also be curious if you need to abort when the first is detected or do you need to report them all and then abort?
by chulett
Mon Dec 12, 2011 7:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null handling issue
Replies: 2
Views: 1505

I'm confused too. :? If you are trying to compare non-file sourced data with 'UNKNOWN' as the value to that same value sourced from a file where you've converted that to null, then they won't match. Don't set the null field value if you want to compare them. If you were asking something else, please...
by chulett
Mon Dec 12, 2011 7:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex Flat file- Multiple Record Types
Replies: 19
Views: 19957

Re: Complex Flat file- Multiple Record Types

srds2 wrote:With the above settings in the CFF stage I am not able to read the file.
Seems to me it would help if you explained what this means, what happens.