Hi, you may want to use the connect option 'sqlmode' of the JDBC URL. The option value 'DB2' may set the database session into the mode you want. But be aware that there may be problems, especially if the ER tool emits statements for some more recent release of DB2, or with some more sophisticated features ... but it may be worth a try.
In general, the INTERNAL and ORACLE mode are the most used modes of SAP DB, so it would be generally preferred to use one of these modes. Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: Zabach, Elke > Sent: Monday, March 03, 2003 7:54 AM > To: 'Mitko R�rup'; [EMAIL PROTECTED] > Subject: RE: SQL Mode Internal/IBM from JDBC enabled Tool > > > Mitko R�rup wrote: > > > > Hello, > > > > I tried to use a tool to generate the Table Definitions from > > ER-Diagram. > > But the generated statements are DB2 compatible, the table creation > > works, but not the generated alter table statements for the > > constraints > > definition (they are DB2 compatible). How can the SQLmode be choosen > > permanently? I found no Parameter in the webdbm settings. > > > > The statements are sent by jdbc. > > For the kernel there is no chance to choose the sqlmode permanently. > It has to be done for each session separately. > > Elke > SAP Labs Berlin > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
