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:[EMAIL PROTECTED] > Sent: Wednesday, June 23, 2004 10:32 AM > To: [EMAIL PROTECTED] > 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/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
