Answer / s

For User authorization, SYSIBM.SYSUSERAUTH

What's The Error Code For Unique Index Voilation?

0 Answers   IBM,

---

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  

---

List down the types of triggers in the db2 database?

0 Answers  

---

What is EXPLAIN?

1 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

What are the isolation levels possible ?

3 Answers  

---

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

---

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  

---

What is the difference between Primary key and unique index?

6 Answers  

---