Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to see the structure of db2 table??

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


Please Help Members By Posting Answers For Below Questions

What does db2 stand for?

957


What is the picture clause of null indicator variable?

1080


What is meant by dclgen?

1059


Describe major components of db2?

1039


How to access db2 tables in mainframe?

990


What is the difference between drop table and delete table?

1116


Can we update view in db2?

944


What is the max length of sqlca?

1156


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114


What is a db2 package?

985


Name the various locking levels available?

1034


How many databases can be created inside an instance in db2 ?

976


Mention the location where the output received from explain statement is stored.

1053


What is the physical storage length of the data types date, time, and timestamp?

1039


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

1032