Interested to Buy Any Domain ? << Click Here >> for more details...
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 is buffer pool in the db2 database?
What is the meaning concurrency in the db2 database?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What do you mean by cursor?
What are the two types of logging in the db2 database? Explain them.
What are bind parameters in db2?
Are view updateable?
What is multi row fetch in db2?
How to check sequence on a table in db2?
Mention the location where the output received from explain statement is stored.
How do I delete a table in database?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Can we insert update delete in view?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the use of dclgen in db2?
