Re: [HACKERS] standards question

>>>>> "meskes" == Michael Meskes <meskes(at)topsystem(dot)de> writes:

> Is there a standard that defines how to return information from
> an embedded SQL statement? ORACLE uses the sqlca. In particular
> it uses sqlca.sqlerrd[2] for affected tuples. Is this correct
> with the standards? How do other systems do that?

sqlca is fairly standard in most databases. It was the recommended method of
doing exception handling in the past. The SQL2 (SQL/92) standard went
to using SQLSTATE variable and GET DIAGNOSISTICS statement.

> Michael -- Dr. Michael Meskes, Project-Manager | topsystem
> Systemhaus GmbH meskes(at)topsystem(dot)de | Europark A2,
> Adenauerstr. 20 meskes(at)debian(dot)org | 52146 Wuerselen Go SF49ers!
> Go Rhein Fire! | Tel: (+49) 2405/4670-44 Use Debian GNU/Linux!
> | Fax: (+49) 2405/4670-10

--
Kent S. Gordon
Architect
iNetSpace Co.
voice: (972)851-3494 fax:(972)702-0384 e-mail:kgor(at)inetspace(dot)com