When I import a table definition from SQL Server 2008 (via ODBC Table definition import wizard in DS), any column that is defined as Integer in the DB gets imported as Int but with a precision of 10 - anyone know where this default is set and if that can be modified?
Thanks in advance
Import columns with integer datatype from SQL Server 2008
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
10 is the maximum number of digits that an Integer data type can have. Therefore, when represented as a string, a precision (length) of 10 seems appropriate. In fact it's not, because you also need a position for the sign!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
