DB2

21.What are some of the main fields in SQLCA? Major Fields in SQLCA is SQL CODE, SQLERRM, and SQLERRD.

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, …

1.How to find number of rows in DB2 tables? User has to use SELECT COUNT (*) on DB2 query.

41.Write a query to delete a table from database.? DROP TABLE table-name is the syntax to delete a table from database.

31.When you will face SQLCODE -911? At the time of deadlock or timeout you will face SQLCODE -911.

21.When you will face SQLCODE -922? If a user is not authorized to access DB2 objects, he will face SQLCODE -922.

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 …

1.What is the picture clause of Null Indicator variable? S9(4) COMP is the picture clause of a null indicator.

Here is top 10 examples of (RDMS) Relational database management systems. Oracle MySQL Microsoft SQL server PostgreSQL DB2 Microsoft access Sq Lite Sybase Tera data Fire bird