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 sqlcabc has?

1045


How to check sequence on a table in db2?

1053


What is dclgen (declaration generator)?

1052


What is the picture clause of null indicator variable?

1132


How do I connect my db2 database to ibm?

1042


What is db2 catalog database?

1034


What is load replace in db2?

992


How can you count the number of rows from a table tab?

1086


How will you return the number of records in table?

930


What is the connection string to connect to the DB2 Database ?

1118


What is the use of commit in db2?

1070


What is the difference between cursor stability and repeatable read isolation levels?

1168


What is collection in db2 bind?

1005


How do I copy a table in db2?

994


How to connect to db2 database from windows command line?

1059