Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between static and dynamic SQL?
- 1 Answers
- 25770 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 |
When Can you be sure that a query will return only one row?
What is rct?
What is database alias db2?
What is db2 bind?
How to execute stored procedures?
What is an alias?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
How to create db2 table in mainframe?
What is UNION,UNION ALL?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
what is diffrence b/w file-aid tool and file-aid utility???
COBOL 
