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 can you get the number of rows impacted by the last executed query?

1 Answers  

---

Is db2 a programming language?

0 Answers  

---

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,

---

What does an outer join do?

1 Answers   CTS,

---

How does db2 sample database connect?

0 Answers  

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

What is innodb buffer pool?

0 Answers  

---

In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---

what is different three logs in DB2?

1 Answers   Syntel,

---

Define sqlca.

0 Answers  

---