Re: [INTERFACES] SQLDA

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Michael Meskes <Michael_Meskes(at)topmail(dot)de>
Cc: PostgreSQL Interfaces <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] SQLDA
Date: 1999-03-01 17:06:45
Message-ID: 36DAC925.99702276@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • SQLDA at 1999-02-23 19:45:37 from Michael Meskes

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dave Page 1999-03-01 17:15:55 RE: [INTERFACES] passing variable between cgi
Previous Message Constantin Teodorescu 1999-03-01 16:23:13 Re: [INTERFACES] Tables acting funny with pgaccess