Interested to Buy Any Domain ? << Click Here >> for more details...
what is static sql? what is dynamic sql? Give me details
- 3 Answers
- 8168 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 |
How can you compare table column after update and before update?
What is lock escalation in db2?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
How to check sequence on a table in db2?
Why select is not preferred in embedded sql programs?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What is concurrency in db2?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
What is the physical storage length of time data type?
what's the best lock size that you could use when you create a tablespace?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
COBOL 
