Answer Posted / 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
| Is This Answer Correct ? | 11 Yes | 20 No |
Post New Answer View All Answers
What does db2 stand for?
What is the picture clause of null indicator variable?
What is meant by dclgen?
Describe major components of db2?
How to access db2 tables in mainframe?
What is the difference between drop table and delete table?
Can we update view in db2?
What is the max length of sqlca?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is a db2 package?
Name the various locking levels available?
How many databases can be created inside an instance in db2 ?
Mention the location where the output received from explain statement is stored.
What is the physical storage length of the data types date, time, and timestamp?
My sql statement select avg(salary) from emp yields inaccurate results. Why?