What is the difference between IN subselects and EXISTS
subselect?
Answer / s
IN subselect will return rows that match the values in the
IN list. EXISTS will return rows if the subselect return a
true value.
| Is This Answer Correct ? | 11 Yes | 2 No |
What are the four lockable units for DB2?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
How would the varchar column remarks defined?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
What is the result of open cursor statement?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What are simple, segmented and partitioned table spaces ?
What is buffer pool in the db2 database?
Is db2 a mainframe?
How can we define a table? How can we apply SEARCH ALL on it ?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?