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
