Postgres Pro
Downloads
Home   >   mailing lists

Thread: standards question

standards question

From
Michael Meskes
Date:
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?

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

Re: [HACKERS] standards question

From
Bruce Momjian
Date:
>
> 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?

I believe this is standard for embedded SQL.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

Re: [HACKERS] standards question

From
"Thomas G. Lockhart"
Date:
Michael Meskes wrote:
>
> 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?

There is a part of the SQL92 standard which deals with this. My Date &
Darwen book has a chapter on it.

                - Tom

Re: [HACKERS] standards question

From
"Kent S. Gordon"
Date:
>>>>> "meskes" == Michael Meskes <meskes@topsystem.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@topsystem.de | Europark A2,
    > Adenauerstr. 20 meskes@debian.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@inetspace.com

Re: [HACKERS] standards question

From
"Kent S. Gordon"
Date:
>>>>> "meskes" == Michael Meskes <meskes@topsystem.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@topsystem.de | Europark A2,
    > Adenauerstr. 20 meskes@debian.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@inetspace.com