Which is faster delete or truncate?
No Answer is Posted For this Question
Be the First to Post Answer
How and when does the db2 enforces the unique key?
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 pagespace?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
Can we declare DB2 HOST variable in COBOL COPY book?
What is difference between isnull and coalesce?
what is differnece between DROP TABLE & DELETE TABLE .
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the maximum length of sqlca?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
How to get the ddl of a table in db2?