What is dynamic SQL?
- 1 Answers
- 5814 Views
- ADP, I also Faced
- E-Mail Answers
Answer / s
Dynamic SQL are built at execution time. Dynamic SQL does
not go through the program preparation process like static
SQL and can execute different SQL statements in one
program.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is load replace in db2?
how can i pull up a query which was previously stored in qmf
When is the access path determined for dynamic SQL?
What is cursor with hold option in db2?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
What is scrollable cursor in db2?
What is sqlcode -922 ?
What is netezza database?
How to check sequence on a table in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
Why select is not preferred in embedded sql programs?
What are types of indexes?
COBOL 
