21.What are some of the main fields in SQLCA? Major Fields in SQLCA is SQL CODE, SQLERRM, and SQLERRD. (115)
Home / Posts Tagged "DB2 Interview Questions"
11.When the LIKE statement is used? LIKE statement is used to conduct partial searches like the search of employees by name. It is not necessary to indicate the complete name, Continue Reading »
1.How to find number of rows in DB2 tables? User has to use SELECT COUNT (*) on DB2 query. (118)
41.Write a query to delete a table from database.? DROP TABLE table-name is the syntax to delete a table from database. (171)
31.When you will face SQLCODE -911? At the time of deadlock or timeout you will face SQLCODE -911. (158)
21.When you will face SQLCODE -922? If a user is not authorized to access DB2 objects, he will face SQLCODE -922. (160)
11.In a COBOL-DB2 program all SQL statements must be coded in Area A. State whether true or false? This statement is incorrect as SQL statements must be coded in Area Continue Reading »
1.What is the picture clause of Null Indicator variable? S9(4) COMP is the picture clause of a null indicator. (149)