Search found 42189 matches

by chulett
Fri Sep 02, 2011 11:28 pm
Forum: General
Topic: data validation in fixed width sequential file
Replies: 14
Views: 6063

That's not "formatted". It should be properly indented or nested if you prefer, like lint or a pretty printer for XML would do.
by chulett
Fri Sep 02, 2011 7:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Paramater Set will work for Datastage V8.1 Server Jobs
Replies: 5
Views: 1819

Question marks are a wonderful thing.
by chulett
Fri Sep 02, 2011 1:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Controller problem
Replies: 3
Views: 1859

Excellent! :wink:
by chulett
Fri Sep 02, 2011 9:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Timestamp comparison
Replies: 7
Views: 2229

Show us every step... and you don't need to convert things twice. Heck, if you were successful in converting to 24 hour strings then (as I said) you can compare them directly.
by chulett
Fri Sep 02, 2011 9:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Controller problem
Replies: 3
Views: 1859

You can guide yourself. An exact search for that error will reveal a bazillion conversations on the topic.
by chulett
Fri Sep 02, 2011 9:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Timestamp comparison
Replies: 7
Views: 2229

If you have any control over the format of the timestamp from the source, make sure it is in military time. Strings just like you posted in 24 hour time will compare just fine.
by chulett
Fri Sep 02, 2011 8:18 am
Forum: General
Topic: Help with uvconfig parameters
Replies: 10
Views: 9256

So... all of these issues are what you are seeing after you made the noted changes? :?
by chulett
Fri Sep 02, 2011 8:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Bulk Load - manual mode and ctl file generation
Replies: 6
Views: 3547

FYI - what I've done, back in the day, when I needed something like this was to post-process the .ctl file created so that it ended up with the options that I needed. If there's no options to control that still, then perhaps using something like sed would do the trick. Did for me.
by chulett
Fri Sep 02, 2011 8:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Uploading value in a job parameter
Replies: 11
Views: 2931

Left that bit for you, Ray. :wink:
by chulett
Fri Sep 02, 2011 7:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Bulk Load - manual mode and ctl file generation
Replies: 6
Views: 3547

Looks that way. Manual mode means you will arrange the actual load, all it does is create what you'd need to do so.
by chulett
Fri Sep 02, 2011 7:28 am
Forum: General
Topic: Message Handle Warnings at Sequence Job Level
Replies: 1
Views: 1797

There are no "message handlers" for Sequence jobs, if that is what you are looking for. One option is to turn off the "automatically handle" compilation option as that is what is aborting the sequence - it handles all non-zero return codes as failure. However, if you handle the f...
by chulett
Fri Sep 02, 2011 7:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Uploading value in a job parameter
Replies: 11
Views: 2931

The only "common variables" in a job are job parameters. So, sequence jobs are not allowed? The restrictions organizations put on their projects never cease to amaze me. [shakes head] :? What mechanism are you using to schedule your jobs? Do you have any facility there to build and pass in...
by chulett
Thu Sep 01, 2011 12:46 pm
Forum: General
Topic: Getting error in $CommandOutput
Replies: 11
Views: 5018

Actually, you should be able to help yourself. Do an exact search of the forums for "ParamValue/Limitvalue is not appropriate" and you'll find this has been discussed many times.
by chulett
Thu Sep 01, 2011 10:20 am
Forum: General
Topic: dsjob on v 8.5
Replies: 6
Views: 3906

For 8.x you need to add the -domain option to the command from what I recall.
by chulett
Thu Sep 01, 2011 10:17 am
Forum: General
Topic: Datastage version
Replies: 8
Views: 2498

Didn't say that. I for one have no idea what problems, if any, you may or may not see doing that.