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

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1120


What is a buffer in memory?

1075


What is the purpose of using commit?

1111


How will you return the number of records in table?

953


Is db2 relational database?

995


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1174


What is package in cobol db2?

1125


Discuss about db2 bind?

1108


What is db2? Explain.

1062


How do I import a csv file into db2?

1006


How can you find out the # of rows updated after an update statement?

1124


What is data manager?

1058


Explain about rct.

1095


Define buffer pool.

1065


Can we insert update delete in view?

980