How to fetch the last row from the table in SQL (db2)?
No Answer is Posted For this Question
Be the First to Post Answer
What is the function of logging in the db2 database?
Why use RUNSTAT Utility?
what's the best lock size that you could use when you create a tablespace?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
what is the Foreign key? explain?
What can the SET option of the Repair Utility accomplish?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
wht steps we need will coding cobol and db2 pgm ?
What is ibm db2 client?
What is difference between *omit and *nopass?
What is a clustering index ?
What is copy book?