Zona del pecho de Tolva o Retiro de pared frontal de la Tolva

The extended mode compiler version of FORTRAN.

UDS

See Universal Data System.

UDS Control

See Universal Data System Control.

uncorrelated query

An outer query whose subquery or subqueries contain no outer references. Contrast with correlated query.

UNION operator

A logical set operator used in RDMS to derive one table from two other tables. The result of a UNION operation is a set of all selected rows from both tables not including

duplicates. The result of a UNION ALL operation is a set of all selected rows from both tables including duplicates.

unique constraint See constraint.

Unisys Repository Manager (UREP)

The Unisys data management software that provides data dictionary functions by keeping track of information resources. It also is the tool for creating and maintaining data objects in a repository and reporting on them.

Universal Data System (UDS)

The Unisys expandable, modular suite of software products for data management, data processing, and database application development. Together with other data

management software products and components, UDS provides an integrated environment for control, maintenance, and recovery of user databases.

Universal Data System Control (UDS Control)

The UDS online data and file manager that directs and coordinates the operations of UDS products.

unowned schema

A schema created through UREP. Contrastwith owned schema. See also owner.

updatable view

A relational view that can be used to alter the contents of the underlying tables. Such a view must meet certain conditions to be updatable.

update lock

A user- or system-specified lock on a file or page intended to allow only the changing of data in the file or page and coinstantaneously restrict other threads from accessing the affected data.

UPDATE privilege

A privilege that owners of RDMS tables grant to other users to enable them to change information. See also data access control.

UREP

See Unisys Repository Manager.

V

value

A numeric, alphabetic, or alphanumeric character string stored for an entity (such as an attribute) at the address allocated for that entity. See also data value.

value expression

A subcomponent of a predicate that results in either a single numeric value or a character string value. A value expression in its simplest form can be a literal, a column, or a program variable. In a more complex form, it can be an arithmetic expression or an aggregate function.

variable

A symbolic name used to identify a single storage sequence. Its name remains fixed during the execution of a program; its value can change during execution. Contrastwith

constant.

VDT

See view definition table.

version

Another copy of a table, which can contain different data. Many different versions of a table can exist. Each version of the table is associated with the same storage area name but has a different version name attached to it within that storage area definition. All

view

Synonymfor relational view.

view definition

See relational view definition.

view definition table (VDT)

The encoded, machine-readable form of a view definition.

view owner

See owner.

W

work

The SQL name for a thread.

X

XPC

See Extended Processing Complex.

XRLOAD

The Unisys stand-alone utility processor that implements fast initial offline loading of large amounts of data into an RDMS database. XRLOAD does not access UDS Control or RDMS.

XTC

A

aggregate operations, 7-4 aliases in table lists, using, 5-4 ALTER TABLE statement, effect on

views, 7-5 application group, 4-1 attribute (See columns)

authorization-id, as owner of view, 7-1 AVG function, 7-4

B

backslash escape character, 11-4 BEGIN THREAD statement

examples, 4-3

starting a session, 4-2

BEGIN THREAD statement examples, 10-5 Boolean expressions, 5-4

built-in functions, 7-4

C

CALL statement, 11-7

canceling changes to database, 4-4 CAT command, ECL, A-1

clauses ACCESS CONTROL, 7-1 FOR, 4-2 FROM, 5-1 GROUP BY, 5-2 HAVING, 5-2 IN, 8-3 ORDER BY, 7-1 RETRIEVE INTO, 6-3 VALUES, 6-2 WHERE, 5-2 columns introduction to, 3-1

names, listing for views, 7-3 specifying (select list), 5-2

COMMANDLOOKS recovery option, 10-6 COMMANDSLOOKS recovery option, 4-3 COMMIT statement (example), 4-4, 10-10 conceptual table, 5-7

Condition command, IPF, 10-9 configuration attributes

RDMS-DEFAULT-QUALIFIER, 7-2 RDMS-SERIALIZABLE, 8-2 Copy command, IPF, 10-9 correlation name, 5-4 COUNT function, 7-4

CREATE SCHEMA statement

authorization-id as owner of view, 7-1 schema name as default qualifier, A-2 view name, 7-2

CREATE VIEW statement access privileges, 7-1 examples, 7-2, 7-3 query specifications, 7-4 use, 7-1

