Thread: SQLDA

Is there a standard about the SQL descriptor array as used by Oracle? Or is
there a standard for something similar? That is is there a standard for
working with a changing amount if input resp. output variables?

Michael
--
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net          | Use PostgreSQL!

> Is there a standard about the SQL descriptor array as used by Oracle?
> Or is there a standard for something similar?

SQL92 has a standard for SQLDAs, though they are not called that in the
standard. "A Guide to the SQL Standard" by Date and Darwen discusses the
SQL92 version of SQLDAs, and points out that:

"... several SQL products do already support some kind of SQLDA, and
even refer to it by that name, but those SQLDAs are typically not the
same as the 'SQLDA' defined in the standard. In particular, the standard
SQLDA is encapsulated (meaning that its internal structure is not
specified in the standard and is thus a fortiori hidden from the user),
whereas the same is typically not true of the SQLDAs in current
products."

They also point out that the standard includes facilities for allocating
SQL DA storage and provides mechanisms for moving data in and out of SQL
DAs.

Hope this helps.

                    - Tom

On Mon, Mar 01, 1999 at 05:06:45PM +0000, Thomas G. Lockhart wrote:
> SQL92 has a standard for SQLDAs, though they are not called that in the
> standard. "A Guide to the SQL Standard" by Date and Darwen discusses the
> SQL92 version of SQLDAs, and points out that:
>
> "... several SQL products do already support some kind of SQLDA, and
> even refer to it by that name, but those SQLDAs are typically not the
> same as the 'SQLDA' defined in the standard. In particular, the standard
> SQLDA is encapsulated (meaning that its internal structure is not
> specified in the standard and is thus a fortiori hidden from the user),
> whereas the same is typically not true of the SQLDAs in current
> products."

That's okay with me. Could we even use the PGresult structure as SQLDA?

> They also point out that the standard includes facilities for allocating
> SQL DA storage and provides mechanisms for moving data in and out of SQL
> DAs.

I wonder where to find this standard.

Michael
--
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net          | Use PostgreSQL!

> That's okay with me. Could we even use the PGresult structure as
> SQLDA?

Possibly. All the access goes through a handle (presumably) and
subroutine calls or preprocessor constructs.

> I wonder where to find this standard.

The Date and Darwen book discusses some details, which is what I was
quoting. I have a draft of the standard itself. Want me to send it?

                   - Tom