Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

How is a typical DB2 batch program executed ?

1 Answers  

---

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers   Logica CMG,

---

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  

---

What is performance tuning db2?

0 Answers  

---

What are the various data types available in db2?

0 Answers  

---

COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  

---

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

---

What's The Percentage Free Space ?

0 Answers   IBM,

---

what are stage one indexable predicates?

1 Answers  

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---