On Tuesday 09 January 2007 06:26, Ed Leafe wrote: > On Jan 9, 2007, at 9:19 AM, johnf wrote: > > Also I'm not to sure normal users have access to the > > "information_schema". I > > only know that access is assumed OK on public "sysobjects tables". > > Even if they have complete unfettered access to information_schema, > what good would it do for this query? > > select sum(orderitems.amount) as totalsales, ... > > Where will information_schema have anything about the 'totalsales' > column in your cursor? > > Use the dbapi, Luke! > > -- Ed Leafe > -- http://leafe.com > -- http://dabodev.com > > > > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Did a little research on the web. I'm GUESSSSSSING. Carl are you using information_schema table to comply with SQL 92???? There is a good article at http://www.dbazine.com/db2/db2-disarticles/pelzer4. So Carl may be doing the right thing. I'm using sysobjects tables and not the information_schema table. However, many of the database engine do NOT provide a " information_schema table" (Oracle is one) As far as the code - I'll have to see what he is doing and why. But if the " information_schema table" provides what we need then I think it make sense to use it. Of course I'm not to sure I would have committed without discussion. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
