What happens when more than one row satisfies a Select statement that is executed outside of any cursor processing?
Latest Answer: For getting middle of rows for employee table first you should SORT the order of rows in a table after that you can put it skip/count logic on that.Regards,Pradeep ...
How do you retrieve a sample of 'n' rows in random without any filterting (where) conditions?
Latest Answer: Search for the table name in the DB2 table SYSIBM.SYSINDEXESSELECT * FROM SYSIBM.SYSINDEXES WHERE NAME = 'tablename' OR CREATOR = 'creator name' ; ...
Latest Answer: This error related to db2 table access, please check you have access to all the table which are using in your program.I face this problem in my exp and i resolved this by communicating with on-site and DBA ...
Latest Answer: The main difference between Plan and package lies with the time. When a DBRM undergoes the bind process, the outcome in earlier days was called as a Plan and nowadays it can either be a Plan or a package. So, plan was what existed prior to DB2 V2R3 and ...
What is time stamp in compilation & execution of a COBOL program with SQL queries? what is bind process in it?
In DB2, table space is an LDS which does not support index concept. But index is an back bone of DB2. How DB2 supports index? Explain?
View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>
Go Top
