The last component of the timestamp is microseconds. It should be 6 bytes
long, not 2. Try using

500,1996-07-30-00.00.00.000000,1996,7.00,212,0,19.88,80.70,,0.00,20.09,7.98,2352,7.32,7.31,187.40,2.96,,,,,,,



Al Glinter ? Lead Database Administrator ? I.T. Solution Center
Lord & Taylor ? 500 North Broadway, Suite 1250 ? Saint Louis, MO 63102
phone (314) 552-3752 email [Email address protected]
www.lordandtaylor.com



"Joanna Grossman "
<db2udbdba-ezmlmshield-x9059158.[Email address protected]
01/23/2008 09:28 AM

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

Subject
"padded with blanks"






Hi all,

I'm loading a .csv of lines like the one below. The second field is a
timestamp. Can anyone help me understand why I keep getting the error
that follows it?

500,1996-07-30-00.00.00.00,1996,7.00,212,0,19.88,80.70,,0.00,20.09,7.98,2352,7.32,7.31,187.40,2.96,,,,,,,

SQL3129W The date, time, or timestamp field containing
"2007-11-05-09.15.00.00" in row "395078" and column "2" was padded with
blanks.

Thanks.
JG

--
Joanna Grossman
Web & Data Manager
Vermont Monitoring Coop
http://www.uvm.edu/vmc

Schedule
http://sal.snr.uvm.edu/vmcdev/joannasSched



---------------------------------------------------------------------
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