Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Data Conversion from Decimal to INT when Importing from Excel to DB2 LUW
설명
When importing a file from Excel into a new DB2 table with the Import Wizard, colums that contain Decimal Data (e. g. 325,38, with , instead of . on a German system) are generated as INT by Default. This can be changed manually do DECIMAL(10, 2), but with Excel-Files that contain many columns this is very unconvenient. Similar problem: Date is generated as TIMESTAMP.
해결 방안
WORKAROUND Change the Window regional settings to : decimal to . and the digit grouping to ,
STATUS Fixed in Toad Data Point v3.8, available to download here
