File not opened because library is *PROD and debug is
UPDPROD(*NO). ? what may be the reason? how to solve it..?
No Answer is Posted For this Question
Be the First to Post Answer
When do you specify the isolation level?
What is an alias and how does it differ from a synonym?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the use of dclgen in db2?
What are the levels of isolation available with DB2V4
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?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
Give some example of statistics collected during RUNSTATS?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
How to access db2 tables in mainframe?