Search found 42189 matches

by chulett
Wed Feb 11, 2015 7:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Output needs to move in different jobs
Replies: 10
Views: 2264

Don't you have anyone you work with that can help mentor you? Or are you truly doing this all on your lonesome somehow? :? A constraint is an expression that evaluates to TRUE or FALSE. When it evaluates to true for a given row, that row is allowed down that link. When false, it is not. So... how do...
by chulett
Wed Feb 11, 2015 6:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with Job run with XML stage
Replies: 2
Views: 2281

Sounds to me like you have a different "pxbridge" problem. If it worked with one userid and doesn't when run by another, you have a permissions problem. Probably with reading your XML source. Guessing the group(s) your id belongs to isn't quite right but that's the first place I'd suggest ...
by chulett
Wed Feb 11, 2015 6:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Insert New Rows Only using ODBC Connector to MSSQL
Replies: 10
Views: 8341

OK, as far as I know it can't properly do updates via RCP as it doesn't know the key columns to bind into the where clause. I seem to recall an interesting post from Arnd on the subject and how he had to dynamically generate a schema at runtime with the key information to get their 'generic' job to ...
by chulett
Wed Feb 11, 2015 4:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rollback when using multiple input links
Replies: 2
Views: 1589

If you have multiple links into the same target stage, then yes an abort during any operation will rollback whatever hasn't been committed at that point in all of the links. At least that was my experience in the past in a pre-connector world, so assuming (for better or worse) that it still works th...
by chulett
Wed Feb 11, 2015 3:36 pm
Forum: General
Topic: uvconfig shared memory settings for side by side versions
Replies: 6
Views: 2374

mfavero wrote:If these memory variables are offsets then I would think they should be different for every version running.
As noted they are offsets (xxxxOFF) from the base shared memory location of each installation not the same memory location between installations which is why there is no conflict.
by chulett
Wed Feb 11, 2015 2:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Insert New Rows Only using ODBC Connector to MSSQL
Replies: 10
Views: 8341

Hopefully you've involved support in this.

As to your update issue, is this still with RCP enabled?
by chulett
Wed Feb 11, 2015 10:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Netezza Connector Stage - DSN
Replies: 3
Views: 1260

Remove it from the DSN.
by chulett
Wed Feb 11, 2015 10:30 am
Forum: Site/Forum
Topic: How does premium membership work after paying the fee?
Replies: 4
Views: 9356

June of last year? :shock:

That would have been good to mention up front. Did you try emailing "editor@dsxchange.net" as other posts mention?
by chulett
Wed Feb 11, 2015 9:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before SQL statement in DB2 Connector not working
Replies: 4
Views: 1275

You didn't answer the syntax question. And I don't recall ever seeing a view that needed to be constantly recreated with a dynamic date range, rather you create something more 'generic' and then constrain the data when you select from the view. I understand it's in a subquery but still... hard to sa...
by chulett
Wed Feb 11, 2015 9:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Insert New Rows Only using ODBC Connector to MSSQL
Replies: 10
Views: 8341

Re: Insert New Rows Only using ODBC Connector to MSSQL

* Create a copy of the table with the same structure - job will work as it is supposed to. * Create the table on a new DB (same server) - job still hangs. These two statements seem... contradictory. The first would also seem to imply that the 'copy' was in fact not identical, any chance of that? :?...
by chulett
Wed Feb 11, 2015 7:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Px job
Replies: 6
Views: 2230

It should be pretty obvious that we don't understand the requirements or we wouldn't be asking questions - primary amongst them still being what are your requirements? In words, not data please. We prefer not to guess... but I have a little and provided solutions for those guesses. If you need somet...
by chulett
Tue Feb 10, 2015 10:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed File - Read and Write Cache Setting
Replies: 12
Views: 6803

And the version it was fixed in would have been "not yours" it would seem. Dang.
by chulett
Tue Feb 10, 2015 7:14 pm
Forum: Site/Forum
Topic: How does premium membership work after paying the fee?
Replies: 4
Views: 9356

It's a manual process and can take a day or three. You'll know it is in effect when it says "Premium Member" next to your name over on the left.