Answer Posted / ram

100 % correct. During pre-compile, DB2 doest not required
to be up. Because it wont refer any DB2 catalog tables....
its does a basic syntax checking by referring DB2
DECLGEN....

Is ibm db2 free?

953

---

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

3090

---

How will you return the number of records in table?

880

---

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

4214

---

What is dbrm? When it will be created?

957

---

What happens in bind step in a db2 program?

914

---

What is difference between rollback and commit?

1092

---

What is bind and rebind in db2?

1073

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1054

---

What do you mean by cursor?

942

---

How do I optimize a query in db2?

1038

---

List out the buffer pools in db2

1020

---

List out the data types available.

1081

---

What are union and union all?

920

---

Why db2 is called db2?

970

---