Interested to Buy Any Domain ? << Click Here >> for more details...
what is static sql? what is dynamic sql? Give me details
- 3 Answers
- 8032 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 |
Q4. How will you get the count of record without using COUNT verb in query?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What is meant by a unit of recovery?
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 insert more than one record using insert?
what is a corelated subquerry?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is load replace in db2?
What will happen, while trying to close the closed cursor.
What is a db2 schema?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
COBOL 
