DB2 REXX SQL for VM/ESA^(R): Installation and Reference

Index

Special Characters
Numerics
A B C D E F G H I K L M N O P R S T U V W X Z

Special Characters

data type attributes

returned from DESCRIBE. (1865)

Numerics

0EX (1739), (1740)

0FX (1737), (1738)

access

definition (2107)

ACCESS command, CP (1619)

access path (1728)

accessing DB2 RXSQL message repository (1627)

active set (1670)

columns in (1885)

ADDRESS

CMS command (2087)

application server

definition (2108)

arithmetic operator

in syntax diagrams (1350)

authorization

definition (2109)

granting authority (1553)

SFS directories

production SFS directory (1522), (1547)

service SFS directory (1523), (1548)

SQLUSER (1544)

GRANT AUTHORITY (1526), (1552)

read (1527)

authorization ID

definition (2110)

basic system files (1955)

blocking (1673), (1680)

PUT statement

data type error (1929)

byte

definition (2111)

CALL statement (1807)

callable services library (CSL) (2082)

catalog

definition (2112)

catalog table

definition (2113)

CHAR data type (1845), (1916)

character

definition (2114)

checklist

minidisks (1453), (1454)

SFS directories (1500), (1501)

choose

in syntax diagrams (1353)

CLOSE statement (1811)

CMS

related messages (2013)

related return codes (2023)

CMS (conversational monitor system)

definition (2115)

PRINT command (1474), (1534)

CMS HELP facilities (1666)

CMS return code

-3 (2024)

28 (2025), (2026)

41 (2027)

CMS work unit support (2079)

column

definition (2116)

command

CMS PRINT (1472), (1536)

DETACH (1481)

DISCONNECT (1484)

LINK (1460)

CREATE (1519)

definition (2117)

ENROLL (1513)

GRANT AUTHORITY (1525), (1550), (1555)

VMFPLC2

installation (1467), (1530)

VMFPLC2 (servicing) (1590)

commands

RXSQL (1804)

commit

definition (2118)

COMMIT statement (1813)

Compiled REXX (1610)

CONNECT authority

definition (2119)

CONNECT statement (1815)

constant

definition (2120)

continuing RXSQL requests (1682)

control program (CP)

commands

DETACH (1479)

DISCONNECT (1482)

LINK (1458)

definition (2121)

conventions

syntax diagram notation (1345)

conversational monitor system (CMS)

definition (2123)

PRINT command (1473), (1535)

corrective service

EXECs

ELOAMOD (1605)

ELOSCOR (1595), (1987)

ELOSHLP (1600)

installation

Step 1 (1588)

Step 2 (1591)

Step 3 (1592)

overview (1572)

space requirements (1573)

COUNTER operator command (1656)

related messages (2014)

CP (control program)

commands

DETACH (1480)

DISCONNECT (1483)

LINK (1459)

definition (2122), (2124)

CP ACCESS command (1620)

CP LINK command (1622)

CREATE PACKAGE statement (1819)

CSL EXTRACT routine (2084)

cursor (1668)

customizing date and time formats

minidisks (1486)

SFS directories (1557)

data type (1906)

CHAR (1846)

character (1732)

DATE (1858)

DECIMAL (1743), (1843), (1914)

error (1930)

FLOAT (1742), (1839)

GRAPHIC (1852)

INTEGER (1744), (1835)

LONG VARCHAR (1850)

LONG VARGRAPHIC (1856)

REAL (1840)

RXSQL conversion rules (1731)

SMALLINT (1837)

TIME (1860)

TIMESTAMP (1862)

VARCHAR (1848)

VARGRAPHIC (1854)

ZONED DECIMAL (1864)

database

definition (2129)

installation steps

minidisks (1489)

SFS directories (1560)

loading packages

ELOAMOD EXEC (1494), (1564)

Database (2128)

Database 2 Server for VM

monitoring the system (1658)

related return codes (2028)

SELECT statement (1639)

database machine

definition (2125)

database management system (DBMS)

definition (2126)

database manager

definition (2127)

date

customizing

minidisks (1487)

