in my project..TEST is db2 8.1 version In PROD it is 7.1
if i do REORG in TEST.. can I use the same REORG jcl with
out modification in PROD region (this is DB2 8.1 )? if
not, what modification i need to do in my REORG control
card?
what is the difference between where clause and having clause
How to check sequence on a table in db2?
Where is the access path logic created by the DB2 Optimizer stored?
is it possible to get -811 error when you use cursors. why?
Describe the elements of the SELECT query syntax?
why we create view.
What happens to the PLAN if index used by it is dropped?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
How can we define a table? How can we apply SEARCH ALL on it ?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
how to u check the query is executing or not ?where will u check for sqlcode ?
What is page size in db2?