in GDG: is it poosible to copy records from a file which
utilizes some 100 cylinders to a gdg whose model is defined
as trk(1,0) and also it possible to copy 100 bytes file to
80 bytes file?
what is dynamic cursor?gives syntax for this?
Is db2 a database?
how to resolve -811 sqlcode .give clear explaination
How can record locking be achieved in those DB2 versions which do not support it?
What is CHECK PENDING ?
My SQL is not performing well. Describe how will you fine tune it?
Explain the EXPLAIN statement?
How can the duplicate values be eliminated from db2 select?
What is tablespace?
Is Cursor exicutable ?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
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.