How do you simulate the EXPLAIN of an embedded SQL
statement in SPUFI/QMF? Give an example with a host
variable in WHERE clause)

Answer Posted / raj

Not getting the ans.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we delete records from view?

577


Describe major components of db2?

653


What are packages in db2?

610


How can you classify the locks in db2?

650


List down the data types in the db2 database.

646






What is declare cursor?

628


What is check constraint. Explain with example.

656


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7573


How do I copy a table in db2?

585


How to rename a table in DB2 ?

649


What is iseries database?

605


Explain the contention situations caused by locks?

607


How does db2 sample database connect?

583


What is temporal table in db2?

615


What is the purpose of using commit?

633