SFS directories (1558)

definition (2130)

format (1935)

DATE data type (1857)

DB2 RXSQL

accessing (1618)

DB2 RXSQL product files

basic (1377)

DB2 Server for VM

monitoring the system (1658)

related return codes (2028)

SELECT statement (1639)

DB2 Server for VM HELP (2002)

DBA authority

definition (2131)

dbspace

definition (2132)

DECIMAL data type (1842), (1913)

DECLARE - Extended Dynamic (1823)

default

definition (2133)

in syntax diagrams (1355)

delimiting RXSQL requests (1681)

DESCRIBE request

data type abbreviations (1832)

description (1826)

diagnosis (2071)

direct access storage device (DASD)

definition (2134)

directory

definition (2135)

distributed relational database architecture (DRDA)

definition (2136)

DRDA protocol (2102)

DROP STATEMENT (1867), (1870)

DROPSTMT statement (1868)

dynamic CALL statement (1806)

Dynamic DECLARE statement (1821)

Dynamic DESCRIBE statement (1825)

Dynamic EXECUTE statement (1872)

Dynamic PREPARE statement (1896)

dynamic SQL in RXSQL, using (1674), (1678)

elements of RXSQL requests (1683)

ELOAMOD EXEC

description (1976)

loading packages (1606)

ELODNLS EXEC (2009)

description (2007)

national language (2005)

syntax (2008)

ELOHLPLD EXEC (1982)

ELOINLS EXEC, tape file 1 (1386)

ELOLANG EXEC, function (1404)

ELOLANMS EXEC (1407)

ELOLKED EXEC (1984)

ELOSCOR EXEC

description (1594), (1986)

installation steps (1593)

syntax (1990)

ELOSHLP EXEC (1991)

ELOSHLP EXEC, servicing HELP text (1599)

ELOUME TXTAMENG, tape file 1 (1389)

ELOUME TXTFRANC, tape file 1 (1395)

ELOUME TXTHANZI, tape file 1 (1398)

ELOUME TXTKANJI, tape file 1 (1401)

ELOUME TXTUCENG, tape file 1 (1392)

EMPCRE sample program (2042)

EMPDCL program (2048)

EMPDCLM program (2054)

EMPPRP sample program (2046)

EMPPRPM sample program (2052)

EMPSEL sample program (2044)

EMPSELX sample program (2050)

empty string (1746)

EMPUPD sample program (2056)

error

CMS (1790), (1799)

messages, RXSQL (2030)

RXSQL (1788), (1798)

SQL (1786), (1796)

error handling

RXSQL (1789)

example execs (1962)

examples

installation

Directory Control Statements for the SQLMACH Machine (1457)

granting authority (1521)

increasing size of SFS directory (1511)

RXSQL requests (2038)

SQLINIT command (1491)

EXEC

definition (2137)

EXEC statement (1878)

EXECs

authorization (1980)

description (1979)

ELOAMOD (1977)

ELODNLS

function (2006)

ELOHLPLD (1981)

ELOLANG (1405)

ELOLANMS

tape file 1 (1408)

ELOLKED (1983)

ELOSCOR

corrective service (1596), (1988)

description (1597), (1989)

ELOSHLP (1601)

example (1961)

general use (1957)

HELP RXSQL MENU (1664)

HELP text (2001)

I5697ELO (1973)

installation (1969)

INSTFPP

function (1463)

prerequisites (1464)

RXCASE (1632)

RXSELECT (1637)

RXSQL-Supplied (1614)

RXSQLANG (1643), (2004)

RXSQLEX (1646)

RXSQLHLP (1647), (2003)

RXSQLOP (1653)

RXSQLVL (1660)

sample (1616)

sample RXSQL (2039)

SQLINIT (1626)

SQLSTART (2101)

syntax (2010)

EXECSQL (1687), (1721)

EXECUTE IMMEDIATE statement (1879)

extended CALL statement (1809)

Extended DECLARE statement (1822)

Extended DESCRIBE statement (1866)

extended dynamic SQL in RXSQL, using (1676), (1679)

