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 |
What is the difference between SYNONYM and ALIAS?
How and when does the db2 enforces the unique key?
Explain dclgen.
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
Who uses db2?
What is a page?
What is a Cartesian product?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Write a query to retrive partial string.
Where can you declare a cursor in a cobol-db2 program?
What will happen, while trying to close the closed cursor.
How to resolve -504 sql code in DB2?