Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Primary key and
unique index?
- 6 Answers
- 10436 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest1
Using the Primary Key you can establish referential
integrity. Unix index will be created upon the Primary Key
column, and the data will be seperately placed in the Index
space. If you have not created Unix Index, while accessing
the table it leads to SQLCODE = -540
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a trigger in the db2 database?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
what is the role of the cursor in db2?
What is db2 connect?
Explain the function of data manager.
Who uses db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How to find primary key of a table in db2?
Define db2 and its databases?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
List out the data types available.
What is reorg and runstats in db2?
What is host variable?
Which component is responsible for processing sql statements and selecting access paths?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
