Search found 42189 matches

by chulett
Thu Oct 14, 2010 10:07 am
Forum: General
Topic: Counting files in a Sequence Job
Replies: 9
Views: 2297

Its output *is* delivered in a dynamic array and if your version doesn't like that <1> array notation, try the other option suggested - Convert or EReplace. For example: Convert(@FM,"",exec_GetLineCount.$CommandOutput) Assuming a single "line" of returned information, that would ...
by chulett
Thu Oct 14, 2010 7:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logic required
Replies: 2
Views: 1064

Make sure you run it on a single node. I would think some kind of 'round robin' partitioning could be made to work as well...
by chulett
Thu Oct 14, 2010 7:49 am
Forum: General
Topic: To run a job based on the output of the first job
Replies: 23
Views: 5039

Post your syntax.
by chulett
Thu Oct 14, 2010 5:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored Proc Stage
Replies: 10
Views: 4646

Raise an exception and it will be captured automatically.
by chulett
Thu Oct 14, 2010 5:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage doesn't respond to call backs
Replies: 2
Views: 1198

How exactly are you 'calling a procedure in another server'? I suspect you'll end up needing to send this to your official support provider, but let's start with that.
by chulett
Thu Oct 14, 2010 5:23 am
Forum: General
Topic: To run a job based on the output of the first job
Replies: 23
Views: 5039

Which is exactly what I posted earlier. My syntax should have worked for that as well as the EReplace() as long as the correct syntax is used. :wink:
by chulett
Wed Oct 13, 2010 3:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hashlookup
Replies: 10
Views: 3799

chulett wrote:hard-code it to the same value that you hard-coded your made up key to.
xcb wrote:Update the reference link in the transformer stage setting it's lookup value to 'X' (or what ever constant you used)
by chulett
Wed Oct 13, 2010 3:45 pm
Forum: General
Topic: Sequence Abort with message Attempting to Cleanup after ABOR
Replies: 8
Views: 3466

So... nothing that says something about a "Controller problem: Unhandled failure"? :?
by chulett
Wed Oct 13, 2010 3:43 pm
Forum: General
Topic: To run a job based on the output of the first job
Replies: 23
Views: 5039

That's what I assumed, the trigger I gave you should work as it "removes" the Field Mark that is in the output. You could also use EReplace() for that.
by chulett
Wed Oct 13, 2010 9:53 am
Forum: General
Topic: Sequence Abort with message Attempting to Cleanup after ABOR
Replies: 8
Views: 3466

Can you post the actual, unedited abort error message please?
by chulett
Wed Oct 13, 2010 9:50 am
Forum: General
Topic: To run a job based on the output of the first job
Replies: 23
Views: 5039

Confirm for us the command you are executing. That and try this as the success trigger: Execute_Command_22.$CommandOutput<1>) = "SUCCESS"
by chulett
Wed Oct 13, 2010 8:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Converting BIN1 (SAP) to ASCII using ABAP Extract
Replies: 3
Views: 1321

Sorry, have zero experience with SAP. How about your official support provider?
by chulett
Wed Oct 13, 2010 8:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Single row output from XML input stage!!
Replies: 5
Views: 2072

What XPath Expressions are you using?
by chulett
Wed Oct 13, 2010 8:23 am
Forum: General
Topic: To run a job based on the output of the first job
Replies: 23
Views: 5039

Success trigger could be just Trim(Execute_Command_22.$CommandOutput) = 'SUCCESS' while for the abort an 'Otherwise' trigger would work.
by chulett
Wed Oct 13, 2010 7:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSJOB command to get runtim information each link in a job
Replies: 9
Views: 3079

It basically means 'executing' or running it in a way that it makes all of the changes listed in the file to your current environment.