Thanks a lot Steffen the solution 2 was perfect for my problem El Tuesday 26 October 2004 08:58, Schildberg, Steffen escribi�: > Hi Jesus, > > Jesus Barreto [mailto:[EMAIL PROTECTED] wrote: > > I have a problem when run REPMCLI with file that content > > insert statement, the > > problem is timestamp field that don't accept timestamp format ISO > > > > in database I get a table like this > > > > XXX_TABLE(TABLEID INTEGER , TIMESTAMP_FIELD TIMESTAMP) > > > > the file content is: > > INSERT INTO XXX_TABLE(TABLEID, TIMESTAMP_FIELD) values(100, > > '2004-03-06 > > 00:29:25.000000') > > // > > . > > . > > . > > when i execute this: > > repmcli -u user,password -d database_name -n localhost -b fileName > > > > i get the next error: > > > > Error during execution > > -->-25010 > > SQL error -3050 = Invalid timestamp format:INTERNAL (error > > position: 248[line: 1, col: 248]) > > > > I try to set TIMESTANP to ISO, with > > SET TIMESTAMP ISO > > // > > but I get the same error > > With 'SET TIMESTAMP ISO' you set the format for Loader commands not for > simple SQL commands executed with the Loader. > The solution depends on the version of the Loader you use. > 1. Solution that works with every version > Replace the ISO timestamp values in your SQL commands with INTERNAL > timestamp values. This is surely not what you'd like to do, I know :-) > > 2. Solution that works starting with Loader version 7.5.00.15 > Execute the command 'SET FORMAT ISO'. This changes the format for time > and date and timestamp values in SQL commands executed with the Loader > to the one required. > > HTH. > Regards, > Steffen > -- > Steffen Schildberg > SAP DB Team > SAP Labs Berlin
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
