From: Schroeder, Alexander (alexander.schroedersap.com)
Date: Wed Jun 23 2004 - 04:01:28 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Oops, you talked about an SQL statement ... no there isn't any that does the change
permanently in a session, you can only specify it in the CONNECT, thus using the
properties is the only option.

Alexander Schröder
SAP DB, SAP Labs Berlin

> -----Original Message-----
> From: R. Klemme [mailto:bob.newsgmx.net]
> Sent: Wednesday, June 23, 2004 10:32 AM
> To: maxdblists.mysql.com
> Subject: Change SQLMODE of a Session permanently?
>
>
>
> Hi all,
>
> although the page referenced below seems to indicate that
> it's possible to
> permanently change the SQLMODE of a session I could not find
> a SQL statement
> that does the same:
>
> http://mysql.247available.com/doc/maxdb/sqldbc/en/SQLDBC__C_8h
> .html#a204
>
> I'm specifially interested in switching the mode via a JDBC
> connection. Is
> that possible? I know that there is "EXEC ORACLE ..." but as
> I understand
> that switches sqlmode only for a single statement.
>
> Many thanks!
>
> Kind regards
>
> robert
>
> --
> "Sie haben neue Mails!" - Die GMX Toolbar informiert Sie beim Surfen!
> Jetzt aktivieren unter http://www.gmx.net/info
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
http://lists.mysql.com/maxdb?unsub=alexander.schroedersap.com

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]