Extended EXECUTE statement (1875)

Extended PREPARE statement (1903)

FETCH statement (1884)

file mode

definition (2138)

file pool administration machine (1515)

file pool ID (VMSYS) (1505)

file type

definition (2139)

files, installation (1966)

files supplied by IBM (1954)

FLOAT data type (1838), (1910), (1912)

fragment of syntax

in syntax diagrams (1358)

GLOBALV (2058)

GRANT AUTHORITY command

read access to production SFS directory (1524)

read access to the DB2 RXSQL production files (1549), (1554)

read access to the DB2 RXSQL service files (1546)

graphic character

shift-in (1735)

shift-out (1736)

GRAPHIC data type (1851), (1919)

hardware requirements (1361)

HELP command (1650)

HELP facilities (1617)

HELP files (1958)

HELP information (1997)

HELP RXSQL MENU (1665)

host variable (1710), (1745), (1810), (1873), (1876) , (1893), (1899), (1928)

in syntax diagrams (1347)

I5697ELO 071012

tape file 1 (1382)

I5697ELO EXEC (1476)

syntax (1972), (1975)

tape file 1 (1384)

incompatibilities by release, RXSQL (2105)

indicator stem

definition (1706)

indicator variable (1724), (2104)

indicator variable.

installation

checklists

minidisks (1452)

SFS directories (1499)

corrective service (1587), (1994)

customizing DB2 RXSQL (1485), (1556)

enrolling a user (1514)

EXECs

ELOAMOD (1492), (1562)

ELOHLPLD (1493), (1563)

ELOLKED (1985)

I5697ELO (1974)

granting authority to SQLUSER machine (1543)

increasing size of SFS directory (1509)

machine-readable material, tape file contents (1380)

manual verification (1567)

Memo to Users (1465), (1537)

messages, information and error (2012)

NLS languages (1570)

optional DB2 RXSQL product files (1431)

overview

installation process (1370)

minidisks (1449)

SFS directories (1496)

phase 1 (preinstallation)

minidisks (1455)

overview (1371)

SFS directories (1502)

phase 2 (VM)

minidisks (1461)

overview (1372)

SFS directories (1528)

phase 3 (DB2 Server for VM database)

minidisks (1488)

overview (1373)

SFS directories (1559)

phase 4 (non-DB2 Server for VM database)

minidisks (1495)

overview (1374)

SFS directories (1566)

prerequisites (1369)

preventive service (1580)

requirements

hardware (1364)

software (1368)

Virtual Machine (1432)

SET LANGUAGE command (1629)

space requirements

MAINT machine (1436), (1577)

SQLMACH machine (1441)

SQLUSER machine (1446)

tape files provided

tape file 1 contents (1379)

tape file 10 contents (1426)

tape file 11 contents (1428)

tape file 12 contents (1430)

tape file 2 contents (1410)

tape file 3 contents (1412)

tape file 4 contents (1414)

tape file 5 contents (1416)

tape file 6 contents (1418)

tape file 7 contents (1420)

tape file 8 contents (1422)

tape file 9 contents (1424)

installation EXECs (1970)

installation files (1965)

installing DB2 RXSQL (1448)

INTEGER data type (1834), (1908)

Interactive Structured Query Language (ISQL)

definition (2140)

isolation level

SQLISL command (1938)

IUCV communications (2073)

Kanji

definition (2141)

keyword

definition (2142)

in syntax diagrams (1346)

LINK command, CP (1621)

literal

definition (2143)

literal variable (1686)

load

definition (2144)

logical unit of work (LUW)

definition (2145)

LONG VARCHAR data type (1849), (1918)

LONG VARGRAPHIC data type (1855), (1921)

machine-readable material

basic product files (1378)

MAINT machine

space requirements

installation (1438)

servicing (1579)

maintenance

NLS languages (1571)

Memo to Users

installation (1466), (1538)

printing (1475), (1539)

servicing (1585)

message repository

ELOINLS EXEC (1387)

ELOUME TXTAMENG (1390)

ELOUME TXTFRANC (1396)

ELOUME TXTHANZI (1399)

