Search found 42189 matches

by chulett
Tue Nov 06, 2012 5:56 pm
Forum: General
Topic: get day of month in sequence trigger
Replies: 4
Views: 1975

Ah... but which one sounds best? :wink:

Just throwing out an alternative for the day that you need a check that's a little more complex.

And... yes, it does.
by chulett
Tue Nov 06, 2012 4:53 pm
Forum: General
Topic: get day of month in sequence trigger
Replies: 4
Views: 1975

Or a routine via the Routine Activity stage can do whatever checks you like and then you can trigger based on what it passes back.
by chulett
Tue Nov 06, 2012 4:51 pm
Forum: General
Topic: Run-time error '9': Subscript out of range.
Replies: 12
Views: 8460

chulett wrote:I also be curious if this happens to other people or just the OP.
It may not have been obvious, but I meant other people in the OP's office.
by chulett
Tue Nov 06, 2012 2:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameter in WHERE clause
Replies: 23
Views: 7268

Hmmm... wouldn't that preclude the use of RCP?
by chulett
Tue Nov 06, 2012 2:12 pm
Forum: General
Topic: Run-time error '9': Subscript out of range.
Replies: 12
Views: 8460

So... would the solution then be a complete reinstall of the client?

I also be curious if this happens to other people or just the OP. The latter would seem to confirm the need to reinstall the client.
by chulett
Tue Nov 06, 2012 7:49 am
Forum: General
Topic: Want to send EMAIL Notification
Replies: 2
Views: 1264

It generally doesn't require any specific 'configuration'. Have you tried simply using it yet?
by chulett
Tue Nov 06, 2012 7:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XALAN error in XML input stage
Replies: 11
Views: 4427

Jaydev wrote:@Istasur, Can i know what patches you want me to install?
As he said, all of them. Meaning, make sure you are current on patches.
by chulett
Tue Nov 06, 2012 7:43 am
Forum: General
Topic: Run-time error '9': Subscript out of range.
Replies: 12
Views: 8460

If you get an error like that simply by logging on, I would think you have some kind of corruption in the project / XMETA database and you should be contacting your official support provider for help.
by chulett
Mon Nov 05, 2012 5:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogated key generator warning how to get rid off
Replies: 4
Views: 1319

Then the warning isn't from the generator but rather from your target's attempt to squeeze a BIGINT into a NUMBER(8) field. At some point you will overflow that and the job will fail. However, in the meantime an explicit conversion may help, perhaps the DecimalToDecimal() function? Don't have any do...
by chulett
Mon Nov 05, 2012 2:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Greenplum Performance Load Tips?
Replies: 3
Views: 1803

I'd be curious what you meant by "log build up". Does the job generate a lot of warnings or informational logs?
by chulett
Mon Nov 05, 2012 7:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How many osh processes will this job create?
Replies: 6
Views: 5949

Unhijacked.

Next time please just start a new post rather than replying to whatever random post you happen to be reading at the time.
by chulett
Sun Nov 04, 2012 5:47 pm
Forum: General
Topic: DSRunJob clarification
Replies: 4
Views: 1536

So both are correct and their use depends on the context, one versus the other.
by chulett
Sun Nov 04, 2012 5:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Junk characters in Sequential file
Replies: 8
Views: 5562

We know, that was in your first post.

Did you try to follow Ray's advice to try that setting to ignore the byte order mark?