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
Explain the benefits you can get from mainframe connect?
How connect db2 database to datastage?
Differentiate between cs and rr isolation levels? Where do you specify them?
Mention data types used in db2 ?
What is the physical storage length of timestamp data type?
What is check constraint in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What are host variables in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Are views updateable?
What is commit in db2?
What are the two types of logging in the db2 database? Explain them.
What is the difference between spufi and qmf?
Is db2 a mainframe?
How to check table size in db2 sap?
