How to see the structure of db2 table??

Answer Posted / prem

Use the Describe command

eg: Describe table <tablename>

Is This Answer Correct ?    38 Yes 47 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dpf in db2?

681


How to get the ddl of a table in db2?

689


What r the comman abends in db2, jcl and cobol???????

1832


What language is db2 written in?

608


What is package in db2 mainframe?

570






How do you concatenate the firstname and lastname from emp table to give a complete name?

615


What is check constraint in db2?

625


What do you mean by between and in? Is between inclusive of specified range values?

684


What is dclgen (declaration generator)?

617


What is declare cursor?

628


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

654


What is null value in db2?

583


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2400


List some fields from sqlca?

619


Explain about dbrm.

620