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

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

0 Answers  

---

Give a brief description of db2 isolation levels?

0 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

what is the use of bind parameter, Replace?

5 Answers   IBM,

---

what is a corelated subquerry?

0 Answers   IBM,

---

What is ibm db2 database?

0 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

0 Answers   HeadStrong,

---

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

What is db2 look?

0 Answers  

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

---