When checking the return status of an SQL statement, why is it advisable to use SQLCA.SQLCODE instead of STATUS?

When checking the return status of an SQL statement, why is it advisable to use SQLCA.SQLCODE instead of STATUS?

A. The STATUS variable is always set by INT_FLAG.

B. STATUS may have inadvertently been set by a 4GL application statement.

C. The STATUS variable may have been incorrectly defined by the developer.

D. The STATUS variable is not set by SQL statements, only by 4GL application statements.

Answer: B

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments