How can record locking be achieved in those DB2 versions which do not support it?
No Answer is Posted For this Question
Be the First to Post Answer
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.
What is with ur in db2?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What are the rules for db2 programming?
What is a Resource Control Table(RCT)? Describe its characteristics.
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
How do you define a correlated name?
what are the max. & min. no. of partitions allowed in a partition tablespace?
What is the maximum No of rows per page?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Which catalog table stores referential constraints?
My sql statement select avg(salary) from emp yields inaccurate results. Why?