Thomas Lorenz wrote: > Hi! > > Because I'm porting some software, that already runs under > DB2 (and AIX), to > SAPDB and Linux, I'm very interested in the DB2-compatibility > mode of SAPDB. > I compiled the whole esql-modules with cpc -S db2 and > expected, that e.g. > the connection-statement behaves like running under DB2. But > the DB2-syntax > doesn't work (EXEC SQL CONNECT TO :hv_database USER :hv_user USING > :hv_password;). > > I didnt find anything about this in the documents. Who can > give me a hint?
Oh, the past has caught up with me/us. Yes, there is a db2 mode in the kernel. And some applications who needed it (how many years ago, I do not know) succeeded. But it was the time as C-precompiler-programs were written and the connect-statement not included in the program itself. --> At least you should use the 'normal' (internal mode) connect statement. Then some, perhaps many of your unchanged db2 statements will do, I think. But please take note of the fact that there are plans to destroy the db2-compatibility mode ! And that we did not work on the compatibility for the last ?? number of years. And that mails with change requests for db2 mode will always be answered with something like ' we warned you ' (or something a little bit more polite). And that perhaps it would have been better not to say anything about such a compatibility mode we think of getting rid of. But now we mentioned it, now we can only tell people what I have told you: if it will do for you, fine for now, but perhaps not for the rest of your application's live. sorry. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
