Explain the use of the WHERE clause?
Answer / ms.stanley
WHERE is used to specify the SEARCH ARGUMENT Values in the
SQL Query to retrieve only selected Data from the DB2 Table
Is This Answer Correct ? | 1 Yes | 0 No |
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What is the function of buffer manager?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the information associated with sysibm.syslinks table?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Q3. How will you fetch duplicate values from a DB2 table?
Explain about rct.
What are the 2 sqlcodes that are returned?
What is iseries database?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
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?
What are the Isolation levels possible ?