What is the reason behind not using select * in embedded sql programs?
No Answer is Posted For this Question
Be the First to Post Answer
What does sqlcabc has?
Mention some fields that are a part of sqlca.
Explain what a plan is?
What are some characteristics of columns that benefit from indexes?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
What type of database is db2?
What is the physical storage length of the data types date, time, and timestamp?
I use CS and update a page. Will the lock be released after I am done with that page?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What is the purpose of using commit?
What is load replace in db2?