better idea. choose one or the other.






"Rosen Alan " <db2udbdba-ezmlmshield-x63288655.[Email address protected]
01/24/2008 04:11 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: DB2 : IMPORT FILE , data modification






Why so fancy, you don't need a macro Daniel.
Just format the column in Excel to Number instead of Currency before
creating the csv.

Alan Rosen

-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x12380428.[Email address protected]
Sent: Thursday, January 24, 2008 4:00 PM
To: LazyDBA Discussion
Subject: Re: DB2 : IMPORT FILE , data modification

cant you put a macro in the spread sheet to strip it off before you
create
the csv






"Nambiar.Dheeraj "
<db2udbdba-ezmlmshield-x92569045.[Email address protected]
01/24/2008 03:45 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
DB2 : IMPORT FILE , data modification






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]






---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
How am I doing? Please contact my manager at [Email address protected]
with your feedback. (This is an auto-generated message soliciting
comments on AST employee performance. We welcome your feedback and will
utilize the information you provide in our continuing pursuit of service
excellence.)


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



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