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??
Search found 33 matches
- 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
- 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. ...
- 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
- 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...
- 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: ...
- 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
- 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
- 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.
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.
- 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
- 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
- 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...
- 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 =>...
- 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...
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...
- 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
- 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