[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Imported csv contains decimal point

Posted on 2005-04-29
1
Medium Priority
?
528 Views
Last Modified: 2012-06-27
I am importing csv files into a table. The column type is decimal(9) and must remain so.

The data does not contain any decimal points (eg 196000000,197000000). The sql is as follows:

CONNECT TO DB01 USER DB01 USING PASSWORD;

DELETE FROM TABLE;
IMPORT FROM TABLE.csv OF DEL INSERT INTO TABLE;

COMMIT;

TERMINATE;

Is there any way I can prevent a decimal point being added to the end of each figure via an import argument.

When I import into a table via the GUI using the delimiter options this is not a problem.


0
Comment
Question by:servantis
1 Comment
 
LVL 13

Accepted Solution

by:
ghp7000 earned 500 total points
ID: 13898509
using the GUI, use the "SHOW SQL" button, then either save the script to a file for later use or copy and paste the exact command usage
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question