Return
-
Title
Data Conversion from Decimal to INT when Importing from Excel to DB2 LUW -
Description
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. -
Resolution
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 -
Defect ID
CR109675, QAT-5728