Other than that one error message, there is no other message related to this.
I don't see an ORA error in the Director log. I know that my target ORAOCI9 stage is taking the value as a string and trying to insert into a number(4,2) but I am trying to understand why no ORA error is produced.
Search found 503 matches
- Mon Apr 18, 2016 2:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error: ORA-01438: value larger than specified precision
- Replies: 9
- Views: 11356
- Mon Apr 18, 2016 7:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error: ORA-01438: value larger than specified precision
- Replies: 9
- Views: 11356
- Mon Apr 18, 2016 5:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error: ORA-01438: value larger than specified precision
- Replies: 9
- Views: 11356
- Sun Apr 17, 2016 9:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error: ORA-01438: value larger than specified precision
- Replies: 9
- Views: 11356
Error: ORA-01438: value larger than specified precision
I have decimal values going into a number(4,2) column in Oracle. The job has been running fine for years. In the last run, it suddenly started giving ora-01438. Is it possible that some setting got changed?
- Wed Jan 13, 2016 5:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer. Would like to hear some ideas.
- Replies: 5
- Views: 3326
Ray, can you please explain your solution a little? For @INROWNUM=1 and 2, the key has to be 1. For @INROWNUM=3 and 4, the key has to be 2 and so on. Also, 2 is an example number. It could be some other number as well such as 5. I am having a problem in getting equal number of rows for each key. The...
- Wed Jan 13, 2016 10:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer. Would like to hear some ideas.
- Replies: 5
- Views: 3326
Transformer. Would like to hear some ideas.
I have a job with a transformer in the middle where rows are coming in. The first column is an integer column starting with 1. I would like to output integer value 1 for the first two rows, 2 for the next two rows, 3 for the next two rows and so on. I can use other stages as well if needed. Any ideas?
- Thu Aug 20, 2015 11:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading an Excel (xlsx) file
- Replies: 26
- Views: 19078
- Thu Aug 20, 2015 9:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading an Excel (xlsx) file
- Replies: 26
- Views: 19078
- Thu Aug 20, 2015 2:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading an Excel (xlsx) file
- Replies: 26
- Views: 19078
- Thu Aug 20, 2015 1:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading an Excel (xlsx) file
- Replies: 26
- Views: 19078
- Thu Aug 20, 2015 12:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading an Excel (xlsx) file
- Replies: 26
- Views: 19078
- Wed Aug 12, 2015 1:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading an Excel (xlsx) file
- Replies: 26
- Views: 19078
- Tue Aug 11, 2015 4:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading an Excel (xlsx) file
- Replies: 26
- Views: 19078
- Sat Aug 08, 2015 6:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading an Excel (xlsx) file
- Replies: 26
- Views: 19078
- Wed Jul 29, 2015 4:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading an Excel (xlsx) file
- Replies: 26
- Views: 19078