Re: Any way to determine at connect time whether DB is mode ANSI?

In article <34C6CDCA.6594@accentsoftware.com>, "Accent Software, Inc." <accent@accentsoftware.com> writes >Martin A. Thompson wrote: >> >> Is there any way to determine whether a DB is ANSI mode at connect time and >> then determine whether or not to execute code to initiate "Begin Work' >> statements??? Is there a flag I could use?? Perhaps a table I could check >for?? >> I'm using ESQL/C version 7.2. I'm not sure what the engine is... > >Try the sysdatabases view in the sysmaster database. You could >have transactions (i.e. Begin Work...Commit Work) even for a >logged database, the only database mode that doesn't allow this >is an unlogged. > >Good luck, >Arun Check sqlca.sqlwarn[2] This is set to 'W' when you open an ANSI -compliant database. (Informix Guide to SQL Tutorial Version 6.0 Page 5-10. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care