what is static sql? what is dynamic sql? Give me details
Answers were Sorted based on User's Feedback
Answer / sathishkumar s
Static SQL is SQL statements in an application that do not
change at runtime and, therefore, can be hard-coded into
the application.
Dynamic SQL is SQL statements that are constructed at
runtime; for example, the application may allow users to
enter their own queries. Thus, the SQL statements cannot be
hard-coded into the application.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / yuvaevergreen
>>static sql is hard coded in the cobol program. The static
sql is syntax checked,separately processed and executable
format of the sql is made ready by the precompiler even the
before the cobol program is compiled.
>>dynamic sql,though precompiled like static sql but they
are prepared and executed at run time. sql is of string
format and executed by SQL PREPARE or EXECUTE IMMEDIATE
statement.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ankitha
static and dynamic sql are the sql statements which are
coded in pgms . in static the execution of sql is known
means which sql statement should execute after any sql
statements but in dynaamic the execution of any sql
statements will happens in run time .it is like chioce
Is This Answer Correct ? | 2 Yes | 1 No |
What is the meaning of -805 SQL return code?
is it compulsory commitment control in journal?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
What is collection in db2 bind?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
what is the role of the cursor in db2?
How to check table size in db2 sap?
What is a Cartesian product?
When reorg is used?
What is reorg and runstats in db2?
What is db2?
What is runstats utility in db2?