Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Invalid Precision from Oracle to DB2 in DataStage

Status
Not open for further replies.
kajaeger

kajaeger

Programmer
Oct 5, 2001
17
US
I am getting the error- INVALID precision when trying to move data from a large Oracle table into a DB2 table with the same characteristics in DataStage 7.1. I don't understand what to look for to resolve this- can anyone help?
 
Sort by date Sort by votes
Is this error from the Oracle or DB2 side? Take a look at date - time type fields. They may need to be converted. Also BLOB & CLOB may not map across. Lastly, check numeric fields, especially decimals.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Loanpro
  • Locked
  • Question
Passing + sign to .csv file
Replies
0
Views
73
Loanpro
Loanpro
sa0309
  • Locked
  • Question
Passing an Oracle SP error message to Informatica Email Task
Replies
0
Views
87
sa0309
sa0309
michaelvv
  • Locked
  • Question
datastage on AIX
Replies
0
Views
86
michaelvv
michaelvv
rickeybj
  • Locked
  • Question
Is there a way to transfer files from and old Tandy word processor to a PC?
Replies
2
Views
95
rickeybj
rickeybj
rickeybj
  • Locked
  • Question
Is there a way to transfer files from and old Tandy word processor to a PC?
Replies
0
Views
81
rickeybj
rickeybj

Part and Inventory Search

Sponsor

Back
Top