- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What will be the result if SQLCA is not included in a COBOL-DB2 program?
The SQLCA helps in the communication between DB2 and COBOL-DB2 program. The SQLCA has multiple fields which gives us different information regarding the last executed SQL query.
The SQLCA is mandatory in a COBOL-DB2 program. However, if we do not give the SQLCA using the INCLUDE statement then the program compilation will fail and we will get the below error in the logs−
“SQLCA is not defined as a data-name”
- Related Articles
- How will the COBOL-DB2 program behave if the DCLGEN member is not included?
- How to use SQLCA in a COBOL-DB2 program? What is the purpose of SQLCA?
- What is the purpose and usage of SQLCODE within the SQLCA in a COBOL-DB2 program
- What will happen if a NULL value is detected for a SQL statement in COBOL-DB2 program and the NULL indicator is not used?
- What will be the result if DCLGEN is given with COPY statement and not INCLUDE?
- How will you keep the CURSOR open after firing COMMIT in a COBOL-DB2 program?
- How to precompile a COBOL-DB2 program?
- How will you detect the condition of the end of cursor rows in a COBOL-DB2 program?
- Steps involved in compilation of a COBOL-DB2 program
- Implementation of restart logic in a COBOL-DB2 program
- What is the purpose and usage of “WHERE CURRENT OF” clause in a COBOL-DB2 program?
- What is the purpose and usage of “FOR UPDATE OF” clause in a COBOL-DB2 program
- How can you revert all the DB2 table changes done in a COBOL-DB2 program?
- What are the steps involved to use a CURSOR in any COBOL-DB2 program?
- What is the purpose of the "FOR UPDATE OF" clause in a cursor? What will happen if we fire an UPDATE statement without using this clause in a COBOL-DB2 program?

Advertisements