How can you quickly find out the number of rows updated
after an update statement?
Answer / vamshi
check for the value is in sqlerrd(3). it contains the no.
of rows updates.
Is This Answer Correct ? | 23 Yes | 0 No |
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
What is the information associated with sysibm.syslinks table?
Why might full image copies be faster to implement than an incremental image copy?
What is db2 bind?
How do I create a view in db2?
Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam
What is meant by concurrency?
My SQL is not performing well. Describe how will you fine tune it?
How can we define a table? How can we apply SEARCH ALL on it ?
What is a buffer in memory?
Mention some fields that are a part of sqlca.