Not getting the ans.

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

Question Posted / raj

Answer Posted / raj

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Mention the location where the output received from explain statement is stored.

1086

How to run db2 command in windows?

1158

Mention data types used in db2 ?

1124

What is the meaning concurrency in the db2 database?

1079

How do I add a column to a table in db2?

1067

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1039

How would you find out the total number of rows in a db2 table?

1017

Can one database have multiple instances?

1023

List some fields from sqlca?

1022

What is ibm db2 used for?

1025

How do I optimize a query in db2?

1056

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2808

How to execute stored procedures?

1080

Can there be more than one cursor open for any program?

1143

When the like statement is used?

1176