Billy Willoughby wrote: > > Hello Everyone; > > I've been programming with Sybase Adaptive Server Anywhere for > years. I've downloaded SAPDB, set it up and created a > database and a few > tables without issue. I was just wondering if SAPDB was set > to an ANSI > standard and what could I expect to run into switching from > Sybase to SAPDB, > and if you have any general recommendations for someone new > to the product.
You know of the SQLMODE ANSI (SQL92-entry-level-conform?). Usually INTERNAL sqlmode is used, which has some extensions, some minor changes to the standard. The number and size of problems occuring when switching from one database system to another one depends on the number and difficulty of extensions to the standard which were used in the database you used so far. Noone can (without knowing your schemas, queries and so on) say if your hairs will become grey when trying to switch or if it is just a work of 1 day, no matter which one is the 'old' database and which one is the 'new' one. Give it a try and let us know if you succeeded or where detailed info will help for a detail-problem. Elke SAP Labs Berlin > The only thing I seem to have run into so far (2 weeks of > playing) is the > delimiter seems to not be a semi colon. I've worked with DB2 > and Sybase and > I have to say that I really like your interface and your > database overall > seems easy to setup. I look forward to learning more about > tuning, writing > sql and stored procedures in it. > > Thank you for your time, > > Billy Willoughby > _______________________________________________ > 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
