what is static sql? what is dynamic sql? Give me details
- 3 Answers
- 6889 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
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the reason behind not using select * in embedded sql programs?
What is multi row fetch in db2?
What is the clustering index in the db2 database?
List down the types of triggers in the db2 database?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What's The Percentage Free Space ?
Define db2 and its databases?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is null indicator in db2?
Explain dclgen.
What is the difference between spufi and qmf?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Can you tell me how can you find out the # of rows updated after an update statement?
Explain various types of locks in db2?
