Search found 46 matches

by shobhitj
Mon Dec 14, 2009 2:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error from mtEndMatch and ERROR: vexit status=4
Replies: 5
Views: 3018

Hi Ray, I understand that this forum is not for ASAP replies. But I have written that because if someone has faced same problem then can give some replies. I have serached in the forum with this error and got only 1 post related to the error which says that CASS DB can create some problem and if the...
by shobhitj
Sun Dec 13, 2009 12:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error from mtEndMatch and ERROR: vexit status=4
Replies: 5
Views: 3018

Error from mtEndMatch and ERROR: vexit status=4

Hi, I have getting a error while running the paralle jobs having Global addres verification stage and CASS stage in it. The error is as follows - APT_CombinedOperatorController(0),3: ???(13009) Error from mtEndMatch Invalid handle or maximum number of cases exceeded from ENDCASE ERROR: vexit status=...
by shobhitj
Fri Dec 11, 2009 4:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing string values into SQL query via parameter
Replies: 14
Views: 14822

I have also faced same problem in one jobs. In my development environment i have add the escape charanter in the paramter value. It started working. But in another environment i have kept same job then there are no rows fetched in the job whenre this multi value variable used. so if i have specified...
by shobhitj
Fri Nov 07, 2008 6:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error : While Updating the Table using Netezza
Replies: 0
Views: 4861

Error : While Updating the Table using Netezza

Hi ,

I am Updating the Record in a Netezza Database Table using Netezza Stage.

I am getting Following Error:-
External Table : count of bad input rows reached maxerrors limit, see nzlog file
Error

Can any one please provide some inputs on this. if any one has faced this problem before.
by shobhitj
Wed Nov 05, 2008 8:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Special Character Issue in Datastage
Replies: 17
Views: 5060

Hi, I have loaded these records using the Netezza stage in Insert mode. The data in table is loaded perfectly. But again the same symbol come & the situation is to update the record, then we are using ODBC Stage, here the prolem comes. As ui have described in my Question that in soucre i have co...
by shobhitj
Tue Nov 04, 2008 10:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Special Character Issue in Datastage
Replies: 17
Views: 5060

The database we are using is Netezza
chulett wrote:It would help if we knew the database in question. ...
by shobhitj
Tue Nov 04, 2008 10:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Special Character Issue in Datastage
Replies: 17
Views: 5060

The database we are using is Netezza
chulett wrote:It would help if we knew the database in question. ...
by shobhitj
Tue Nov 04, 2008 9:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Special Character Issue in Datastage
Replies: 17
Views: 5060

Hi,

Can you please tell me some tools used to view the data.

ArndW wrote:shobhitj - did you end up trying another tool rather than view data and what was the result. This will bring you further towards a solution than begrudging poor Craig his hard-earned DSXChange points.
by shobhitj
Tue Nov 04, 2008 8:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Special Character Issue in Datastage
Replies: 17
Views: 5060

Yes i have contacted them, but they are also not able to provide any inputs yet.
They have contacted IBM Team for this, they are working on this but no breakthrough yet
by shobhitj
Tue Nov 04, 2008 8:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Special Character Issue in Datastage
Replies: 17
Views: 5060

hi chulett, I have written this because i needed some inputs, i have been trying many option these days but nothing worked. Please provide some useful & knowlegable input if you have otherwise please do not reply with such kind of replies for just gaining some points. this only waste others time...
by shobhitj
Tue Nov 04, 2008 2:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Special Character Issue in Datastage
Replies: 17
Views: 5060

Hey can any one provide me some input on this!!!
by shobhitj
Thu Oct 23, 2008 10:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Special Character Issue in Datastage
Replies: 17
Views: 5060

Can any one provide some inputs on this!!
by shobhitj
Mon Jul 14, 2008 4:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using Netezza Stage to Update records
Replies: 1
Views: 1545

Can any one tell me some relevant solution on this.

My question is "Can we use Netezza stage as target to update some columns of the records?"

Please give some relevant replies
by shobhitj
Tue Jul 01, 2008 6:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using Netezza Stage to Update records
Replies: 1
Views: 1545

Using Netezza Stage to Update records

Hi, I am using Netezza Stage as target to update the records. It ask to put two type of key. First is Key Column & another Uniquer Column Key Column is the column or combination of column. It ask for Unique key also. If in a table that type of column is not present then what has to be specified ...