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
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is the physical storage length of date data type?
What is host variable?
What is drop table?
What is catalog database in db2?
What is a dbrm in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Is ibm db2 free?
What is isolation level in db2?
What is explain in db2?
What is the difference between nvl and coalesce?
What are types of indexes?
What is reorg and runstats in db2?
What is copy pending and check pending in db2?
What is difference between isnull and coalesce?
