What is a predicate?
Answer / s
predicate is a search condition coded in the SQL statement
to filter rows.
| Is This Answer Correct ? | 3 Yes | 1 No |
What do you do to keep the cursor from closing after a commit?
Once you create a view, where would information about the view be stored?
What is RUNSTATS?
How do I connect my db2 database to ibm?
What is page size in db2?
What is runstats db2?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
Request to database but database is not available so what is was abend is raised?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is commit in db2?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
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?