These are attributes of one table that have matching values in a primary key in another table, allowing for relationships between tables.
Latest Answer : Foreign Keys are keys used in a table as an attribute and are primary keys of some other table ...
SPUFI stands for SQL processing using file input. It is the DB2 interactive menu-driven tool used by developers to create database objects.
Latest Answer : SPUFI : SQL Processing Using File Input, it supports the on-line execution of SQL statements from a TSO terminal ...
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
No. The table and its view are created anew, but the programs accessing the view do not need to be changed if the view and attributes accessed remain the same.
The three types are shared, update and exclusive. Shared locks allow two or more programs to read simultaneously but not change the locked space. An exclusive lock bars all other users from accessing
Latest Answer : 3 types of locks are SHARE EXCLUSIVE UPDATE ...
If there is an index on the attributes tested an IN is more efficient since DB2 uses the index for the IN. (IN for index is the mnemonic).
Latest Answer : hi vipin sharma,IN subselects can also uesd in corelated sub queries.IN subselects needs to specify the vlues u want to search.EXISTS subselects doesn't need any to specify values . it searches ...
. It is a write to disk that may occur before or long after a commit. The write is controlled by the buffer manager.
This is a key concept for any relational database. Isolation level is the manner in which locks are applied and released during a transaction. For DB@ a 'repeatable read' holds all locks untile
Latest Answer : Isolation level means the extent to which the transaction isolates the data is accessed ...
Latest Answer : File opening modes areInput mode , output mode, extend mode, inputoutput mode. corresponding disposition codes in JCL.Inputmode-------- "Read" the file SHR (DISP)outputmode--------"write" the ...
Latest Answer : Record will be appeand in the file. ...
Latest Answer : How does you get record no from 5 to 15 from a dataset of 100 records? ...