Answer Posted / ram prajapati

select * from SYSIBM.SYCOLUMNS where tbname='tablename';
run this querry... or
go to dclgen .... option m.11.2 in the ispf command prompt n
see the structure directly in any mentioned ps file

Is db2 free?

1142

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2268

---

How to find primary key of a table in db2?

1125

---

What does db2 blu stand for?

1219

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1152

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

1123

---

What is explain plan in db2?

1050

---

Can there be more than one cursor open for any program?

1225

---

What is difference between alias and synonym in db2?

1198

---

Which components manage deadlocks in db2?

1124

---

Describe major components of db2?

1146

---

Why cursor is used in db2?

1089

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1146

---

What is the maximum size of varchar data type in db2?

1177

---

What is db2 and what is the use of db2 optimizer?

1111

---