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

What is the role of data manager in the db2 database?

1061

---

Which isolation level provides highest data integrity?

1052

---

What is sqlca?

1007

---

How to check table size in db2 sap?

985

---

What is a storage group (stogroup)?

1199

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4229

---

What are the contents of dclgen?

1065

---

How many databases are there?

1010

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8158

---

What is isolation level in db2?

951

---

Mention the various locks that are available in db2.

983

---

How to fetch the last row from the table in SQL (db2)?

1602

---

How is a typical db2 batch pgm executed?

1122

---

What is a Foreign Key?

1047

---

Is the primary key a clustered index?

1087

---