Answer Posted / ajay kumar ande

3 steps..........

1.)pre-compilation
2.)bind
3.)run

1.PRECOMPLATION
// jobcard job......
// act01 exec pgm=dsnhpc
// DBRMLIB DD DSN=

// act01 exec pgm=IGYCRCTL
// SYSLOAD DD DSN=&&TEMP,DISP=PASS

// act01 exec pgm=IEWL
// SYSLMOD DD DSN=&&TEMP,DISP=OLD

BIND
// act01 exec pgm=IKJEFT01
// DBRMLIB DD DSN=
SYSIN DD *
BIND PLAN( ) MEM( ) ISOLATION(CS) ACTION(REP)

RUN
// act01 exec pgm=IKJEFT01
SYSIN DD *
RUN PROG( ) PLAN( ) LOADLIB( )

Name the lockable units in DB2?

1131

---

What is the use of commit in db2?

1083

---

How can we retrieve the total number of records in RPG & CLLE?

656

---

How do you select a row using indexes in db2?

1138

---

What is db2 instance?

1110

---

What does db2 mean?

1021

---

What is the max length of sqlca?

1218

---

Explain about rct in db2?

1112

---

How to find primary key of a table in db2?

1066

---

What parameters are used to control the free space in DB2?

1059

---

What is the use of runstats in db2?

1112

---

What is the syntax for creating a table in the db2 database?

1109

---

what is a corelated subquerry?

1123

---

On which levels locks can be applied?

1136

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2219

---