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

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: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