Which catalog table stores referential constraints?
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?
What is collection in db2 bind?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
what are bind concepts in db2 cobol?
Write a query to retrive partial string.
Why might full image copies be faster to implement than an incremental image copy?
When is the results table for the query in a DECLARE CURSOR statement created?
How to fetch the uncommited data from table ?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
Which command is used to connect to a database in DB2 ? Give the Syntax.
what is + sign and -ve sign for sql code ?