How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
1 5937
Give a brief description of db2 isolation levels?
Give the name of some fields form sqlca.
How to test SQL -911 error while developing COB-DB2 program
How and when does the db2 enforces the unique key?
What are foreign keys in db2?
How does coalesce work?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is dbrm?
What is package in db2 mainframe?
How to find schema of a table in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is nvl in db2?
Define data page.
What is the default page size of buffer pools?