where will u check for sqlcode ?

Answer Posted / shaan

Be sure to include sqlca in working storage section.
Then you can check sqlcode from the copybook variable SQLCODE.

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does db2 mean?

776


Give a brief description of db2 isolation levels?

795


What is db2 stogroup?

893


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11381


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

916


How to execute stored procedure in db2 command editor?

747


What is drop table?

777


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2977


What is declare cursor?

824


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

800


How to find the maximum value in a column in the db2 database?

825


what is the role of the cursor in db2?

817


How is a typical db2 batch pgm executed?

868


Is db2 a database?

741


What are host variables in db2?

813