cross-product tables, 5-9

cursor operations, support of, 11-1 cursors

closing, 5-15 declaring, 5-13 opening, 5-14 using, 5-13

with IPF SQL Interface, 11-1 CUSTOMERS table, 3-2

D

data

accessing efficiently, 8-2 deleting, 2-2

data item, 3-3

data manager, specifying (example), 10-4 data value, 3-3 database changes canceling, 4-4 database management, 2-1 databases

canceling changes to, 4-4 cancelling changes to, 10-10 changes canceling, 10-10 discarding, 10-10 saving, 10-10 closing, 10-11 opening, 10-5 querying, 5-1

retrieving information from, 5-1

support of by UDS Control and UREP, 2-1 DECLARE CURSOR statement

examples, 5-13 introduction to, 5-1

IPF SQL Interface support of, 11-1 SQL (example), 11-2

DEFERRED recovery option, 4-3, 10-6 DELETE statement

description of, 6-1 examples, 6-1

views, rules for updating with, 7-5 deleting data, 2-2

Describe command, IPF, 10-9 discarding changes to database, 4-4 DISTINCT keyword, 5-3, 7-4

DROP CURSOR statement (example), 11-2 DROP VIEW statement, 7-7

dynamic ESQL, 9-1

E

embedded SQL (See ESQL) END THREAD statement

ending a session, 4-5 example, 4-5, 10-11

module language, 9-2 static, 9-1

EXCLUSIVE lock mode, 8-3 Execute command, IPF, 10-9 exiting IPF, 10-11

F

FETCH statement, format/example, 11-3 FILE command, 10-12 FOR clause, 4-2 FROM clause introduction to, 5-1 specifying tables, 5-4 full-screen mode, SQL, 10-15

G

GRANT statement, A-2 GROUP BY clause

as aggregate operation, 7-4 introduction to, 5-2

retrieving information on rows, 5-7 grouped table, 5-7

H

HAVING clause as aggregate operation, 7-4 introduction to, 5-2 restricting groups, 5-8 help, online, 10-6 HOUSES table, 3-2

I

indicator variables, using with SQL, 11-7 INSERT statement

Inventory command, IPF, 10-9 IPF commands/entries

"Call", 10-9

committing changes to database, 10-9 Condition, 10-9 Copy, 10-9 Describe, 10-9 Execute, 10-9 Inventory, 10-9 Library, 10-9 LOGOFF, 10-11 MODE SCREEN, 10-15 OLD, 10-14 OUT, 10-14 Pack, 10-9 Position, 10-9 Run, 10-9 XQT, 10-9 IPF processor calling, 10-3 exiting, 10-11

IPF screen mode, compared with SQL full-screen mode, 10-15

IPF SQL Interface session, managing, 10-3 IPF variables, using with SQL, 11-4, 11-5

J

joining tables, 5-9

joining tables (example), 5-9

L

Library command, IPF, 10-9 LOCK statement

examples, 8-3 introduction to, 8-2 locks

conflict options, 8-3

errors with UNLOCK statement, avoiding, 8-3 implicit, 8-2 introduction to, 8-1 modes, 8-3 releasing, 4-4

M

MAX function, 7-4 MIN function, 7-4

MODE SCREEN entry, 10-15

N

NONE recovery option, 10-6

O

OLD command, IPF, 10-14 online help, 10-6

OPEN statement, A-2

OPEN statement (example), 5-14

Oracle Transparent Gateway reference, 9-2 OUT command, IPF, 10-14

P

Pack command, IPF, 10-9 Position command, IPF, 10-9 PROTECTED lock mode, 8-3

Q

qualifiers

default, 7-2, A-2 using (example), A-2

QUERY lock conflict option, 8-3 query results, handling/saving, 10-14 query specifications

aliases for tables, 5-4 clauses available, 5-1

CREATE VIEW statement, 7-4 joining tables (example), 5-9 QUEUE lock conflict option, 8-3

QUICKLOOKS recovery option, 4-3, 10-6

options, 4-3

options, specifying from IPF, 10-6 QUICKLOOKS option, 4-3, 10-6 relation (See tables)

relational data model, 3-1 relational database

