On Jan 9, 2007, at 9:36 AM, johnf wrote:
> 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)
You completely missed my point.
That spec concerns describing the database structure. It is perfect
if you are building tools for modifying the database.
It does *NOT* describe on-the-fly cursors, such as my example. There
is *NOTHING* in that spec that addresses this.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev