Which is faster delete or truncate?
No Answer is Posted For this Question
Be the First to Post Answer
What is package versioning? Please give an example.
How will fetch last 5 rows from table in db2
Explain in detail about buffer manager and its functionalities?
What is DCLGEN?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
How do we specify index to include or not during bind process.
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
what is difference between Plan and Package
What is bufferpool in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
how to fetch multiple records without using cursor