Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do the EXPLAIN of a dynamic SQL statement?
- 2 Answers
- 6294 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha dasari
we could replace the unknown values with a "?"
eg:
select name
from database
where name = ?
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / mehdee
- When we issue an EXPLAIN as of the BIND like EXPLAIN
(YES), then results to analyze the path will go into 3 DB2
tables: PLAN_TABLE, DSN_STATEMENT_TABLE &
DSN_FUNCTION_TABLE. And you can do:
- select * from fhtdev.plan_table; And columns are
defined in DB2 Developers Guide EXPLAIN.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the reason behind not using select * in embedded sql programs?
How to execute stored procedures?
What do you need to do before you do EXPLAIN?
What does CURRENTDATA option in bind indicate
what is + sign and -ve sign for sql code ?
what is diffrence b/w file-aid tool and file-aid utility???
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
How to get the ddl of a table in db2?
how to unload different table data into different gdg files/ vsam files.
How do I start db2 in windows?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What kind of database is db2?
COBOL 
