Answer / jkb

In Stats SQL, the statement is prepared before the program
is executed and the operational form of the statement
persists beyond the execution of the program. A source
program containing static SQL statements must be processed
by an SQL precompiler before it is compiled. The
precompiler checks the syntax of the SQL statements, turns
them into host language comments, and generates host
language statements to invoke DB2.


A dynamic SQL statement is prepared during the execution of
an SQL application, and the operational form of the
statement is not persistent. The source form of the
statement is a character string passed to DB2 by an
application program using the static SQL statement PREPARE
or EXECUTE IMMEDIATE.

Mention the downsides of page level lock.

0 Answers  

---

What is Skeleton cursor table (SKCT)?

2 Answers  

---

what is the soft code for deadlock ?

2 Answers   Logica CMG,

---

How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,

---

Can you search give an array in the WHERE clause of a db2 query?

1 Answers  

---

Explain the function of data manager.

0 Answers  

---

When do you specify the isolation level?

0 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

Which command is used to remove all rows from a table?

0 Answers  

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,

---

What is the function of the Data Manager?

2 Answers  

---