Search found 42189 matches

by chulett
Mon Oct 15, 2012 10:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterprise Stage
Replies: 1
Views: 770

From what I recall, there are a couple of $APT variables that control the commit level, either by time or row count. I don't recall a discrete option in the stage itself. Of course it depends on if you are doing a "Load" or not as no commits are done and there's no rolling back when you us...
by chulett
Mon Oct 15, 2012 3:13 pm
Forum: General
Topic: Passing parameters to a Email Stage from Table
Replies: 5
Views: 2333

Many ways to skin this cat. You could put three records in the file, cat them and then use array notation to get the 1st, 2nd and 3rd values. For example:

ExecCommand.$CommandOutput<2>

would contain the contents of the second record.
by chulett
Mon Oct 15, 2012 2:35 pm
Forum: General
Topic: DataStage V8.7 FixPack-1
Replies: 4
Views: 2805

Get rid of the period at the end...
by chulett
Mon Oct 15, 2012 2:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Case-sensitive issue
Replies: 2
Views: 981

You haven't told us what command you are using in the ESS. Grep supports -i for "case insensitive" so an ls piped to grep could filter out all of the ".xml" files regardless of case. You could also use a regular expression like [xX][mM][lL] to find them.
by chulett
Mon Oct 15, 2012 9:01 am
Forum: General
Topic: Passing parameters to a Email Stage from Table
Replies: 5
Views: 2333

Use a Server job to capture that information and store it (delimited) in USERSTATUS. The sequence can easily extract it from there and you can use Field() in the paramater assignment to split them back out. A User Variables stage can also be handy here. If you'd rather not use USERSTATUS then a flat...
by chulett
Mon Oct 15, 2012 8:56 am
Forum: General
Topic: Installing Big Data File Stage
Replies: 7
Views: 2862

Curious about this statement in the linked article: First, ensure that you have installed the product patch containing the BDFS and any of its pre-requisite patches. Setup for IBM BigInsights: The following instructions assume that you have installed IBM BigInsights in the default location (/opt/IBM...
by chulett
Mon Oct 15, 2012 7:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Create a TXT File with Row Value
Replies: 5
Views: 1407

Or perhaps by using the Folder stage as the target. Worst case on UNIX you could create one file and then use csplit after job to bust it up. Is that included in the MKS Toolkit?
by chulett
Mon Oct 15, 2012 6:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Prefetch row count
Replies: 5
Views: 5874

No such thing as "ideal values" there.
by chulett
Sun Oct 14, 2012 3:54 pm
Forum: General
Topic: Routine activity failure
Replies: 4
Views: 1052

Which is what the help would tell them. :wink:
by chulett
Sun Oct 14, 2012 3:00 pm
Forum: General
Topic: Datastage not coming up on WinXP
Replies: 1
Views: 802

Let's get this out of the way first - XP is not a supported platform for anything other than the client so the fact that you are having issues isn't really surprising. And that means information on getting it to run on XP isn't really out there anywhere.
by chulett
Sun Oct 14, 2012 7:27 am
Forum: General
Topic: Routine activity failure
Replies: 4
Views: 1052

Yes, that will affect all activities. Check the help for that "automatically handle" option as it explains how to override its check and handle that particular one yourself.
by chulett
Sat Oct 13, 2012 7:24 am
Forum: Site/Forum
Topic: Premium Membership has not been activated
Replies: 5
Views: 5135

A couple of points... It shows "expired" to you but no-one else can see that. All I and anyone else can see is that you are a Premium Member and unfortunately all that really means is at one point you were, we have no idea if your membership is currently active or not. I'm really just a re...
by chulett
Sat Oct 13, 2012 12:06 am
Forum: Site/Forum
Topic: Premium Membership has not been activated
Replies: 5
Views: 5135

Based on what - are you still seeing the big Premium Content button? Your information in the left-hand pane shows you as a "Premium Member", hence my previous statement. If you are still having issues, you'd need to contact the Membership Director using the Contact link at the top of the p...
by chulett
Fri Oct 12, 2012 11:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: substring a column
Replies: 7
Views: 1784

times29 wrote:Thats ok take it easy no comments work will never stop even if you reply or not :)
Sorry but I honestly have absolutely no idea what this is supposed to mean.
by chulett
Fri Oct 12, 2012 3:09 pm
Forum: General
Topic: Executing Unix script in Execute stage of Sequence
Replies: 1
Views: 1425

Sure, that can be handled by a specific trigger from the stage to your failure processing or you can enable "Automatically handle activities that fail" in the Sequence.