Interested to Buy Any Domain ? << Click Here >> for more details...
what is static sql? what is dynamic sql? Give me details
- 3 Answers
- 8163 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of reorg in db2?
What is deadlock in db2?
what is the responsibility of the construction superintendent
What is ibm db2 client?
Define buffer pool.
What is dclgen (declaration generator)?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Why select is not preferred in embedded sql programs?
How to get the ddl of a table in db2?
What parameters are used to control the free space in DB2?
What is a collection in db2?
What is buffer pool and list some of them?
How do we specify index to include or not during bind process.
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What does reorg do in db2?
