- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How will the COBOL-DB2 program behave when there is a mismatch between the host variable and number of columns in the SELECT statement?
In case there is a mismatch in the number of columns and number of host variables,the query will fail. There are two ways in which we can detect this condition.
The SQLWARN3 field of SQLCA will get the value as ‘W’ in case there is a mismatch.
In some installations the SQLCODE field for SQLCA gets the error code as -804 when there is a mismatch.
We can use IF condition to check the value in SQLWARN3 or SQLCODE and direct the program processing accordingly.
- How will the COBOL-DB2 program behave if the DCLGEN member is not included?
- What are the COBOL host variable equivalent for various DB2 data types?
- Behaviour of a COBOL-DB2 program when number of locks exceed the limit
- What is the usage and purpose of DCLGEN and host variables used in COBOL-DB2 program
- What is COBOL host variable equivalent for various DB2 data types?
- How will you detect the condition of the end of cursor rows in a COBOL-DB2 program?
- What will be the result if there is a timestamp mismatch in the DBRM and Load module?
- What will be the result if SQLCA is not included 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?
- How will you keep the CURSOR open after firing COMMIT in a COBOL-DB2 program?
- What is the purpose and usage of SQLCODE within the SQLCA in a COBOL-DB2 program
- How to truncate trapping of a DB2 column data when assigned to a host variable
- Impact of database downtime on the COBOL-DB2 program
- How LOST UPDATE and DIRTY READ impact the processing of a COBOL-DB2 program?
- How to use SQLCA in a COBOL-DB2 program? What is the purpose of SQLCA?