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

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

---

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

What is the significance of DB2 free space and what parameters control it?

1 Answers  

---

What is the physical storage length of time data type?

0 Answers  

---

Explain about rct.

0 Answers  

---

Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,

---

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

0 Answers  

---

What is copy pending status in db2?

0 Answers  

---

What is the difference between static and dynamic SQL?

1 Answers  

---

How do you insert a record with a nullable column?

2 Answers  

---