Search found 33 matches

by saraswathi
Wed Nov 30, 2011 2:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Decimal value getting rounded off in Sequential file
Replies: 3
Views: 2596

Thanks for the input.
We just followed the steps which was given in post on windows machine , but it didnt work for us for some reasons.

Anyone tried this on windows and got the correct result??
by saraswathi
Tue Nov 29, 2011 4:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Decimal value getting rounded off in Sequential file
Replies: 3
Views: 2596

Decimal value getting rounded off in Sequential file

Decimal value getting rounded off while writing to Sequential file. But any such rounding off is not done in hash file. This happens in situations where the incoming value is greater than 15 digit. The sequential file is reading the input value as is but while writing, it is rounding off the value. ...
by saraswathi
Mon Dec 28, 2009 2:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using String as a case in Switch stage
Replies: 4
Views: 2077

Thanks for ur response


P is my Rec_Type, If my rec_type is "P", it shud go to link 0.

I have two columns,

1st coulmn -rec_id (integer)
2nd column -Rec_Type (char1)
by saraswathi
Wed Dec 23, 2009 1:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using String as a case in Switch stage
Replies: 4
Views: 2077

Using String as a case in Switch stage

I'm not gettin the required output when i use char in my case statement. Job Design is as below, seq file --> switch --> one Reject link one outputlink Selector as Rec type--char(1) Selector type is user-defined Mapping Have given the case like Case P=0 Any idea why am i not getting no records in an...
by saraswathi
Tue Feb 17, 2009 5:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to find a free dynamic SQL instance
Replies: 7
Views: 3194

Unable to find a free dynamic SQL instance

Hi, I'm getting the below error while write the data into oracle stage Unable to find a free dynamic SQL instance. Error: Instance number must be 0 <= -1 <= 9 It was working fine before. Now we got changed to a new environment.Is this a set up issue or what? I got the following info from my search: ...
by saraswathi
Wed Feb 27, 2008 6:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Status:Aborted-Showing only warning
Replies: 5
Views: 2107

yes i'm sure. There are no fatal errors.
by saraswathi
Wed Feb 27, 2008 5:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Status:Aborted-Showing only warning
Replies: 5
Views: 2107

warning limit is 100.
but i'm getting 8 warnings only.
by saraswathi
Wed Feb 27, 2008 5:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Status:Aborted-Showing only warning
Replies: 5
Views: 2107

Status:Aborted-Showing only warning

Hi,
I'm getting some of the warnings like,
1. Prior component with the same name
2. Cannot preserve partitioning

Though the status of my job is in aborted only.Why is it so?
It should be finished(See log) right.

additional information: job ran for long time (aroud 1 hour)

I need help on this.
by saraswathi
Fri Feb 22, 2008 8:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job running: Not getting completed
Replies: 6
Views: 2517

I'm not able not to view the premium content what ray posted,
Please post it again
by saraswathi
Fri Feb 22, 2008 8:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job running: Not getting completed
Replies: 6
Views: 2517

Yes it's not getting completed.
Database side i have checked it returned value.
Also with view data it returned value
by saraswathi
Fri Feb 22, 2008 7:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job running: Not getting completed
Replies: 6
Views: 2517

Job running: Not getting completed

Hi, I'm extracting data from Oracle stage and loading it into dataset which is hash Partitioned and uniquely sorted. Copy stage is used in between just to have an active stage. Design: Oracle--->Copy Stage--->Dataset My query is containing joins between two tables.Main table having huge no of record...
by saraswathi
Thu Feb 07, 2008 7:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap allocation failed
Replies: 5
Views: 3615

Heap allocation failed

Hi, I'm getting the below fatal errors, with different jobs 1) cs}}},1: Caught exception from runLocally(): APT_BadAlloc: Heap allocation failed.. 2) main_program: /usr/lib/dld.sl: Call to malloc() failed to create BOR jump table /usr/lib/dld.sl: Not enough space 3)Contents of phantom output file =>...
by saraswathi
Tue Jan 29, 2008 5:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Internal error 40018 :the given CLink is not valid
Replies: 3
Views: 2949

Internal error 40018 :the given CLink is not valid

Hi,
I have developed a sequencer and saved it, but when i open it for the next time the links are not getting displayed and some of the activities too. i'm getting the error Internal error 40018 :the given CLink is not valid for any Relation before the job is opening.
Please help me in this...
by saraswathi
Fri Dec 14, 2007 6:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_CombinedOperatorController(4),0: Operator terminated abn
Replies: 5
Views: 4618

I gave a condition in lookup stage like, lookupindicator="Y" ,(if condition satisfies then lookup the records) lookupindicator is a job parameter, for every record it will be the same. when i Removed the condition and executed it, it is working fine. But i want to lookup only when my looku...
by saraswathi
Fri Dec 14, 2007 6:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_CombinedOperatorController(4),0: Operator terminated abn
Replies: 5
Views: 4618

I tried with "APT_DISABLE_COMBINATION" is "true".
Now i'm getting the below error in the lookup stage
my_Lkup,0: Operator terminated abnormally: received signal SIGSEGV
Why this is coming, what should be done to rectify this?