SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 03:48 AM
| ||||
| ||||
 Loading datetime values from SYBASE into DATE type in DB2 Hi all, I am trying to load data from a Sybase table with 'datetime' column into a DB2 table with 'Date' type column? I used the following command : db2 "IMPORT FROM tabname.dat OF DEL MODIFIED BY COLDEL^ delprioritychar TIMESTAMPFORMAT=\"MMM-DD-YYYY HH:MM:SS:UUUTT\" DATEFORMAT=\"MMM DD YYYY\" REPLACE INTO tabname" However i am getting these errors: SQL3128W The field containing "Jan 1 2001 12:00:00:000AM" in row "15" and column "21" was truncated into a DATE field because the data is longer than the database column. SQL3148W A row from the input file was not inserted into the table. SQLCODE "-180" was returned. SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007 Can this be done some way? Please help ASAP.... Regards, Sandy.      |
|
02-27-2008, 03:49 AM
| ||||
| ||||
| Re: Loading datetime values from SYBASE into DATE type in DB2 sandip wrote: > Hi all, > > I am trying to load data from a Sybase table with 'datetime' column > into a DB2 table with 'Date' type column? I used the following command > : > > db2 "IMPORT FROM tabname.dat OF DEL MODIFIED BY COLDEL^ delprioritychar > TIMESTAMPFORMAT=\"MMM-DD-YYYY HH:MM:SS:UUUTT\" DATEFORMAT=\"MMM DD > YYYY\" REPLACE INTO tabname" > > However i am getting these errors: > > SQL3128W The field containing "Jan 1 2001 12:00:00:000AM" in row "15" > and > column "21" was truncated into a DATE field because the data is longer > than > the database column. > > SQL3148W A row from the input file was not inserted into the table. > SQLCODE > "-180" was returned. > > SQL0180N The syntax of the string representation of a datetime value > is > incorrect. SQLSTATE=22007 > > > Can this be done some way? Please help ASAP.... > > Regards, > Sandy. > fiugure out how long your strings are and modify the database to this length. cu, indika |
 |
« newbie: Administering DB2 from clients with oleDB connection
|
8.2 Windows: Health Monitor not always work »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 02:46 AM.
