Re: [INTERFACES] SQLDA - Mailing list pgsql-interfaces

From Thomas G. Lockhart
Subject Re: [INTERFACES] SQLDA
Date
Msg-id 36DAC925.99702276@alumni.caltech.edu
Whole thread Raw
In response to SQLDA  (Michael Meskes <Michael_Meskes@topmail.de>)
Responses Re: [INTERFACES] SQLDA  (Michael Meskes <Michael_Meskes@topmail.de>)
List pgsql-interfaces
> 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

pgsql-interfaces by date:

Previous
From: Constantin Teodorescu
Date:
Subject: Re: [INTERFACES] Tables acting funny with pgaccess
Next
From: Michael Meskes
Date:
Subject: Re: [INTERFACES] SQLDA