Some of the advantages of Views are
☛ Views occupy no space
☛ Views are used to simply retrieve the results of complicated queries that need to be executed often.
☛ Views are used to restrict access to the database or to hide data complexity.
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables.
Can i insert bulk records into a db2 table using qmf of spufi only.
Can you search give an array in the WHERE clause of a db2 query?
could you give me an example how, where i code CHECKPOINT and restart. I need and example
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What is DCLGEN ?
Can GROUP BY and ORDERED BY used in a single query?
EXPLAIN has output with MATCHCOLS = 0. What does it mean? ?
When DB2 connection fails, will online program work or give errors?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
