Search found 42189 matches

by chulett
Mon Oct 26, 2009 8:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SIGUSR1
Replies: 11
Views: 5266

See if this helps shed some light:

viewtopic.php?t=108766
by chulett
Mon Oct 26, 2009 8:09 am
Forum: General
Topic: Lookup warning-Ignoring duplicate entry at table record
Replies: 7
Views: 32393

Which is exactly what Arnd told you.
by chulett
Mon Oct 26, 2009 8:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: while convert timespamp to string getting warnings
Replies: 13
Views: 3676

But again, all that presupposes the input is already a timestamp which this isn't. And the formatting mask in the TimestampToString function is what you want the string to look like. :?
by chulett
Mon Oct 26, 2009 6:03 am
Forum: General
Topic: Security to datastage jobs
Replies: 5
Views: 1772

You'd have to give us a much better idea what 'the security is taken care of' means first. Be precise.
by chulett
Mon Oct 26, 2009 5:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to do datatype validation for string, decimal and date
Replies: 3
Views: 1245

Please to read the documentation for the IsValid() function.
by chulett
Mon Oct 26, 2009 5:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs are getting ended before the start time of the Job.
Replies: 7
Views: 2210

Depends on who this 'we' was... here us we people have yet to DLST. :wink:
by chulett
Mon Oct 26, 2009 5:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: while convert timespamp to string getting warnings
Replies: 13
Views: 3676

'19971001' is not a Timestamp.
by chulett
Mon Oct 26, 2009 5:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Insert error while loading the timestamp data
Replies: 4
Views: 2481

And what happens when you 'correct' the metadata? You are certainly not stuck with whatever it 'takes'.
by chulett
Sun Oct 25, 2009 9:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to differentiate a new file from the old one.
Replies: 6
Views: 1729

Stage variables are one way, only increment when ColB changes value. A Sort stage with the 'Create key change column' option would help, too - increment only when that column has a 1 in it.
by chulett
Sun Oct 25, 2009 8:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job stalls for no reason - but reruns fine
Replies: 13
Views: 3741

Good. There's a long standing DSRunJob bug where the call to start the job will crash. The called job may actually start but the calling job is in permanent limbo waiting to hear back. It never will. I wonder if that's what's going on here. :?
by chulett
Sun Oct 25, 2009 8:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job stalls for no reason - but reruns fine
Replies: 13
Views: 3741

OK... only ask about dsjob only because that was what you said you were using. Hard to diagnose something like this - do you clear your &PH& 'phantom' directory on a regular basis?
by chulett
Sun Oct 25, 2009 6:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job stalls for no reason - but reruns fine
Replies: 13
Views: 3741

So, the 'controlling' job is not a Sequence but another server job? Can you post your full dsjob syntax, please? What kind of 'aborts' are you seeing in the called job?
by chulett
Sun Oct 25, 2009 2:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dynLUT* files location question
Replies: 10
Views: 6811

I'm *told* that it is and that they've allegedly created files larger than that in the past. Any idea how I could verify that short of me trying to create a big ass file there? OK, I can find existing files > 2GB but not one as big as the size noted in the error message. And, oddly enough, they've a...
by chulett
Sun Oct 25, 2009 2:37 pm
Forum: General
Topic: install datastage v8 on virtual pc
Replies: 5
Views: 2919

Except for the fact that while the client is supported under XP, the server is not.