Interested to Buy Any Domain ? << Click Here >> for more details...
what is static sql? what is dynamic sql? Give me details
- 3 Answers
- 8028 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 ibm db2 used for?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
what is plan? is plan executable or package?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
Why do we bind in db2?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What is reorg in DB2
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
What is iseries database?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
COBOL 
