Answer Posted / sesha

SELECT * FROM TABLE
FETCH FIRST 100 ROWS
ONLY

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

---

How to check table size in db2 sap?

1096

---

What is a page in db2?

1074

---

Explain in brief how does db2 determine what lock-size to use?

1092

---

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

757

---

Name the various locking levels available?

1133

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2118

---

What is a db2 collection?

1107

---

How to retrieve rows from a db2 table in embedded sql?

1444

---

What is clone table?

1114

---

How can you find out the # of rows updated after an update statement?

1154

---

What happens in bind step in a db2 program?

1012

---

What is node in db2?

1104

---

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

1082

---

Is it possible using max on a char column?

1192

---