Interested to Buy Any Domain ? << Click Here >> for more details...
How to know the primary key of a table without defining the
primary key in the table?
- 5 Answers
- 15336 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / ambika
u can use sysibm.syskeys to view the primary key of a
particular table provided if u have declared any attribute
as NOT NULL. if there are multiple columns of such kind u
the above procedure wont help.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is bufferpool in db2?
What is difference between alias and synonym in db2?
What are bind parameters in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is the usage of open cursor command?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Define declaration generator (dclgen).
How to fetch the last row from the table in SQL (db2)?
What are the benefits of using the db2 database?
What is access path in db2?
What is copy pending status in db2?
What is difference between isnull and coalesce?
Is db2 a database?
