SQL3192N on LOAD with TIMESTAMPFORMAT

[db2rules]

Hello all,
I'm running 600k exported SyBase records into a DB2 table on NT using LOAD. The input data's timestamp isnt' in the format DB2 likes so I'm using the TIMESTAMPFORMAT "file type modifier" of LOAD.
I'm getting:
SQL3192N In the filetmod a user specified format "TIMESTAMPFORMAT" beginning with the string "MM" is not valid.

Here's my input string:
232,958,"Y",302,302,0,"C","T",,8,"","BEDDDD, RMANS","","","4622","","","","","","","","","","","","","","S","","","04/23/1997 00:00","","Y",,"Y",3407.09,2926.62,300.00

Here's my LOAD control card:
db2 load from disk1\AS962336572.DEL of del modified by timestampformat="MM.DD.YYYY HH:MM" replace into CL_ASSIGNMENT_INFO

Has anyone run into this problem before?

Thanks for any information you might have!
DB2 Rules.

 

[MarcLodge]

Hi,
I've not the foggiest idea on this but it did occur to me that you are specifying a '.' as the delimiter, yet the data seems to have a '/'. Could this be the problem? Could that sound be the clutching of straws?
Marc

 

[db2rules]

Thanks MarC...
Let me see if I understand you right....
the 1st run, I tried to use /'s in the control card on the TIMESATAMPFORMAT statement but it gave me this other error:
SQL3192N In the filetmod a user specified format "TIMESTAMPFORMAT" beginning
with the string "MM/DD/YYYY" is not valid. So I changed it to MM.DD.YYYY and am getting the error shown on the initial post...
Let me know if I've missread you!

 

[MarcLodge]

Hi,
you read my right, I got it wrong. Try looking

http://sp81.msi.umn.edu:999/DB2/db2dm/frame3.htm#db2dm36

for a better description and example of the timestampformat
Marc

 

[db2rules]

Thanks Marc,, that manual is slightly better than the one I was using, but nothing jumps out at me. There is a guy in another forum having the same problem, hmmmm.
So, being a mainframer, I'd go to IBMLINK to search for the problem or post a question, do you or anyone else know how to go about contacting IBM on DB2/UDB for NT problems like this?
Thanks!
DB2 Rules

 

[db2rules]

All, the fix to this came through in another forum and it works!

C:\DB\stuff>db2 load from loadin.del of del modified by timestampformat=\"MM/DD/YYYY HH:MM\" insert into t1

without quotes around the datetime in the sorce file ...
ie
"",04/23/1997 10:30
rather than
"","14/23/1997 10:30"

 

[DB2er]

i always check here first when i get a problem:

http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/index.d2w/report