Answer / s

DB2 Precomplier comments out the SQL statments and replaces
with CALL statements to DB2. It places the consistency
token in both the DBRM and modified source program.

Answer / gouri

dsnhpc

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 Answers  

---

What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,

---

What are the advantages of using a PACKAGE?

2 Answers  

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 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  

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---

What is the function of logging in the db2 database?

0 Answers  

---

What do the initials DDL and DML stand for and what is their meaning?

2 Answers  

---

What are column-name qualifiers used?

1 Answers  

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

i want to delete 20th million record how ?

4 Answers   IBM,

---

What is QUIESCE?

2 Answers  

---