Re: #sql-status

["Kimberly B." <KBLUMEN@SEARS.COM>]

Jim,

According to the book that I have, SQR for Peoplesoft by Landres, these values
are database dependent and they can be found in your database manual.





 (Embedded
 image moved   Jim Hardesty <jhardest@LMBERRY.COM>
 to file:      12/03/99 12:46 PM
 pic06306.pcx)




Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Kimberly Blumenberg)
Subject:  #sql-status




(Oracle 7.3 )

Does anyone have any documentation detailing what values end up in #sql-status
based on what error conditions in a begin-sql (duplicate key on insert, unable
to
delete, etc)?  The book just says that various appropriate values are put into
that
variable.  What would these values be?

The only one we know if that -9 means duplicate key in Oracle. What about all
the
other possible errors?

jim

pic06306.pcx