> 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.
But am I right about a C function that does it? If so, functionality is there already and then I'd like to place a feature request to have an SQL statement in a future version of MaxDB that does the job. :-) robert > > 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] > -- "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]
