21.What are some of the main fields in SQLCA? Major Fields in SQLCA is SQL CODE, SQLERRM, and SQLERRD.
DB2 Interview Questions and Answers
- DB2Interview Questions and AnswersTechnical Interview Questions and Answers
- DB2Interview Questions and AnswersTechnical Interview Questions and Answers
DB2 Interview Questions and Answers For Graduates Part-2
by Sby S11.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, …
- DB2Interview Questions and AnswersTechnical Interview Questions and Answers
DB2 Interview Questions and Answers For Graduates Part-1
by Sby S1.How to find number of rows in DB2 tables? User has to use SELECT COUNT (*) on DB2 query.
- DB2Interview Questions and AnswersTechnical Interview Questions and Answers
DB2 Interview Questions and Answers For Freshers Part-5
by Sby S41.Write a query to delete a table from database.? DROP TABLE table-name is the syntax to delete a table from database.
- DB2Interview Questions and AnswersTechnical Interview Questions and Answers
DB2 Interview Questions and Answers For Freshers Part-4
by Sby S31.When you will face SQLCODE -911? At the time of deadlock or timeout you will face SQLCODE -911.
- DB2Interview Questions and AnswersTechnical Interview Questions and Answers
DB2 Interview Questions and Answers For Freshers Part-3
by Sby S21.When you will face SQLCODE -922? If a user is not authorized to access DB2 objects, he will face SQLCODE -922.
- DB2Interview Questions and AnswersTechnical Interview Questions and Answers
DB2 Interview Questions and Answers For Freshers Part-2
by Sby S11.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 …
- DB2Interview Questions and AnswersTechnical Interview Questions and Answers
DB2 Interview Questions and Answers For Freshers Part-1
by Sby S1.What is the picture clause of Null Indicator variable? S9(4) COMP is the picture clause of a null indicator.