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 do we specify index to include or not during bind process.

0 Answers   Satyam,

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

How do you filter out the rows retrieved from a Db2 table ?

1 Answers  

---

What is the use of predicate?

0 Answers  

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  

---

How to execute stored procedures?

0 Answers  

---

What is image copy?

1 Answers   Virtusa,

---

how do you resolve -805?

3 Answers   HCL,

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

---

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,

---

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---

why we create view.

5 Answers  

---