ELOUME TXTKANJI (1402)

ELOUME TXTUCENG (1393)

minidisks (1471)

SFS directories (1533)

messages (2011), (2020), (2031), (2033)

metavariables (1691)

attributes_variable (1692)

authorization_name (1693)

cursor_name (1694)

function_number (1697)

indicator_stem (1707)

indicator_variable (1712)

main_stem (1705)

main_variable (1711), (1722)

operator_command (1699)

option (1700)

package_id (1702)

package_name (1701)

password (1703)

rexx_host_stem_name (1704)

rexx_host_variable (1709), (1720)

rexx_host_variable_list (1708)

section_number (1714)

server_name (1715)

sql_statement (1716)

statement_name (1695)

trace_level (1698)

variable_name (1718)

variable_qualifier (1713), (1725)

migration considerations

files not required for DB2 RXSQL 4.1 (1968)

ELOSHLP EXEC (1995)

minidisk

definition (2146)

installing DB2 RXSQL (1451)

multiple user mode

definition (2147)

NAMES command (1887)

National Language Support (NLS)

displaying HELP (1644)

national languages (1996)

NLS

definition (2148)

installation (1569)

maintenance (1568)

NUCXLOAD (2092)

NUMERIC

see DECIMAL (1844), (1915)

Online HELP information (1998)

OP command (1890)

OPEN statement (1892)

operating system requirements

hardware (1362)

software (1366)

operator command (1889)

request (1657)

optional

default parameter

in syntax diagrams (1357)

item

in syntax diagrams (1352)

keyword

in syntax diagrams (1356)

owner

definition (2149)

package

definition (2150)

reloading (1604)

parameter

definition (2151)

parameter marker (1874), (1877), (1882), (1894), (1898) , (1900), (1901), (1905), (1932)

restriction (1805)

RXSQL usage (1685)

parentheses

in syntax diagrams (1349)

performance improvement (2057)

Positioned DELETE statement (1672)

Positioned UPDATE statement (1671)

PREP statement (1895)

PREPARE - Extended Dynamic (1902)

prerequisites for running DB2 RXSQL (1360)

preventive service

ELOAMOD EXEC, syntax (1978)

ELOSHLP EXEC

description (1992)

syntax (1993)

installation (1581)

overview (1574)

VM VMSERV EXEC (1584)

private dbspace

definition (2152)

Programs

sample RXSQL

EMPCRE (2041)

EMPDCL (2047)

EMPDCLM (2053)

EMPPRP (2045)

EMPPRPM (2051)

EMPSEL (2043)

EMPSELX (2049)

EMPUPD (2055)

public dbspace

definition (2153)

punctuation mark

in syntax diagrams (1348)

PURGE command (1923)

PUT request

description (1925)

PUT statement (1926)

rc (1792), (2019)

(see also return code) (1782)

REAL data type

see FLOAT (1841), (1911)

reloading a package (1602)

repeat symbol

in syntax diagrams (1354)

repository, message (1964)

request syntax (1689)

required item

in syntax diagrams (1351)

RESOURCE authority

definition (2154)

result table (1669)

return code (1784), (1794)

definition (2155)

return codes (2018)

REXX

CSL function (2083)

definition (2156)

host variable (1719)

variables (1611)

RXSQL conversion rules (1730)

ROLLBACK statement (1933)

row

definition (2157)

runtime environment, RXSQL (2093)

RXCASE EXEC (1631)

RXSELECT EXEC (1636)

RXSQL

basic system files (1956)

commands

list of (1803)

concepts (1667)

data type abbreviations (1833), (1907)

definition (2158)

description (1608)

distributed environment, using in a (2103)

error messages (2029)

example execs (1963)

files (1953)

getting started (1607)

HELP files (1960)

help menu (1662)

incompatibilities by release (2106)

installation files (1967)

installation messages (2015)

installation requirements

hardware (1363)

software (1367)

virtual machine (1433)

installing

in VM (1462)

on minidisks (1450)

on SFS directories (1497)

LOADLIB module (2091)

machine-readable material (1375)

