Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sabahat khan
Main Coloumn name present in Sysibm.Syscopy are
1)DBNAME 2)TSNAME 3)DSNUM 4)ICTYPE 5)ICDATE
6)Start_Rba 7)DSNAME 8)TIMESTAMP 9)AUTHID
to select any of the above mention column run
select * from sysibm.syscopy where DBNAME=' '
or
select * from sysibm.syscopy where TSNAME=' '
ETC
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a db2 tablespace?
How does db2 sample database connect?
How to fetch the last row from the table in SQL (db2)?
How can record locking be achieved in those DB2 versions which do not support it?
What are union and union all?
Can we insert update delete in view?
What is db2 plan table?
How do I add a column to an existing table in db2?
What is an instance database?
What is cursor with hold option in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is bind plan?
Is the primary key a clustered index?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is meant by explain?
