What is node in db2?
Do we need cursor for Count(*)?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is index cardinality?
What is the significance of DB2 free space and what parameters control it?
What keyword does an SQL SELECT statement use for a string search?
wht happens if we close cursor with cursor with hold option?
Can you search give an array in the WHERE clause of a db2 query?
What is a data page?
what is copy pending and check pending ?
What is the SQL Communications Area and what are some of its key fields?
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?
How to create backup table in db2?