Answer / vamsikrishnamraju

An outer join operation returns all the rows returned by an
inner join plus all the rows from one table that do not
match any row from the other table. An outer join can be
left, right, or full, depending on whether rows from the
left, right, or both tables are retained

What's The Error Code For Unique Index Voilation?

1 Answers   IBM,

---

Name the various locking levels available?

1 Answers  

---

in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,

---

What are the benefits of using the db2 database?

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 SQL statements/queries be included in a copybook?

2 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  

---

How to test SQL -911 error while developing COB-DB2 program

2 Answers   Satyam,

---

what is check point and restart Logic ? why do we go for that ??

2 Answers   CGI, UST, Xansa,

---

What is index cardinality?

3 Answers  

---

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  

---

What is rct?

1 Answers  

---