All Gurus,

I am trying to load a CSV file from my PC (windows XP) to Db2 v8.1 (UNIX
server). The file is an excel sheet (user input) converted to a CSV. I
am able to load the file to the table but the problem I am facing is
that there is a amount field in the input which has values like '$10000
'and I need the data to be numeric for my application, is there a way I
can put a some logic to remove the '$' and load just the numeric data.


-------Code being used ----

IMPORT FROM 'C:/data/DD Limits Dec 2007.csv' OF DEL COMMITCOUNT
AUTOMATIC
SKIPCOUNT 2
MESSAGES c:/data/import_dd_limits.log
REPLACE INTO DDN.DD_LIMITS
(Region,Pricing,Name,Account,Amount);

-----------------
I am very new to DB2 so don't have any Idea what I should be looking at,
I tried searching the documentation but couldn't find any thing good,
any help in this direction would be great.

Thanks in advance-
-Raj



LEGAL DISCLAIMER
The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.

SunTrust and Seeing beyond money are federally registered service marks of SunTrust Banks, Inc.
[ST:XCL]





DB2 & UDB email list listserv db2-l LazyDBA home page