DB2 Interview Questions and Answers For Graduates Part-3
21.What are some of the main fields in SQLCA? Major Fields in SQLCA is SQL CODE, SQLERRM, and SQLERRD.
Read MoreSalesforce.com Lightning and Lightning Web Component – Learn & Share
21.What are some of the main fields in SQLCA? Major Fields in SQLCA is SQL CODE, SQLERRM, and SQLERRD.
Read More11.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, the partial string matches would do.
Read More1.How to find number of rows in DB2 tables? User has to use SELECT COUNT (*) on DB2 query.
Read More41.Write a query to delete a table from database.? DROP TABLE table-name is the syntax to delete a table from database.
Read More31.When you will face SQLCODE -911? At the time of deadlock or timeout you will face SQLCODE -911.
Read More21.When you will face SQLCODE -922? If a user is not authorized to access DB2 objects, he will face SQLCODE -922.
Read More11.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 B.
Read More1.What is the picture clause of Null Indicator variable? S9(4) COMP is the picture clause of a null indicator.
Read More