What are delete-connected tables?
Answer / s
tables that are connected in a referential integrity
relationship. Delete of the primary keys deletes the
corresponding foreign keys.
| Is This Answer Correct ? | 2 Yes | 0 No |
Where is the output of EXPLAIN stored?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What is difference between alias and synonym in db2?
What does sqlcabc has?
How to resolve -803 sql code in DB2?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
What is db2 stogroup?
how can we find nth max salary from A table
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is database alias db2?
what is check point and restart Logic ? why do we go for that ??