Interested to Buy Any Domain ? << Click Here >> for more details...
what is static sql? what is dynamic sql? Give me details
- 3 Answers
- 8021 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 iseries database?
What is catalog database in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Define sqlca.
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is ibm db2 used for?
What is bufferpool in db2?
What is the physical storage length of date data type?
What is dbrm? What it contains?
What is database alias db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is dbrm? When it will be created?
can we view the access paths created by dbrm ? how ? thx
is it compulsory commitment control in journal?
What are packages in db2?
