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 ...
Describe the elements of the SELECT query syntax. SELECT element FROM table WHERE conditional statement?
Joins, unions and nested selects are used to retrieve data.
Latest Answer : The two tables has to be linked.EXEC SQL
SELECT A.EMP_ID, B.WAGE FROM Table1 A, Table2 B WHERE A.EMP_ID = B.EMP_ID
AND A.EMP_ID = ...
A view is a virtual table made up of data from base tables and other views, but not stored separately.
Latest Answer : View is a vitual table, which do not have physical storage.we can create a view from one or more than one table(s) or view(s).if any modification is done on the base table the view is also get effected.but they are some limitations while creating ...
I/O operations are usually most critical for DB2 performance (or any other database for that matter).
Latest Answer : I'm sorry, but the answer is a firm "It depends."Depending on various factors, most MVS boxes run short on either CPU or I/O. These factors include, workload, time of day, day of the week, etc. A capacity planner could give you a better list, but these ...
The database descriptor, DBD is the DB2 component that limits access to the database whenever objects are created, altered or dropped.
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 ...
A synonym is used to reference a table or view by another name. The other name can then be written in the application code pointing to test tables in the development stage and to production entities
Latest Answer : Also, a Synonym is specific to the DB2 subsystem. Synonym can only access the table or view in the subsystem in which it is defined. A synonym is dropped when the table is dropped.An Alias is yet another name for a table or view. But ...
An alias is an alternative to a synonym, designed for a distributed environment to avoid having to use the location qualifier of a table or view. The alias is not dropped when the table is dropped.
Latest Answer : An alias is a logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. In some cases, more than one alias may be necessary for a given table.Cheers,Sithu ...
A LIKE table is created by using the LIKE parameter in a CREATE table statement. LIKE tables are typically created for a test environment from the production environment.
