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]