end user tasks, 2-2 SQL-based manager, 2-1 relational tables (See tables) RETRIEVAL lock mode usage, 8-3

RETRIEVE INTO clause, use with UPDATE statement, 6-3

retrieving data, 2-2

RETURN lock conflict option, 8-3 REVOKE statement, A-2

ROLLBACK statement

canceling changes to database, 4-4 example, 4-4, 10-10 rows deleting, 6-1 in cross-product table, 5-9 inserting, 6-2 introduction to, 3-1

joining tables, effect on by WHERE clause, 5-9

multiple, specifying and retrieving, 5-13 retrieving information on groups of, 5-7 selecting, 5-6

updating, 6-3

Run command, IPF, 10-10

S

select list, specifying columns, 5-2

SELECT statement, 5-1, 5-2, 5-3, 5-4, 5-7, 5-8, 5-9

SET statement, 11-7 SHARED lock mode, 8-3

SQL (See Structured Query Language) SQL full-screen mode

$SQLSCREEN, setting for, 10-16 compared with IPF screen mode, 10-15 example, 10-17, 10-18, 10-19, 10-21 BEGIN THREAD, 4-2, 4-3 CLOSE, 5-13, 5-15 COMMIT, 4-4 CREATE SCHEMA, 7-1 CREATE VIEW, 7-1 DECLARE CURSOR, 5-1, 5-13 DELETE, 6-1 DROP CURSOR, 5-13 DROP VIEW, 7-7 END THREAD, 4-5 GRANT, A-2 INSERT, 6-2 introduction to, 2-3 lock, 4-4 LOCK, 8-2 OPEN, 5-14, A-2 REVOKE, A-2 ROLLBACK, 4-4 SELECT, 5-1, 5-2, 5-3, 5-4, 5-7, 5-8, 5-9 UNLOCK, 8-4 UPDATE, 6-3

USE DEFAULT QUALIFIER, 7-2, 9-2, A-2 USE DEFAULT VERSION, A-2

static ESQL, 9-1

status variables,contents, 11-5

stored procedures and functions, 10-12, 10-22

Structured Query Language (SQL) cursor operations, 11-1

description of, 2-3

full-screen mode, using, 10-15 WHERE clause versions, 6-3 subquery (example), 5-5, 5-6 SUM function, 7-4

T

tables

access privileges on CREATE VIEW statement, 7-1

aliases in query specifications, 5-4 ALTER TABLE statement effect on

HOUSES, 3-2 inserting rows in, 6-2 introduction to, 3-1

joining, effect of WHERE clause, 5-9 locking, 8-2

query specifications to, 7-3 querying, 5-1

specifying, 5-4 updating rows in, 6-3 virtual (or view), 3-3, 7-1 thread control operations, 4-1 threads

description of, 4-1 ending session, 4-5

opening (starting session), 4-2 tuple (See rows)

U

UDS Control, support by, 2-1 UNION operator (example), 5-14 UNLOCK statement, 8-4

UPDATE lock mode usage, 8-3 UPDATE statement

description of, 6-3

effect on by WHERE clause, 6-3 examples, 6-3

RETRIEVE INTO clause use, 6-3 views, rules for updating with, 7-4 updating data, 2-2

UREP, support by, 2-1

USE DEFAULT QUALIFIER statement, 9-2, A-3

USE DEFAULT VERSION statement, A-3

V

VALUES clause, 6-2 variables, using with SQL

indicator (example), 11-7 IPF, 11-4 procedures (example), 11-9 status, 11-5 versions default views

ALTER TABLE statement effect on, 7-4 description of, 7-4

dropping, 7-6 in table list, 5-4 introduction to, 3-3 locking through table, 8-2 naming, 7-1

query specifications to, 7-4 updating, 7-5

virtual table, 7-1

WITH CHECK OPTION clause, 7-5 virtual table, 7-1

W

WHERE clause introduction to, 5-2

joining tables, effect on rows, 5-9 selecting rows, 5-6

UPDATE statement, effect on, 6-3 WHERE CURRENT OF clause, 6-3 WITH CHECK OPTION clause

description of, 7-1 example, 7-6

X

XQT command, IPF, 10-9

In document Mantenimiento por soldadura de equipos de minería a tajo abierto (página 125-134)