Answer Posted / s

YES 2 diffrent DB2 Subsystems under the same MVS image can
be running different versions.

What is the difference between nvl and coalesce?

1106

---

What are the contents of dclgen?

1160

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

1231

---

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 ?...

4372

---

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

1117

---

How to execute stored procedure in db2 command editor?

1098

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3263

---

What is dbrm?

1177

---

How does db2 sample database connect?

1080

---

When the like statement is used?

1280

---

Are view updateable?

1091

---

What is the maximum size of a char data type in db2?

1050

---

How can you do the explain of a dynamic sql statement?

1107

---

How can we read records for specific member in CL? AND rpg?

757

---

What is the connection string to connect to the DB2 Database ?

1172

---