Explain the use of the WHERE clause?
- 1 Answers
- 3211 Views
- I also Faced
- E-Mail Answers
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 |
what is REORG? what is the use?
What is a storage group (stogroup)?
In terms of DB2 indexing, what is the root page?
Why cursor is used in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is runstats db2?
Can you access the DB2 Directory table using SQL?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the error code -803 ?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
What is release/acquire in bind?
What is dbrm?
COBOL 
