Answer Posted / sriram

EXEC-SQL
SELECT 1
INTO :X
FROM TAB1
END-EXEC
X is defined as s9(4) comp value zeroes
So, if there is a row in the table (i.e. the table is not
empty), 1 gets moved to variable X.
Did not have resources to run the query and validate ,



Please let me know if I am wrong

Differentiate between cs and rr isolation levels? Where do you specify them?

1071

---

How to create db2 table in mainframe?

1154

---

What is db2 purescale?

1006

---

What is null in db2?

1026

---

What is netezza database?

1030

---

What is precompiler in db2?

1022

---

Define data page.

1072

---

What does runstats do in db2?

1120

---

Outputs of explain are with matchcols = 0. What does this signify?

1061

---

What is the maximum length of sqlca?

1529

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3157

---

can we view the access paths created by dbrm ? how ? thx

7100

---

What is difference between rollback and commit?

1164

---

Explain about cursor stability?

1052

---

How to find schema of a table in db2?

1016

---