Interested to Buy Any Domain ? << Click Here >> for more details...
what is static sql? what is dynamic sql? Give me details
- 3 Answers
- 7989 Views
- I also Faced
- E-Mail Answers
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 dclgen in db2?
Where do you specify them?
What is dbrm? When it will be created?
On which levels locks can be applied?
What are some characteristics of columns that benefit from indexes?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is db2 and what is the use of db2 optimizer?
I use CS and update a page. Will the lock be released after I am done with that page?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
B37 abend during spufi?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
COBOL 
