How many databases can be created inside an instance in db2 ?

0 Answers   MCN Solutions,

---

How can you get the number of rows impacted by the last executed query?

1 Answers  

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

Can a Db2 table data be retrived through JCL?

4 Answers  

---

what are stage one indexable predicates?

1 Answers  

---

How do I delete a table in db2?

0 Answers  

---

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

---

What is a DB2 plan?

8 Answers  

---

Update command

1 Answers  

---

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  

---

Is db2 a mainframe database?

0 Answers  

---

What is the purpose of rollback and commit?

0 Answers  

---