The database location of the target table. Normally this is also the location of the Apply program. The table on the target server to which data is copied. A table created during the processing of an SQL statement to hold intermediate results. An exchange between a workstation and a program, two workstations, or two programs that accomplishes a particular action or result.
Examples are the entry of a customer's deposit and the updating of the customer's balance.
In DB2, an object in a database that is invoked indirectly by the database manager when a particular SQL statement is run. During the first step, the database manager subsystems are polled to ensure that they are ready to commit. If all subsystems respond positively, the database manager instructs them to commit. U UDT User-defined type. An isolation level that allows an application to access uncommitted changes of other transactions.