What are the contents of dclgen?
Can there be more than one cursor open for any program?
What are foreign keys in db2?
how to fetch multiple records without using cursor
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
What is the significance of DB2 free space and what parameters control it?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
what is the difference between where clause and having clause
Are view updateable?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?