Yeah, but it doesn't really have blanks. That's what I don't understand.
Ken Daulong DC-98 wrote:
> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address as normal
> **Anything below this line is the original email text
>
>
> It's not an error. It is only a warning/notifications that this is
> happening.
> SQL3129W = Warning
> The field data in the input file was shorter than the database column.
> The data on the right is padded with blanks.
>
>
>
> -----Original Message-----
> From: Joanna Grossman
> [Email address protected]
> Sent: Wednesday, January 23, 2008 9:28 AM
> To: LazyDBA Discussion
> 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
>
>
> This message is subject to PrimeSource's policies regarding
> the confidentiality and non-disclosure of the company's
> confidential and proprietary information. Any unauthorized
> disclosure of the contents of this message and/or any attachments
> hereto is strictly prohibited.
>
>
>
--
Joanna Grossman
Web & Data Manager
Vermont Monitoring Coop
http://www.uvm.edu/vmc
Schedule
http://sal.snr.uvm.edu/vmcdev/joannasSched
DB2 & UDB email list listserv db2-l LazyDBA home page