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
Is the primary key a clustered index?
What is a db2 package?
What is a system catalog table in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is ibm db2 connect?
What is isolation level in db2?
What is the use of value function?
List down the types of triggers in the db2 database?
What is cursor in dbms?
List some fields from sqlca?
When the like statement is used?
Define check constraint.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What types of tables are there in the db2 database?
What is db2?
