DB2 Server for VSE & VM: Database Services Utility

Index

A B C D E F G H I J K L M N O P Q R S T U V W Z
A
  • ACTIVITY sample table (1976)
  • API (see Application Programming Interface) (1576), (1579)
  • apostrophe
  • parameter value (1621)
  • Application Programming Interface (API)
  • calling program to DBSU (1577)
  • control parameters (1580)
  • Application server
  • identifying (1325)
  • switching (1326)
  • ARIDDFP (1565)
  • ARIDSQLA (1564)
  • ARIS71PL (1515)
  • ARISYSDD (1563)
  • arithmetic
  • exception (1654), (1748)
  • arithmetic operator
  • in syntax diagrams (1277)
  • assembler calling program
  • example (1599)
  • assembler load program
  • example (1598)
  • authorization, checking (1322), (1323)
  • AUTOCOMMIT
  • DATALOAD COMMITCOUNT processing (1731)
  • automatic
  • locking override (1928)
    • B
  • bad records skipping (1395)
  • basic DBCS support (1957)
  • binary-output data (1767)
  • blanks
  • within identifiers (1547)
  • building
  • control file (1304)
  • building an input control card file (1301)
    • C
  • C programming language
  • invoking the Database Services Utility (1570)
  • CALL assembler macro (1569)
  • CDLOAD instruction (1566)
  • CHAR data type (1675)
  • character subtype (1430), (1449)
  • choose
  • in syntax diagrams (1280)
  • CL_SCHED sample table (1984)
  • clustering index (1426)
  • COBOL, invoking the Database Services Utility (1573)
  • COBOL program example (1597)
  • column
  • label (1335)
  • UNIQUE attribute (1428)
  • combining records to load multiple rows (1380)
  • command
  • processing
  • description (1612)
  • SQL (1648)
  • summary (1656)
  • specifications (1610)
  • command file
  • errors (1900)
  • command reference topics
  • blanks within identifiers (1545)
  • COMMENT reference (1627)
  • data object (1528)
  • Database Services Utility reserved words (1555)
  • DATALOAD TABLE reference (1662)
  • DATAUNLOAD reference (1742)
  • load-data commands (1660)
  • load-program command processing (1834)
  • loading data (1659)
  • loading programs (1830)
  • names and identifiers (1525)
  • naming data objects (1527)
  • object name (1536)
  • processing (1611)
  • program-load commands (1831)
  • qualifying object names (1535)
  • REBIND PACKAGE reference (1844)
  • RELOAD DBSPACE reference (1801)
  • RELOAD PACKAGE reference (1836)
  • RELOAD TABLE reference (1812)
  • REORGANIZE reference (1634)
  • reserved words (1550)
  • reserved words as identifiers (1559)
  • SCHEMA reference (1641)
  • SET AUTOCOMMIT reference (1849)
  • SET ERRORMODE reference (1852)
  • SET FORMAT reference (1855)
  • SET ISOLATION reference (1860)
  • set-item commands (1848)
  • SET LINECOUNT, SET LINEWIDTH reference (1874)
  • SET UPDATE STATISTICS reference (1882)
  • setting items (1847)
  • special character within identifier (1544)
  • SQL reserved words (1551)
  • UNLOAD DBSPACE reference (1823)
  • UNLOAD PACKAGE reference (1841)
  • UNLOAD TABLE reference (1829)
  • command-set sequence (1410)
  • commands, control (1614)
  • commands and syntax, Database Services Utility (1609)
  • comment
  • Database Services Utility COMMENT command (1630)
  • in SQL statements (1341)
  • COMMENT command (1628)
  • COMMIT operation
  • command processing (1336)
  • LUW determination by Database Services Utility (1337)
  • message example (1391)
  • COMMITCOUNT parameter
  • description (1387)
  • example (1390)
  • reference (1730)
  • RELOAD DBSPACE command (1809)
  • RELOAD TABLE command (1821)
  • committing
  • records while loading (1386)
  • committing changes
  • SET AUTOCOMMIT (1339)
  • components of the DB2 Server for VSE & VM RDBMS, definitions (1265)
  • concatenation
  • symbol for DB2 Server for VSE & VM (1539)
  • CONNECT
  • connecting to Database Services Utility (1316)
  • processing (1315)
  • user identification (1320)
  • connecting
  • another application server (1327)
  • database manager (1328)
  • connecting DB2 Server for VSE & VM (1317)
  • continuation of Database Services Utility records (1618)
  • CONTINUED parameter
  • DATALOAD's INFILE subcommand (1721)
  • specifying input records (1384)
  • control commands, description (1299), (1615)
  • control file
  • building task (1303)
  • SQL statements (1651)
  • control parameters
  • API (Application Programming Interface) (1578)
  • example (1591)
  • task (1592)
  • conventions
  • highlighting (1269)
  • syntax diagram notation (1272)
  • conversational monitor system (CMS)
  • files (1297)
  • conversion
  • data type (1362), (1739)
  • DATAUNLOAD table (1793)
  • unloading (1752)
  • values on unloading (1796)
  • CREATE VIEW
  • WITH CHECK OPTION (1668), (1816)
  • CS isolation level (1870)
  • cursor stability
  • isolation level (1864)
  • SET ISOLATION command (1865)
  • cursor stability (CS)
  • isolation level (1871)
    • D
  • data
  • embedded in control file (1357)
  • standard zoned (1709)
  • data conversion (1361)
  • Data_Field_Id subcommand (1751)
  • data format support (1360)
  • data object
  • naming (1530)
  • data records in Database Services Utility control files (1620)
  • data records in Database Services Utility input control card files (1619)
  • data type
  • DATE (1678)
  • DECIMAL (1698), (1775)
  • FIXED (1688), (1766)
  • FLOAT or DOUBLE PRECISION (1695)
  • FLOAT or REAL (1692), (1768)
  • GRAPHIC (1712)
  • parameter (1674)
  • SMALLINT (1690)
  • TIME (1683)
  • TIMESTAMP (1687)
  • ZONED (1703), (1779)
  • data unloading tasks (1404)
  • database, starter (1517)
  • Database Services Utility
  • reserved words (1556)
  • starting (1287), (1292)
  • Database Services Utility command
  • definition (1613)
  • DATALOAD and RELOAD locking considerations (1932)
  • DATALOAD command
  • COMMITCOUNT processing (1732)
  • description (1663)
  • embedded data (1358)
  • file definition (1365)
  • procedures (1351)
  • separate input file (1353)
  • DATAUNLOAD command
  • conversion table (1794)
  • description (1743)
  • procedures (1405)
  • user-determined format (1413)
  • DATE
  • local (1680), (1759)
  • date value in CHAR input data field (1677)
  • datetime
  • loading values (1372)
  • DBCS considerations
  • basic support (1956)
  • double-byte character data (1959)
  • extended support (1962)
  • rules (1958)
  • DBCS/EBCDIC mixed data (1755)
  • DBCS shift in/out delimiters (1961)
  • dbspace
  • unload (1432), (1438)
  • debug mode processing (1911)
  • DEBUG storage dump analysis (1912)
  • debugging (1891), (1908)
  • DECIMAL data type (1699), (1701), (1774)
  • default
  • in syntax diagrams (1282)
  • defining
  • files (1364)
  • definitions, terms (1266)
  • DEPARTMENT sample table (1970)
  • determining
  • record count (1393)
  • DFI subcommand (1750)
  • displaying
  • comments (1629)
  • double-byte character set (DBCS)
  • considerations
  • basic support (1955)
  • extended support (1964)
  • description (1741)
  • GRAPHIC data type (1714)
  • DOUBLE PRECISION data type (1697), (1772)
  • double-precision float (1790)
  • double quotation marks
  • identifier (1531)
  • parameter value (1622)
  • DRDA flow
  • DATAUNLOAD command (1407)
  • DRDA protocol
  • CONNECT statement (1321), (1324)
  • DATALOAD command (1345), (1346)
  • introduction (1290)
  • PACKAGE
  • reloading (1487)
  • preprocessing (1309)
  • dump, storage (1906)
    • E
  • embedded data
  • DATALOAD (1356)
  • ending (1738)
  • maximum length (1724)
  • embedded input data (1720)
  • EMP_ACT sample table (1980)
  • EMPLOYEE sample table (1972)
  • ENDDATA subcommand (1735)
  • ending embedded data (1737)
  • ENDLUW control parameter (1589)
  • error reference information
  • codes (1904)
  • types (1894)
  • errors
  • Database Services Utility error handling (1889)
  • debugging (1890)
  • exceptions, arithmetic (1747)
  • EXEC
  • examples (1595)
  • procedures (1594)
  • EXEC SQL
  • restriction (1652)
  • extended DBCS support (1963)
    • F
  • field defaults, output data (1787)
  • field procedure (1402)
  • FIELDPROC See field procedure
  • file definition See FILEDEF command
  • FILEDEF command
  • DATALOAD (1363)
  • DATAUNLOAD (1418)
  • RELOAD DBSPACE (1463)
  • RELOAD PACKAGE (1494)
  • RELOAD TABLE (1464)
  • syntax and notes (1986)
  • UNLOAD DBSPACE (1440)
  • UNLOAD PACKAGE (1493)
  • UNLOAD TABLE (1441)
  • files
  • CMS (1298)
  • FIXED data type (1689), (1765)
  • FLOAT or DOUBLE PRECISION data type (1696), (1771)
  • FLOAT or REAL data type (1693), (1769)
  • floating point
  • unloaded data (1799)
  • format
  • &dbsu list output (1505)
  • default output data field (1788)
  • local date (1681), (1760)
  • local time (1685), (1763)
  • FORMAT control parameter (1585), (1586), (1587)
  • fragment of syntax
  • in syntax diagrams (1285)
  • full qualification (1543)
    • G
  • GRAPHIC data type (1713), (1756)
    • H
  • highlighting
  • text (1270)
  • host variable
  • in syntax diagrams (1274)
    • I
  • identifier
  • blank (1546)
  • lowercase letter (1534)
  • reserved words (1561)
  • special character (1548)
  • identifying
  • self (1318)
  • improving performance (1916)
  • IN_TRAY sample table (1982)
  • index
  • invalid (1638), (1950)
  • reorganization (1637)
  • INFILE, RELOAD DBSPACE command (1811)
  • INFILE parameter
  • RELOAD DBSPACE command (1808)
  • RELOAD TABLE command (1820)
  • INFILE's LIST parameter (1726)
  • INFILE subcommand (1719)
  • input control card file
  • building task (1300)
  • embedded data (1359)
  • errors (1898)
  • SQL statements (1650)
  • input data for DATALOAD (1740)
  • input record
  • limitations (1673)
  • skipping (1400)
  • input_record_id_clauses, example (1669)
  • INTABLE parameter
  • RELOAD TABLE command (1819)
  • interface conventions (1593)
  • introduction to Database Services Utility (1288)
  • invalid index (1639), (1949)
  • invoking task
  • SQLDBSU (1305)
  • invoking the Database Services Utility from application programs (1562)
  • ISOL control parameter (1590)
  • isolation level
  • setting (1869)
  • UNLOAD (1431)
    • J
  • job control example
  • multiple user mode (1520), (1522)
  • single user mode (1513), (1518)
  • job control example, invoking Database Services Utility with single user mode (1519)
  • job control example, multiple user mode (1523)
    • K
  • keyword
  • in syntax diagrams (1273)
  • spanning input records (1626)
  • knowledge prerequisites (1267)
    • L
  • labels for columns (1334)
  • leading sign, zoned field (1710)
  • length of field
  • output (1776)
  • limitations on input records (1665), (1672)
  • lines per page (1877)
  • LINEWIDTH control parameter (1581)
  • link-edit EXEC
  • example (1596)
  • list format Database Services Utility output (1504)
  • LIST parameter
  • description (1725)
  • unreadable DBCS data in message file (1966)
  • load-data
  • commands (1661)
  • committing while loading (1385)
  • into multiple tables (1373)
  • record-count determination (1392)
  • skipping bad records (1394)
  • spanning multiple records (1382)
  • loading
  • multiple table (1374)
  • multiple table rows (1381)
  • null values (1370)
  • procedures (1368)
  • record into several tables (1376)
  • user-specified format (1354)
  • loading commands
  • DATALOAD TABLE (1664)
  • program-load (1832)
  • RELOAD DBSPACE (1803)
  • RELOAD PACKAGE (1840)
  • RELOAD TABLE (1814)
  • local date (1679), (1758)
  • local time (1684), (1762)
  • lock escalation (1926)
  • locking
  • automatic override (1927)
  • catalog tables (1929)
  • considerations
  • DATALOAD and RELOAD (1931)
  • description (1923)
  • reducing lock escalation (1933)
  • SHARE lock (1938)
  • UNLOAD PACKAGE and RELOAD PACKAGE (1935)
  • data (1924)
  • dbspace (1930)
  • escalation (1925)
  • log considerations (1510)
  • log space
  • requirements (1389)
  • logical unit of work (LUW)
  • determination (1338)
  • lowercase characters
  • identifiers (1533)
    • M
  • maximum number of DATALOAD commands per INFILE (1379)
  • message file
  • errors (1899)
  • example (1503)
  • working with (1308)
  • message file display
  • embedded data (1727)
  • MESSAGES control parameter (1583), (1584)
  • mixed data
  • DBCS and EBCDIC (1754)
  • mixed INFILE records to separate tables (1375)
  • multiple-row query (1332)
  • multiple tables (1378)
  • multiple user job control (1521)
  • multiple user mode
  • running (1296)
    • N
  • names and identifiers
  • command (1526)
  • NEW parameter
  • RELOAD DBSPACE command (1805)
  • RELOAD TABLE (1817)
  • nonrecoverable storage pool
  • DATALOAD (1397)
  • dbspace recovery (1920)
  • processing errors (1896)
  • RELOAD PURGE (1456)
  • NOREWIND parameter (1645), (1729)
  • NOREWIND parameter, DATAUNLOAD (1785)
  • notification of records reloaded (1459)
  • null
  • DATALOAD (1371)
  • in omitted columns during DATALOAD (1350)
  • representation in unloaded data (1795)
  • null-clause
  • examples (1781)
  • null/current clause
  • example (1716), (1717)
  • TCI subcommand (1715)
  • numeric
  • representation in unloaded data (1798)
  • values in CHAR input data fields (1676)
  • NUMERIC data type (1702) See also DECIMAL data type
    • O
  • object name
  • qualification (1538)
  • operator console messages (1892)
  • optional
  • default parameter
  • in syntax diagrams (1284)
  • item
  • in syntax diagrams (1279)
  • keyword
  • in syntax diagrams (1283)
  • order
  • input records (1666)
  • OUTFILE subcommand (1782)
  • output format (1859)
  • output record format example (1791)
  • overview of Database Services Utility (1289)
    • P
  • package
  • considerations (1943)
  • description (1475)
  • invalidation (1429)
  • performance considerations (1942)
  • portable package migration (1489)
  • preprocessing (1472)
  • RELOAD (1488)
  • tasks (1471)
  • UNLOAD (1480)
  • PACKAGE
  • packed decimal
  • input data (1700)
  • output data (1773)
  • page width (1879)
  • PAGECTL control parameter (1588)
  • parameter values
  • spanning input records (1625)
  • parentheses
  • in syntax diagrams (1276)
  • percent free space (1453)
  • performance
  • considerations
  • package (1944)
  • reorganizing indexes (1948)
  • period
  • concatenation (1540)
  • PL/I, invoking the Database Services Utility (1575)
  • placement of SQL statements (1616)
  • precision
  • decimal input data (1706)
  • zoned data (1707)
  • procedure
  • DATALOAD (1352)
  • DATAUNLOAD (1406)
  • general loading (1369)
  • UNLOAD
  • unloading dbspaces (1422)
  • unloading tables (1421)
  • processing
  • debug mode (1910)
  • load-program commands (1835)
  • processing summary for the Database Services Utility (1658)
  • program-load commands, reference (1833)
  • programming interfaces provided by the Database Services Utility (1992)
  • PROJ_ACT sample table (1978)
  • PROJECT sample table (1974)
  • PROMPTS control parameter (1582)
  • punctuation mark
  • in syntax diagrams (1275)
  • PURGE parameter
  • description (1450)
  • RELOAD DBSPACE command (1451), (1807)
  • RELOAD TABLE command (1818)
    • Q
  • qualifying
  • object names (1537)
  • table name (1541)
  • query
  • multiple-row (1331)
  • quotation mark
  • double, in identifier (1532)
  • parameter value (1623)
  • single, in comment (1633)
    • R
  • READ FILE (1606)
  • REAL data type (1694), (1770)
  • REBIND PACKAGE command
  • reference (1845)
  • RECFM V input (1367)
  • records reloaded (1460)
  • reducing
  • lock escalation (1934)
  • log space requirements (1388)
  • reference
  • command specification (1608)
  • Database Services Utility commands (1607)
  • reference material (1909)
  • Database Services Utility (1508)
  • DBCS considerations (1954)
  • debugging (1907)
  • double-byte character set (1952)
  • entering File Identifiers (1989)
  • FILEDEF command (1985)
  • ideographic character (1953)
  • improving performance (1915)
  • locking considerations (1922)
  • nonrecoverable storage pool (1918)
  • sample tables (1967)
  • specifying
  • CMS tape label processing (1990)
  • ddname (1987)
  • device type (1988)
  • options (1991)
  • storage dump, Database Services Utility-initiated (1905)
  • storage pool, nonrecoverable (1917)
  • tables, example, DB2 Server for VSE & VM (1968)
  • usage considerations (1945)
  • referential integrity
  • RELOAD commands (1448)
  • register contents for dynamic startup (1567)
  • RELOAD command
  • description (1465)
  • errors (1490)
  • NEW parameter (1806)
  • PURGE parameter (1452)
  • reload-data tasks
  • nonrecoverable storage pools affecting reloading (1454)
  • receiving reload-notification (1457)
  • updating statistics (1466)
  • RELOAD DBSPACE command
  • description (1447), (1802)
  • RELOAD PACKAGE command
  • description (1838)
  • locking conditions (1937)
  • synonym (1476)
  • syntax diagram (1837)
  • task (1486)
  • TIMESTAMP (1477)
  • usage considerations (1941)
  • RELOAD TABLE command (1813)
  • remote unit of work
  • PACKAGE
  • description (1474)
  • unloading (1481)
  • unsupported commands
  • SET ISOLATION command (1867)
  • SET UPDATE STATISTICS command (1885)
  • REORGANIZE INDEX command (1635)
  • reorganizing indexes (1636), (1947)
  • repeat symbol
  • in syntax diagrams (1281)
  • repeatable read (RR)
  • isolation level (1863)
  • report
  • errors (1897)
  • example (1501)
  • working with (1302)
  • required item
  • in syntax diagrams (1278)
  • reserved words
  • DBSU (1558)
  • SQL (1286), (1554)
  • using as identifiers (1560)
  • RESTARTCOUNT option (1733)
  • RESTARTCOUNT parameter
  • RELOAD TABLE command (1822)
  • restarting
  • data load processing (1398), (1734)
  • RESTARTTABLE parameter
  • RELOAD DBSPACE command (1810)
  • restriction
  • EXEC SQL (1653)
  • return code reference information
  • error codes (1903)
  • return codes (1902)
  • return codes from the Database Services Utility (1568)
  • REWIND parameter (1644), (1728)
  • REWIND parameter, DATAUNLOAD (1786)
  • RR isolation level (1868)
  • rules
  • naming data objects (1529)
  • running
  • Database Services Utility
  • multiple user mode (1293)
  • single user mode (1294)
    • S
  • sample table
  • ACTIVITY (1975)
  • CL_SCHED (1983)
  • DEPARTMENT (1969)
  • EMP_ACT (1979)
  • EMPLOYEE (1971)
  • IN_TRAY (1981)
  • PROJ_ACT (1977)
  • PROJECT (1973)
  • SCHEMA
  • command (1642)
  • input file (1647)
  • Select statement
  • arithmetic exception (1655)
  • command processing (1329)
  • multiple-row query (1330)
  • terminating (1745)
  • using with DATAUNLOAD (1746)
  • SELECT statement
  • sequence numbers in input control card file records (1617)
  • sequential file output (1784)
  • set-item commands (1861)
  • SET AUTOCOMMIT (1850)
  • SET ERRORMODE (1853)
  • SET FORMAT (1856)
  • SET ISOLATION (1866)
  • SET LINECOUNT, SET LINEWIDTH (1875)
  • SET UPDATE STATISTICS (1883)
  • set_null_clause
  • reference (1780)
  • setting
  • lines per page (1876)
  • output format (1858)
  • page width (1878)
  • SHARE lock (1939)
  • shift in/out delimiters, DBCS (1960)
  • single-precision float (1789)
  • single quotation mark
  • COMMENT command (1632)
  • option values (1624)
  • single record into several tables (1377)
  • single user mode
  • job control example (1514)
  • running (1295)
  • starting the Database Services Utility (1511)
  • single value queries (1333)
  • skipping bad records (1396)
  • SMALLINT data type (1691)
  • spanning records
  • control file records (1723)
  • input control card file records (1722)
  • multiple input records (1383)
  • special characters
  • identifiers (1549)
  • SQL
  • reserved words (1552)
  • statement processing (1649)
  • SQL comment
  • in Database Services Utility commands (1340)
  • SQL statements
  • COMMIT (1312)
  • CONNECT (1313)
  • SELECT (1314)
  • using (1311)
  • within Database Services Utility (1310)
  • SQL system
  • user identification (1319)
  • SQLDBSU EXEC
  • description (1524)
  • invocation task (1306)
  • multiple user mode (1602)
  • single user mode (1604)
  • syntax diagram (1600)
  • SQLHX
  • canceling the Database Services Utility (1343)
  • SQLQRY
  • querying the current status (1342)
  • starter database (1516)
  • starting
  • Database Services Utility (1291)
  • DATALOAD after an error (1399)
  • starting the Database Services Utility with single user mode (1512)
  • statistics
  • generating (1401)
  • suppressing (1887)
  • statistics update tasks
  • receiving reload notification (1458)
  • storage dump analysis
  • DEBUG (1913)
  • guidelines (1914)
  • storage pool
  • nonrecoverable (1919)
  • strategy-of-reload tasks
  • nonrecoverable storage-pool effects (1455)
  • subcommands
  • DFI (Data Field Identification) (1749)
  • ENDDATA (1736)
  • INFILE (1718)
  • OUTFILE (1783)
  • TCI (Table Column Identification) (1671)
  • summary
  • Database Services Utility processing (1657)
  • suppressing statistics (1886), (1888)
  • syntax diagram
  • COMMENT (1631)
  • DATALOAD (1667)
  • DATAUNLOAD (1744)
  • notation conventions (1271)
  • REBIND PACKAGE (1846)
  • RELOAD DBSPACE (1804)
  • RELOAD PACKAGE (1839)
  • RELOAD TABLE (1815)
  • REORGANIZE INDEX (1640)
  • SCHEMA (1643)
  • schema file (1646)
  • SET AUTOCOMMIT (1851)
  • SET ERRORMODE (1854)
  • SET FORMAT (1857)
  • SET ISOLATION (1862)
  • SET LINECOUNT (1880)
  • SET LINEWIDTH (1881)
  • SET UPDATE STATISTICS (1884)
  • SQLDBSU EXEC
  • multiple user mode (1601)
  • single user mode (1603)
  • UNLOAD DBSPACE (1826)
  • UNLOAD PACKAGE (1843)
  • system-determined format, DATAUNLOAD (1408)
    • T
  • table
  • name (1542)
  • target (1349)
  • table unload (1439)
  • TABLE unload (1434)
  • tape
  • DASD data file errors (1901)
  • tape-file support (1921)
  • target table (1348)
  • tasks
  • command input (1498)
  • DB2 Server for VSE & VM preprocessing (1473)
  • FILEDEF
  • DATALOAD (1366)
  • DATAUNLOAD (1417)
  • RELOAD DBSPACE (1461)
  • RELOAD TABLE (1462)
  • UNLOAD DBSPACE (1442)
  • UNLOAD TABLE (1443)
  • including data in message file (1502)
  • including data in report (1500)
  • interpreting the output of the Database Services Utility (1495)
  • loading data (1344)
  • message file output
  • error recovery (1507)
  • RELOAD PACKAGE command (1485)
  • file definition (1492)
  • reloading
  • data (1446)
  • package (1470)
  • report output (1506)
  • understanding (1497)
  • SQLDBSU EXEC (1307)
  • system output (1499)
  • understanding report output (1496)
  • UNLOAD PACKAGE command (1478)
  • file definition (1491)
  • unloading
  • data (1403)
  • package (1469), (1482)
  • TCI (Table Column Identification) subcommand (1670)
  • terminal input mode (1605)
  • terminology (1264)
  • text highlighting conventions (1268)
  • TIME (1682), (1761)
  • TIMESTAMP (1686), (1764)
  • trailing sign, zoned field (1711)
  • truncation
  • DBCS data (1757)
  • during data unloading (1800)
  • type of error (1895)
    • U
  • uncommitted read (UR)
  • isolation level (1873)
  • unique constraints (1427)
  • unload-data tasks
  • using FILEDEFs
  • DATAUNLOAD (1416)
  • UNLOAD DBSPACE (1444)
  • UNLOAD TABLE (1445)
  • UNLOAD data used as input (1347)
  • UNLOAD DBSPACE command
  • description (1824)
  • example (1424)
  • procedures (1423)
  • syntax diagram (1825)
  • task (1433)
  • UNLOAD PACKAGE command
  • locking conditions (1936)
  • performance considerations (1940)
  • reference (1842)
  • task (1479)
  • UNLOAD TABLE command
  • description (1827)
  • example (1425)
  • procedures (1435)
  • syntax diagram (1828)
  • task (1436)
  • unloading
  • column to more than one output record (1753)
  • data
  • system-determined format (1409)
  • user-specified format (1411)
  • package (1483)
  • procedure
  • dbspace (1420)
  • table (1419)
  • program (1484)
  • view (1414)
  • unreadable data cause (1965)
  • UPDATE STATISTICS
  • REORGANIZE INDEX (1951)
  • statistics collection (1468)
  • usage considerations (1946)
  • updating statistics (1467)
  • UR isolation level (1872)
  • user-specified
  • data unloading (1412)
  • format, loading data (1355)
  • output record format example (1792)
  • using the Database Services Utility
  • application program (1509)
  • C program (1571)
  • COBOL program (1572)
  • PL/I program (1574)
    • V
  • value conversion on unloading (1797)
  • view
  • UNLOAD command (1437)
  • unloading (1415)
    • W
  • words, reserved
  • DBSU (1557)
  • SQL (1553)
  • write-to-operator (WTO) messages (1893)
    • Z
  • ZONED data type (1704), (1778)
  • zoned input data
  • precision (1705)
  • scale (1708)
  • zoned output (1777)

    • [ Top of Page | Previous Page | Table of Contents | Index ]