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 information associated with sysibm.syslinks table?

0 Answers  

---

What happens to the PLAN if index used by it is dropped?

1 Answers  

---

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  

---

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---

If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  

---

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

---

How do you pull up a query which was previously saved in qmf?

0 Answers  

---

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

---