Search found 137 matches

by G SHIVARANJANI
Tue Dec 15, 2009 7:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort_455: |-100| Sort stage aborted
Replies: 10
Views: 4323

Possibly. Both the column names and data types must match for it to "map" properly. Do they? ... Sort Input stage has Varchar,varchar,varchar,decimal,varchar,varchar D_PERD_STRT,D_PERD_END,D_CAL,SUM,ID,I_PLT 2010-12-13,2010-12-13,2010-12-13,12,1,08475 Output has Varchar,varchar,varchar,de...
by G SHIVARANJANI
Tue Dec 15, 2009 6:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort_455: |-100| Sort stage aborted
Replies: 10
Views: 4323

Including the mentioned "D_CAL" column? Worst case delete the stage and set it up again from scratch. ... I tried to set up now but still the issue persist :-( There are fields in the sorter stage which are numeric and date fields which are been passed as varchar fields, can this be the i...
by G SHIVARANJANI
Tue Dec 15, 2009 6:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort_455: |-100| Sort stage aborted
Replies: 10
Views: 4323

chulett wrote:Including the mentioned "D_CAL" column? Worst case delete the stage and set it up again from scratch. ...
I tried to set up now but still the issue persist :-(
by G SHIVARANJANI
Tue Dec 15, 2009 6:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort_455: |-100| Sort stage aborted
Replies: 10
Views: 4323

chulett wrote:Everything on the input link must exist on the output link. ...
Thankyou chulett

I see every thing in input is there in output with matching data types too
but still the error persists,
by G SHIVARANJANI
Tue Dec 15, 2009 6:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort_455: |-100| Sort stage aborted
Replies: 10
Views: 4323

Re: Sort_455: |-100| Sort stage aborted

Hi, My sort stage is aborting with the following error ->xivpd515PostSmoothingRndgDP_1_CHANGE..Sort_442: At row 0, link "DSLink449", while processing column "D_CAL" Input column does not promote to output column ->Sort_455: |-100| Can any one help me fix this issue please
by G SHIVARANJANI
Tue Dec 15, 2009 6:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort_455: |-100| Sort stage aborted
Replies: 10
Views: 4323

Sort_455: |-100| Sort stage aborted

Hi,

My sort stage is aborting with the following error

->xivpd515PostSmoothingRndgDP_1_CHANGE..Sort_442: At row 0, link "DSLink449", while processing column "D_CAL"
Input column does not promote to output column
->Sort_455: |-100|
by G SHIVARANJANI
Tue Feb 17, 2009 4:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding Hash File Usage
Replies: 4
Views: 1611

ray.wurlod wrote:Get a premium membership and read the rest of my response. ...
Ok
by G SHIVARANJANI
Tue Feb 17, 2009 3:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding Hash File Usage
Replies: 4
Views: 1611

No. It can't. For starters, Hashed File stage is a passive stage whereas Funnel is (technically) an active stage. And the correct terminology is HASHED file, not "hash" file. I guess if yo ... Hi Ray Thanku, But i have tried to send inputs from two sequential files (with same columns) to ...
by G SHIVARANJANI
Mon Feb 16, 2009 10:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding Hash File Usage
Replies: 4
Views: 1611

Regarding Hash File Usage

Hi,

Can any one help me undeerstand, If a hash file can be used like a funnel stage in DS Parallal edition .

Thanks in Anticipation
Shivaranjani
by G SHIVARANJANI
Mon Aug 18, 2008 1:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: STG_MRG_10,0: Update record (0) of data set 6 is dropped;
Replies: 1
Views: 2006

STG_MRG_10,0: Update record (0) of data set 6 is dropped;

Hi,, I am using merge stage to merge the counts coming from 5 aggregator stages and one oracle enterprice dependint on 5 key columns. the 5 key columns are common ..comming from all aggregator stages and the oracle enterprise. But when i run the job...even if the data is able to be viewed from oracl...
by G SHIVARANJANI
Tue Jul 01, 2008 5:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TRANSACTION iSOLATION
Replies: 3
Views: 1290

Any suggestions...
by G SHIVARANJANI
Tue Jul 01, 2008 1:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TRANSACTION iSOLATION
Replies: 3
Views: 1290

I am using ODBC enterprise stage and I have opened its properties where i could see Options has the settings for Isolation level as Read committed read uncommited repeatable read serailized I tried with all the four but the help for all -> says the following "Type: List Isolation level for acce...
by G SHIVARANJANI
Mon Jun 30, 2008 11:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TRANSACTION iSOLATION
Replies: 3
Views: 1290

TRANSACTION iSOLATION

Hi,

Is transaction isolation possible in ODBC stage:

I need this to be set as read uncommited.

as the job s are getting aborted for read committed when the records are locked by some other application.
by G SHIVARANJANI
Wed Jun 11, 2008 10:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: OpenLink][ODBC][Progress Server]Failure getting record lock
Replies: 6
Views: 3650

Thanks Craig Google should turn up a ton of links on the subject, for example this one. The concepts are similar across all databases. Again, questions like this really need to either go to your DBA for Progress specific answers or through your official support provider back to the vendor for guidan...
by G SHIVARANJANI
Wed Jun 11, 2008 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: OpenLink][ODBC][Progress Server]Failure getting record lock
Replies: 6
Views: 3650

Hi, Could you please throw light on ' 'uncommitted' read over ODBC. ' If anyone did, they would post them. Have you talked to your Progress DBA about this? My Progress days are way behind me so can't really offer any concrete advice except to see if there's any way to do a 'dirty' or 'uncommitted' r...