Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to update a primary key value? If not, what
is the error code given? If yes, can more than 1 primary
key column be updated at a time?
- 8 Answers
- 26835 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
also remember, you cannot update a primary key when it has
matching foreign key values.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
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?
Explain package in db2 and its advantages?
How to rename a table in DB2 ?
What is db2 instance?
How would you find out the total number of rows in a db2 table?
What are the prerogatives?
What is page size in db2?
How to check table size in db2 sap?
How to restart a DB2 program?
What is database manager in db2?
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 .....
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?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the physical storage length of date data type?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
