Search found 42189 matches

by chulett
Mon Mar 01, 2010 8:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: glibc Errors
Replies: 1
Views: 962

Same answer as here:

viewtopic.php?p=357382

We didn't really need two posts for this. I know it looks like two issues but I'll wager they have a common origin point.
by chulett
Mon Mar 01, 2010 8:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error: Invalid Julian day
Replies: 5
Views: 18649

What is your target? And you haven't shown us what your input data actually looks like.
by chulett
Mon Mar 01, 2010 8:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SIGSEGV error
Replies: 8
Views: 11187

Neither do we as many issues can cause this 'segmentation violation'. In my experience, with Oracle it can be a bug in their client code which only a very small number of jobs trigger. Check with your offiical support provider as I don't believe Oracle RDB is officially supported and there may be so...
by chulett
Mon Mar 01, 2010 8:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job sequnece re running aborted job only
Replies: 12
Views: 6638

This is your problem: 1. jc..JobControl (@Coordinator): Removed checkpoint record at successful completion of sequence How are you running the job sequence the second time? Is it being reset before being rerun or are you simply running it again? The former will remove all checkpoints so it starts fr...
by chulett
Mon Mar 01, 2010 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading files using file pattern -Is there a max limit?
Replies: 14
Views: 11213

Very few operating systems have no limit, most have an "arg max" config variable that sets where you get the dreaded "arg list too long" error from the globbing that goes on. There are workarounds if you were doing this manually, however since it's hard to say if that's the issu...
by chulett
Mon Mar 01, 2010 7:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML parsing, zero records in o/p file
Replies: 20
Views: 6805

No, not with EReplace() in the job, edit the file and try processing the new edited file.
by chulett
Sun Feb 28, 2010 8:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Evaluating Datastage
Replies: 5
Views: 1886

Elastic Compute Cloud? :?
by chulett
Sun Feb 28, 2010 8:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle 9i plug in: Problem in using 'User defined query'
Replies: 10
Views: 3534

Three years later? :wink:
by chulett
Sat Feb 27, 2010 3:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Manipulation
Replies: 7
Views: 2277

I specifically left it off as it seemed to be optional and since there seemed to be no actual time component incoming...
by chulett
Sat Feb 27, 2010 11:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Manipulation
Replies: 7
Views: 2277

I was going to let them work out the gory details, but... there you go. :wink:
by chulett
Sat Feb 27, 2010 11:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Manipulation
Replies: 7
Views: 2277

OK, then just assemble the pieces. FullYear = (Century*100)+Year. Month and Day append a '0' when Len = 1. Cat together with your delimiter.
by chulett
Sat Feb 27, 2010 9:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Manipulation
Replies: 7
Views: 2277

What is your target? Database table? If so, what data type? I ask because of your "has to arrive in X format" statement, that won't be true for an actual Date field.
by chulett
Sat Feb 27, 2010 8:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Status code = -9999 DSJE_DSJOB_ERROR
Replies: 21
Views: 16291

Write is required, btw.
by chulett
Sat Feb 27, 2010 8:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dssh view is annoying
Replies: 3
Views: 1226

Well, for the copy/paste issue you can issue PTERM CASE NOINVERT to make that stop but make sure you still remember to type in UPPER CASE when appropriate. For the first issue, we'd probably need some help from the Old Ones here who cut their tentacles on stuff like this but in the meantime what sof...
by chulett
Fri Feb 26, 2010 2:29 pm
Forum: General
Topic: Connectivity to Cubes ?
Replies: 6
Views: 2528

Exactly, as fast as you can. And then deny all knowledge of the act. :wink: