RE: SQL error -3050 = Invalid timestamp format:INTERNAL

Hi Jesus,

Jesus Barreto [mailto:jbarreto@xxxxxxxxxx] 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/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx