|
View previous topic :: View next topic
|
| Author |
Message |
sonasheetal
New User
Joined: 08 Jun 2005
Posts: 27
|
|
|
|
Hi All,
Please clarify this.
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? |
|
| Back to top |
|
 |
stodolas
Active Member
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. |
|
| Back to top |
|
|
sonasheetal
New User
Joined: 08 Jun 2005
Posts: 27
|
|
|
|
| stodolas wrote: |
| 9(20) isn't a valid datatype. |
Sorry it's not 9(20) it's 9(8)only. Please reply . |
|
| Back to top |
|
|
|
|
