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.

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.

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

What information is used as input to the bind process?

2 Answers  

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

---

How does DB2 store NULL physically?

2 Answers  

---

What is the reason behind not using select * in embedded sql programs?

0 Answers  

---

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

---

can we drop column from a table

7 Answers   INDUS,

---

What does DSNDB07 database do?

2 Answers  

---

how to unload different table data into different gdg files/ vsam files.

3 Answers  

---

What is a data page?

1 Answers  

---

How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,

---

What do you do to keep the cursor from closing after a commit?

1 Answers  

---

What is the syntax for creating a table in the db2 database?

0 Answers  

---