In Embedded SQL, when SQLCODE=100 the output host variables specified in the INTO clause are nulled. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |