The message texts returned are shown below in their English versions. For further details, refer to System Variables in the “Using Embedded SQL” chapter of Using InterSystems SQL.
The %msg variable may contain an additional message error text for certain errors. Placeholders for these names are shown using the syntax convention. When possible (usually at SQL compile time), error messages include the name of the field, table, view, or other element that caused the error. This SQLCODE() Opens in a new tab method can also be called as a stored procedure: %SYSTEM_SQL.Functions_SQLCODE(-nnn). To determine the meaning of an SQLCODE numeric code, use the following ObjectScript statement: It is generated when a more specific SQLCODE error code is not available. The SQLCODE -400 error “Fatal error occurred” is a general error. In Embedded SQL, when SQLCODE=100 the output host variables specified in the INTO clause are nulled.
#Razorsql vs update#
For an UPDATE or DELETE these include: the specified table contains no data or the table contains no row of data that satisfies the WHERE clause criteria. For a SELECT these include: the specified table contains no data the table contains no data that satisfies the query criteria or row retrieval has reached the final row of the table. SQLCODE=100 indicates that the SQL operation was successful, but found no data to act upon. However, if the SELECT performs an aggregate operation, (for example: SELECT SUM(myfield)) the aggregate operation is successful and an SQLCODE=0 is issued even when there is no data in myfield in this case SUM returns NULL and %ROWCOUNT=1. For a SELECT statement, this usually means the successful retrieval of data from a table. SQLCODE=0 indicates successful completion of an SQL operation.
0 kommentar(er)
