Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between static and dynamic SQL?
- 1 Answers
- 25808 Views
- I also Faced
- E-Mail Answers
Answer / jkb
In Stats SQL, the statement is prepared before the program
is executed and the operational form of the statement
persists beyond the execution of the program. A source
program containing static SQL statements must be processed
by an SQL precompiler before it is compiled. The
precompiler checks the syntax of the SQL statements, turns
them into host language comments, and generates host
language statements to invoke DB2.
A dynamic SQL statement is prepared during the execution of
an SQL application, and the operational form of the
statement is not persistent. The source form of the
statement is a character string passed to DB2 by an
application program using the static SQL statement PREPARE
or EXECUTE IMMEDIATE.
| Is This Answer Correct ? | 52 Yes | 9 No |
What are the contents of dclgen?
Normalization in DB2 – first normal form, second normal form
What are the various isolation levels possible?
What are host variables in db2?
In terms of DB2 indexing, what is the root page?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What r the comman abends in db2, jcl and cobol???????
Mention the location where the output received from explain statement is stored.
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
COBOL 
