1)I have one field having datatype as 9(20) and this filed should be moved to one of the DB2 filed which may be int or decimal.
I think any Db2 datatype is not equivalent to 9(Usage is Display).
What needs to be done for this case?
Are both value as well as datatype considered for the internal movement in DB2?
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
9(20) isn't a valid datatype. What is the actual datatype, CHAR, VARCHAR, decimal, int? 9(20) isn't valid for the definition of a decimal either. That would mean the number is 9 digits long with 20 decimal places. You can't have more decimals than you have digits.