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
Mention the different locking levels that are available in db2.
What is the use of db2?
What is cursor in dbms?
What is database reorganization?
What is the connection string to connect to the DB2 Database ?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is consistency token in db2?
What is the purpose of using commit?
How will you return the number of records in table?
What is an instance in db2?
What is a system catalog table in db2?
What is table space in db2?
What's The Error Code For Unique Index Voilation?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the physical storage length of date data type?
