RE: SQL Syntax

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Joe,

Maybe you are thinking of table based functions. They let you
masquerade any
data as a table but were only added to DB2 on the iSeries with V5R2.
Other
platforms have had them for a few years. This is a very nice feature
and I
suspect was added to better support hierarchical data like XML. A table
based
function is far better at representing hierarchical data than Oracle's
connect
by syntax.

David Morris

>>> joepluta@PlutaBrothers.com 10/30/02 08:02AM >>>
> From: Joe Pluta
>
> I'm no SQL guru (Duh!), but it was my understanding that a stored
> procedure
> can be made to look like any other table to SQL, and thus to CLI,
and
> ultimately to ODBC.  Therefore, any of the methods you mentioned
should be
> able to handle these stored procedures transparently.

I get the feeling you're telling me I cant do a SELECT and have it
passed to
a stored procedure, right?  Hmmm.  That makes me less enamored of
stored
procedures.  I thought there was a way to let them masquerade as
tables,
rather than having to explicitly call them.  Because you're right, if
that
limitation exists, then triggers are pretty much the only way to go to
encapsulate the database to the level that I was proposing.

Joe