messages (2016), (2022)

MODULE (2090)

online help (1663)

overview (1609)

package (1490), (1561)

prerequisites for running (1359)

programs (1959)

request syntax (1688)

return codes (1781), (2017), (2021)

run-time environment (2089)

sample programs (1615), (2040)

source file

ASSEMBLE (2097)

statements

Dynamic SQL (1675)

Extended Dynamic SQL (1677)

list of (1801)

subcommand environment (2085), (2086)

supplied program messages (2035)

supplied programs (1613), (1630)

transient module (2096)

variables (1747)

warning messages (2032)

RXSQL MODULE (2094)

RXSQL requests

CALL (1808)

CLOSE (1812)

COMMIT (1814)

CONNECT (1816)

CREATE (1820)

DECLARE - Extended Dynamic (1824)

DESCRIBE - Dynamic (1827)

descriptions (1800)

DROP STATEMENT (1871)

DROPSTMT (1869)

EXEC (1880)

EXECUTE IMMEDIATE (1881)

FETCH (1883)

NAMES (1886)

OP (1888)

OPEN (1891)

PREP (1897)

PREPARE - Extended Dynamic (1904)

PURGE (1924)

PUT (1927)

ROLLBACK (1934)

SQLDATE (1937)

SQLISL (1940)

SQLTIME (1943)

STATE (1945)

STMT (1947)

TRACE (1949)

XCALL (1951)

RXSQL return code (1791)

RXSQL32 (2059), (2060)

RXSQLANG EXEC (1642), (2000)

RXSQLEX EXEC (1645)

RXSQLHLP EXEC (1648), (1649), (1999)

RXSQLOP EXEC (1654)

RXSQLVL EXEC (1661)

S$Q$L S$T$M$T (1640)

sample programs (2037)

scientific notation (1741)

scroll

definition (2159)

SELECT statement (1638)

service EXECs (1971)

servicing

HELP text (1598)

Memo to Users (1586)

packages (1603)

SET LANGUAGE command (1628)

SFS

CREATE command (1517)

creating SFS directories (1518)

ENROLL command (1512)

file pool

administration machine (1516)

ID (VMSYS) (1503)

granting authority

GRANT command (1520)

SQLUSER machine (1542)

increasing size of SFS directory (1510)

storage group

DB2 RXSQL assigned (1507)

VMSYS file pool (1506)

Shared File System (SFS) (1624)

CREATE command (1517)

creating SFS directories (1518)

ENROLL command (1512)

file pool

administration machine (1516)

ID (VMSYS) (1503)

granting authority

GRANT command (1520)

SQLUSER machine (1542)

increasing size of SFS directory (1510)

storage group

DB2 RXSQL assigned (1507)

VMSYS file pool (1506)

shared file system directory (SFS directory)

definition (2160)

installing DB2 RXSQL (1498)

shift-in character (1734)

shift-out character (1733)

SHOW operator command (1655)

single user mode (2098)

defintion (2161)

SMALLINT data type (1836), (1909)

software requirements (1365)

space requirements

MAINT machine

installation (1437)

service (1578)

SQLMACH machine (1442)

SQLUSER machine (1447)

SQL communication area (SQLCA)

definition (2163)

fields (1772)

SQLCA

variables (1771)

SQLCODE

-301 (2072)

-521 (1931)

-900 (2077)

-914 (2076)

definition (2162)

description (1773)

error conditions (1797)

performance (2070)

SQLDATE command (1936)

SQLDATE variable (1759)

SQLERRD.n (1780), (2069)

SQLERRM (1775), (1817), (2066)

SQLERRMC (1776), (1818), (2062)

SQLERRP (1777), (2067)

SQLEXEC (2099)

SQLINIT EXEC (1625)

SQLINIT WORKUNIT (2081)

SQLISL command (1939)

SQLISL variable (1761)

SQLMACH (database) machine

increasing size of SFS directory (1508)

installation (1443)

installation space requirements (1440)

SQLMACH database machine (1623)

SQLNAMES (1756)

SQLOP.i variable (1757)

