DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 503 matches
Author Message
 Topic: Error: ORA-01438: value larger than specified precision
splayer

Replies: 9
Views: 5897

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Apr 18, 2016 2:51 pm   Subject: Error: ORA-01438: value larger than specified precision
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 t ...
 Topic: Error: ORA-01438: value larger than specified precision
splayer

Replies: 9
Views: 5897

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Apr 18, 2016 7:51 am   Subject: Error: ORA-01438: value larger than specified precision
The ORA error is what I saw when I took the SQL to Oracle. It was not there in the Director log. Sorry about the confusion.
 Topic: Error: ORA-01438: value larger than specified precision
splayer

Replies: 9
Views: 5897

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Apr 18, 2016 5:33 am   Subject: Error: ORA-01438: value larger than specified precision
Yes, it was a data issue but I have a question. The error is being caused by the target ORAOCI9 stage. Why does the message say "Inserted value too large for column, row rejected"? The error is not ca ...
 Topic: Error: ORA-01438: value larger than specified precision
splayer

Replies: 9
Views: 5897

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Sun Apr 17, 2016 9:54 am   Subject: Error: ORA-01438: value larger than specified precision
DataStage® Release: 9x
Job Type: Server
OS: Unix
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 ch ...
 Topic: Transformer. Would like to hear some ideas.
splayer

Replies: 5
Views: 1531

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jan 13, 2016 5:21 pm   Subject: Transformer. Would like to hear some ideas.
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 s ...
 Topic: Transformer. Would like to hear some ideas.
splayer

Replies: 5
Views: 1531

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jan 13, 2016 10:28 am   Subject: Transformer. Would like to hear some ideas.
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
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 ...
 Topic: Reading an Excel (xlsx) file
splayer

Replies: 26
Views: 12808

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 20, 2015 11:24 pm   Subject: Reading an Excel (xlsx) file
After Import, I get the same values. Job runs fine. No errors, no messages. Just the data doesn't get moved.
 Topic: Reading an Excel (xlsx) file
splayer

Replies: 26
Views: 12808

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 20, 2015 9:12 pm   Subject: Reading an Excel (xlsx) file
I did not contact support because the process is very complex in my organization.

rkashyap, can you tell me, on the unstructured data stage, during reading - that is on the Output tab, what values ...
 Topic: Reading an Excel (xlsx) file
splayer

Replies: 26
Views: 12808

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 20, 2015 2:19 pm   Subject: Reading an Excel (xlsx) file
It seems like rkashyap has been able to make it work so wanted to hear from him.
 Topic: Reading an Excel (xlsx) file
splayer

Replies: 26
Views: 12808

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 20, 2015 1:36 pm   Subject: Reading an Excel (xlsx) file
The job works fine now but does not move any data. I get a message like this, "The length of column Col1 cannot be validated because character set conversion is involved. Truncation may occur without ...
 Topic: Reading an Excel (xlsx) file
splayer

Replies: 26
Views: 12808

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 20, 2015 12:08 pm   Subject: Reading an Excel (xlsx) file
Ok, I gave up the idea of loading data from multiple sheets.

kashyap, the link you gave has the same steps as the ones in the "Guide to Extracting Unstructured Data". Anyway, I set up the job to l ...
 Topic: Reading an Excel (xlsx) file
splayer

Replies: 26
Views: 12808

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 12, 2015 1:12 am   Subject: Reading an Excel (xlsx) file
It works when I have just one sheet in the whole spreadsheet. It is on Linux.
 Topic: Reading an Excel (xlsx) file
splayer

Replies: 26
Views: 12808

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 11, 2015 4:29 pm   Subject: Reading an Excel (xlsx) file
If I don't have anything in the "Sheet names to skip" and I want to read from the 2nd sheet and I specify its name in "Range expression", I get the error:

com.ascential.asb.cas.shared.exception.CAS ...
 Topic: Reading an Excel (xlsx) file
splayer

Replies: 26
Views: 12808

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Aug 08, 2015 6:32 pm   Subject: Reading an Excel (xlsx) file
rkashyap, thank you for your response. I have a spreadsheet with two sheets. I would like to skip the first and load the data from the second.

In "Range option", I tried "Specify the entire data ra ...
 Topic: Reading an Excel (xlsx) file
splayer

Replies: 26
Views: 12808

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 29, 2015 4:39 pm   Subject: Reading an Excel (xlsx) file
FranklinE, thank you for your response. I am trying to automate this process and having to rename each sheet with an underscore for a space would defeat the purpose.

I am trying to hear from someo ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours