Answer / kc

SELECT colName,TypeName FROM SYSCAT.COLUMNS WHERE TABSCHEMA = <database> AND TABNAME =<tablename>

Answer / s

Select the catalog table SYSIBM.SYCOLUMNS for a particular
table.

Answer / prem

Use the Describe command

eg: Describe table <tablename>

Answer / 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

how to fetch first 100 rows in db2

2 Answers   IBM,

---

how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

How many buffer pools are available in db2?

2 Answers  

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

---

What is db2 instance?

0 Answers  

---

What are the benefits of using the db2 database?

0 Answers  

---

How to define the a field which accepts value till 99999.99 in db2

3 Answers  

---

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,

---

What is auditing?

2 Answers  

---

What os does db2 run on?

0 Answers  

---

What is PRIME TABLE and what are the uses of it

1 Answers  

---