Answer / guest1

IBM developed the RDBMS that can be used in any platform.
Say in Mainframe, Windows, Unix. That why it is so call UDB.

Regarding the space I'm not sure.
Advantages:
1) Builtin security. (Like Grand&Revoke)
2) It provides logical & Physical data independency.
3) You need not open& close as what we are doing in files.
4) Sorts will be internally performed at DSN07DB.
5) Recovery will be easy(Using the utility)
6) you can also create View which are called virtual tables.
This also give greater security on your table.
The above mentioned are few advantages of db2.

Answer / kumar

The first answer talks about the codes rule.
When you look at the error message/SQL status, which
carries same information accross mainframe, windows UNIX.
this could be the reason. Suggestions please

Answer / ankit chourasia

because this database is so flexible that it can support any high level language. and also its access criteria is so vast and fast that it produces wonders ..............its a super computer i call

How can the duplicate values be eliminated from db2 select?

1 Answers  

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

What is a DB2 access path?

1 Answers  

---

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  

---

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

What is the use of value function?

1 Answers  

---

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---

What is runstats db2?

1 Answers  

---

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers  

---

List out the buffer pools in db2

1 Answers  

---