SQLSTART EXEC (2100)

SQLSTATE (1766)

definition (2164)

SQLSTATE variable (1774), (2065)

SQLSTMT (1768)

SQLSTMTN variable (1769)

SQLTIME command (1942)

SQLTIME variable (1763)

SQLUSER machine

authorization (1545)

granting authority (1551)

space requirements (1445)

SQLWARN (1779), (2068)

SQLWARN.n (1778), (2061)

STATE command (1944)

statement

definition (2165)

statements

RXSQL (1802)

STMT command (1946)

storage pool

definition (2166)

STRING, option of RXCASE EXEC (1635)

Structured Query Language/Data System (SQL/DS)

definition (2167)

subcommand environment, RXSQL (2088)

supplied program messages, RXSQL (2036)

support for CMS work units (2078)

syntax, RXSQL request (1690)

syntax diagram

notation conventions (1344)

table

definition (2168)

tape file 1

contents

ELOINLS EXEC (1385)

ELOLANG EXEC (1403)

ELOLANMS EXEC (1406)

ELOUME TXTAMENG (1388)

ELOUME TXTFRANC (1394)

ELOUME TXTHANZI (1397)

ELOUME TXTKANJI (1400)

ELOUME TXTUCENG (1391)

I5697ELO EXEC (1383)

I5697ELO 071012 (1381)

loading (1469), (1531)

tape file 10

contents (1425)

tape file 11

contents (1427)

tape file 12

contents (1429)

tape file 2

contents (1409)

loading (1470), (1532)

tape file 3

contents (1411)

loading (1477), (1540)

tape file 4

contents (1413)

loading (1478), (1541)

tape file 5

contents (1415)

tape file 6

contents (1417)

tape file 7

contents (1419)

tape file 8

contents (1421)

tape file 9

contents (1423)

tape files provided (1376)

time

definition (2169)

TIME data type (1859)

time format (1941)

TIMESTAMP data type (1861)

TRACE command (1948)

transient module, RXSQL (2095)

truncation (2075)

UPPER, option of RXCASE EXEC (1634)

uppercase (2074)

uppercase translation (1684), (1696), (1717)

user ID

definition (2170)

VARCHAR data type (1847), (1917)

VARGRAPHIC data type (1853), (1920)

variable

definition (2171)

variable qualifier (1726)

CCSID (1727)

variables

global (1633)

rc (1783), (1793)

REXX (1612)

RXSQL conversion rules (1729)

RXSQLMSG (1749), (2064)

RXSQLNAMES (1755)

RXSQLREQUEST (1748), (2063)

RXSQLSTATE (1765)

RXSQLSTMT (1767)

SQLDA (1750)

SQLDAC (1753), (1830)

SQLDAL (1754), (1831)

SQLDAN (1751), (1828)

SQLDAT (1752), (1829)

SQLDATE (1760)

SQLISL (1762)

SQLOP.i (1758)

SQLSTMTN (1770)

SQLTIME (1764)

user (1723)

verification of installation (1565)

Virtual Machine (VM)

definition (2172)

requirements

MAINT (1434)

SQLMACH (1439)

SQLUSER (1444)

VM/ESA (Virtual Machine/Enterprise Systems Architecture)

directory, SQLMACH machine (1456)

MAINT machine

space requirements for installation (1435)

space requirements for service (1576)

VM/ESA environment (Virtual Machine/Enterprise Systems Architecture)

definition (2173)

VM-PUT tape (1575)

VM VMSERV EXEC (1583)

VMFPLC2 command

installation (1468), (1529)

servicing (1589)

VMSERV (1582)

VMSYS, file pool ID (1504)

warning

messages, RXSQL (2034)

RXSQL (1787)

SQL (1785), (1795)

work unit support (2080)

XCALL statement (1950)

XEDIT

command synonyms (1641), (1651), (1652), (1659)

XPREP statement (1952)

ZONED DECIMAL data type (1863), (1922)

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

DB2 REXX SQL for VM/ESA(R): Installation and Reference

Index

DB2 REXX SQL for VM/ESA^(R): Installation and Reference