DB2 Server for VSE & VM: Interactive SQL Guide and Reference

Index

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

Numerics

3270 display terminal (1902)

accessing

table belonging to other users (2672)

activating

foreign key (2629)

primary key (2628)

unique constraint (2630)

ACTIVITY sample table (3204)

adding

column to a table (2587)

data to a table (2935)

foreign key (2619)

null value to a column (2940)

primary key (2605)

referential constraint (2620)

row to a table

data from another table (2568)

ALL

granting to multiple users (2645)

SELECT statement (2949)

ALL BUT

FORMAT command (2233)

ALTER TABLE (2590)

altering

SQL line (2177)

SQL statement (2190)

table

adding foreign key (2621)

adding primary key (2606)

deactivating foreign key (2635)

deactivating primary key (2634)

deactivating unique constraint (2636)

answers to the exercises (3194)

ARI0503E message (1974)

ARI0504I message (1975)

ARI0505I message (1976)

ARI7040I message (2715)

ARI7043I message (2714)

ARI7044I message (1988), (2028), (2806)

ARI7061I message (2202), (2203)

ARI7601I message (1967)

ARI7960I message (2057)

arithmetic

exception

formatting with an arithmetic error (2307)

arithmetic operator

in syntax diagrams (1888)

authority

DBA (database administrator) (1944), (1946)

resource (2531)

AUTOCOMMIT

AUTOCOMMIT OFF (2137), (3085)

AUTOCOMMIT ON (2129), (3084)

CANCEL command (2030), (2131), (2155)

LIST command (3004)

SET command (2363), (3083)

automatically committing data (2146), (3087)

BACKOUT (2790)

BACKWARD (2074), (2794), (3220)

before starting ISQL (1955)

beginning a DB2 Server for VSE & VM session (1961)

beginning a DB2/VM session (1949)

BLANKS

SET command (2366)

bottom title for printed report (2294), (2861)

BTITLE

FORMAT command (2296), (2858)

calculated

column heading (2245)

CANCEL command

command in progress (2019)

description (2132)

locked data (2713)

reference (2802)

cancelling a command in progress (2803)

CASE keyword

LIST command (3005)

SET command (3090)

catalog

read and update access (3140)

catalog table

isolation level setting (2734)

SYSCHARSETS (3093)

using (2544)

CHANGE command

current statement (2183), (2195), (2425)

reference (2807)

stored statement (2438)

changing

current SQL statement (2180), (2808)

decimal places displayed for a numeric column (2869)

displayed

column heading (2239), (2871)

length attribute of a column (2254)

width of a column (2874)

number of decimal places displayed (2248)

separation displayed between columns (2223), (2333), (2903)

stored SQL statement (2441)

choose

in syntax diagrams (1891)

CL_SCHED sample table (3212)

CLASS keyword

LIST command (3006)

PRINT command (3025)

SET command (3094)

clause

FROM (2961)

GROUP BY (2965)

HAVING (2970)

ORDER BY (2974)

SELECT (2947)

WHERE

SELECT statement (2963)

CMS

commands

use of (2768)

subset mode (2770)

entering (2771)

leaving (2772)

CMS subset (2769)

coded character set identifier (CCSID)

description (2559)

column

adding to a table (2589)

command (2093)

description (1911)

displayed

decimal place, changing (2250), (2868)

heading, changing (2243), (2870)

length attribute, changing (2255)

width, changing (2873)

displaying more than 45 columns (2954)

excluding from a display (2230), (2881)

FORMAT command (2247)

heading See also column, name

calculated values (2244)

including

excluded columns (2235), (2894)

keyword in FORMAT command (2260)

leading zeros (2877)

name

changing (2242)

creating (2555)

order of display (2959)

selecting

expression (2957)

more than 45 columns (2955)

specific column (2053)

separator

setting for a session (2336), (3157)

setting for current query result (2226), (2901)

variable character

setting width displayed for a session (3160)

setting width displayed for current query result (2909)

COLUMN

COLUMN command (2813)

COLUMN option of FORMAT command

changing heading (2300), (2872)

changing width (2263)

reference (2866)

command

CMS (2766)

correcting typing error

description (2012)

IGNORE command (2199)

START command (2167)

CP (control program)

SPOOL (2782)

TAG (2781)

DISPLAY (2527)

entering

description (1980)

while executing another command (1997)

while processing routine (2000)

while viewing query result (1999)

erasing one previously stored (2840)

ISQL

CANCEL (2024)

CHANGE (2184), (2439)

description (1919), (1921)

END (2109)

ERASE (2467), (2473)

HELP (2035), (2043)

HOLD (2206)

IGNORE (2198)

LIST (2368), (2445), (2454)

RECALL (2421)

RENAME (2461)

RUN (2506)

SET (2136), (2150), (2152), (2360)

START (2412)

STORE (2391)

ISQL display

BACKWARD (2077), (2795)

COLUMN (2096), (2814)

DISPLAY (2822)

END (2110), (2835)

FORMAT (2217), (2315), (2850)

FORWARD (2069), (2911)

LEFT (2090), (2986)

PRINT (2115), (3019)

RIGHT (2084), (3059)

TAB (2100), (3188)

listing a stored SQL statement (3000)

maximum length (2010)

preventing immediate processing (2927)

protecting existing stored (2401)

recalling a stored SQL statement (3046)

renaming stored SQL statement (3057)

reusing (2178), (2191)

SQL

ALTER TABLE (2592)

changing (2182)

COMMENT (2547)

COMMIT (2141)

CREATE INDEX (2700)

CREATE SYNONYM (2683)

CREATE TABLE (2558), (2586)

DROP INDEX (2705)

DROP SYNONYM (2686)

DROP TABLE (2579)

GRANT (2648)

INSERT (2571)

placeholder (2212)

preventing immediate processing (2208)

previous (2399), (2427)

recalling (2433)

reusing (2158)

ROLLBACK (2145)

SELECT (2056)

starting stored statement (2408)

storing (2394)

UPDATE STATISTICS (2708)

stacking (1998)

typing (2924)

command buffer

how used (2159)

COMMENT (2546)

COMMIT

using (2139)

committing

changes

automatically (2148)

logical units of work (2138)

data

automatically (3086)

continuation character

setting (3099)

using (2008)

CONTINUATION keyword

LIST command (3007)

SET command (3098)

controlling

changes to your table (2128)

display of data

description (1922)

larger than one display (2065), (2101)

report format (2219), (2342)

query format characteristics (2318)

conventions

highlighting in this book (1898)

syntax diagram notation (1883)

Conversational Monitor System (CMS) See CMS

COPIES keyword

in a SET command (2346)

PRINT command (2125), (3028)

SET command (3101)

copy

data from one table to another (2566)

of printed reports (2344), (3104)

printed report (2124), (3031)

specifying (2784)

correcting typing error

CHANGE command (2186)

IGNORE command (2201)

RETRIEVE facility (2169)

COST ESTIMATE (2058)

COSTEST keyword

SET command (3106)

COUNTER (2818)

commands (2767)

entering (2775)

SPOOL (2780)

TAG (2779)

CREATE INDEX (2488), (2698)

CREATE SYNONYM (2681)

CREATE TABLE statement

dbspace (2565)

effect on stored query (2639)

example (2556)

NOT NULL option (2584)

public dbspace (2671)

share (2670)

creating

foreign key (2608)

index (2697)

primary key (2597)

referential constraint (2609)

referential structure (2607)

report from query results (2270), (2854)

routine (2476), (2492)

ROUTINE table (2487)

synonym (2680)

table (2553), (2664)

current SQL statement

changing (2181), (2810)

description (2157)

displaying (2429), (3050)

reentering (2156)

starting

placeholder in statement (2211)

START command (2161), (3173)

storing (2389), (3182)

cursor

movement key (1987), (1993)

cursor stability

guidelines for using (2726)

isolation level (2720), (3117)

SET command (3128), (3135)

database administrator (DBA) See DBA (database administrator)

DB2 Server for VSE & VM system See also SQL

description (1899)

display terminal (1928)

session (1936)

signing on (1964)

DBA (database administrator)

authority (1943), (1945), (2533)

dbspace

locking (2740)

private

description (2667)

isolation level repeatable read (3125)

setting isolation level (2736)

storing table (2560)

public

description (2669)

isolation level cursor stability (3130)

isolation level repeatable read (3124)

isolation level uncommitted read (3137)

setting isolation level (2717), (2738)

storing table (2563)

deactivating

foreign key (2632)

primary key (2631)

unique constraint (2633)

decimal

separator (3112)

specifying number of places to display (2867)

DECIMAL keyword

LIST command (3009)

SET command (2329), (3109)

decimal place

changing the number displayed (2249)

decimal separator (2326)

default

in syntax diagrams (1893)

DELETE statement

isolation level setting (2757), (2761)

deleting

data in a routine (2499)

indexes (2703)

portions of an SQL statement (2194), (2812)

synonym (2687)

table (2575)

DEPARTMENT sample table (3198)

DESTID keyword (3033)

DESTINATION (in PRINT command) (2383)

determining

name of column in a table (2551)

name of table or view (2542)

display (1981)

clearing (1989), (2011)

ISQLTRACE command (2984)

DISPLAY command (2526), (2820)

display commands

BACKWARD (2076), (2797)

COLUMN (2095), (2816)

definition (2061)

DISPLAY (2528)

END (2111), (2836)

FORMAT (2268), (2272), (2313), (2852)

FORWARD (2068), (2913)

LEFT (2089), (2988)

PRINT (2114), (3021)

RIGHT (2083), (3061)

TAB (2099), (3190)

display format information

storing (2387), (3185)

display mode (2006), (2176)

display screen

format (1982)

VM (1984)

display terminal (1929)

large display support (1904)

support (1932), (1933)

displayed column

heading (name)

changing (2240)

length, changing (2258)

displaying

current SQL statement (2430), (3049)

more than 45 columns (2953)

name

column in table (2549)

table (2535)

operational characteristics (2996)

query format characteristics (2319)

query result

21 or more rows (2064)

description (2062), (2102)

from a routine (2524), (2821)

LEFT command (2992)

RIGHT command (3065)

too long for the display (2801), (2917)

too wide for the display (2080)

stored SQL statement

LIST command (2448), (2997)

RECALL command (2431)

width for variable character field (2906), (3161)

DISTINCT

reference (2950)

DPLACES (FORMAT command)

description (2251)

multiple keyword (2265), (2302)

DRDA protocol

CONNECT (1927)

SQLQRY (2026)

DROP INDEX statement (2701)

DROP SYNONYM statement (2684)

DROP TABLE statement

description (2577)

DROP SYNONYM statement (2691)

effect on stored query (2640)

DROP VIEW statement (2692)

DUMP keyword (2983)

duplicate

rows

preventing selection (2952)

EMP_ACT sample table (3208)

EMPLOYEE sample table (3200)

END

PF key (3217)

query (2106)

reference (2825)

ending

INPUT (2827)

logical unit of work (2142)

operator command (2828)

query result

END command (2104), (2826)

entering

commands (1979)

description (1983)

multiple input lines (2009)

while viewing online help information (2040)

CP commands (2774)

data in a table

INPUT command (2939)

introduction (1925)

your user ID and password (1965)

ERASE command (2466)

ERASE keyword

FORMAT command (2285), (2292)

ERASE statement (2472), (2838)

erasing

duplicate values in report (2275)

more than one stored command (2469)

stored SQL statement (2464), (2837)

error mode processing (2514)

errors See also correcting typing error

multi-row operations (2153)

routine (2516), (3152)

SQL statements (1973), (1978)

estimating resource usage (3108)

example

starting a DB2 Server for VSE & VM terminal session (1937)

EXCLUDE keyword (FORMAT command)

description (2231)

example (2232)

multiple keywords (2304)

reference (2878)

excluded columns

including (2237), (2893)

excluding column from the display (2228), (2879)

EXEC

example (2788)

using (2786)

EXIT command (2047), (2844)

EXPLAIN option, setting isolation level (2735)

expression

in a select statement (2956)

final totals (2278), (2890)

finding names

column in table (2552)

table (2543)

foreign key

activating (2624)

adding (2617)

creating (2610)

creating a referential constraint (2611)

deactivating (2625)

privilege required (2595)

FORMAT (2221), (2312), (2849)

format information for a display

changed because of table change (2638)

saving (2434), (2442)

stored SQL statement (2450)

storing (2388), (2436)

formatting

report from a query result (2271), (2317), (2853)

FORWARD command

description (2066)

PF key (3221)

reference (2910)

fragment of syntax

in syntax diagrams (1896)

FROM clause

SELECT statement (2960)

FULLSCREEN (1954)

GRANT (2646)

grant privileges

table (2649)

group

search condition (2972)

GROUP BY clause

SELECT statement (2964)

GROUP option of FORMAT command

multiple keywords (2305)

outline report (2273)

reference (2882)

total (2282)

grouped query result (2966)

grouping

subtotal (2283), (2884)

guidelines

cursor stability isolation level (2727)

repeatable read isolation level (2755)

uncommitted read isolation level (2724)

HAVING clause

reference (2969)

heading for column See name, column

HELP

alternate language (2038), (2356)

command

isolation level setting (2750)

information viewing

setting isolation level (2731)

isolation level setting (2733)

online (2034)

PF keys (3215)

reference (2918)

typing command (2042)

HOLD command

description (2205)

PF9 (3222)

reference (2925)

host variable

in syntax diagrams (1885)

IGNORE command

example (2016)

reference (2930)

SQL line (2196)

usage (2015)

improving query performance (2693)

in-progress command, canceling (2027)

IN_TRAY sample table (3210)

INCLUDE keyword (FORMAT command) (2236), (2892)

including excluded columns in a display (2234), (2891)

indexing

table (2695)

input area (1986), (1992)

INPUT command

data in a table (2934)

inputting

ending (2830)

isolation level setting (2752)

nullifying input (2793)

routine (2522)

saving a portion of input (3077)

INSERT

data from another table (2569)

isolation level setting (2751), (2758)

interactive SELECT statement (2942)

Interactive Structured Query Language (ISQL) See ISQL

ISOLATION keyword

LIST command (3003)

SET command (3116)

isolation level

cursor stability

guidelines (2728)

description (3121)

locking data (2712)

repeatable read

guidelines (2756)

specifying (2716), (3122)

uncommitted read

guidelines (2725)

ISQL

commands

BACKOUT (2791)

CANCEL (2023), (2804)

CHANGE (2185), (2809)

description (1918), (1920)

END (2108), (2833)

ERASE (2468), (2474), (2843)

EXIT (2048), (2848)

HELP (2036), (2044), (2922)

HOLD (2207), (2929)

IGNORE (2197), (2933)

INPUT (2938)

ISQLTRACE (2980)

LIST (2455), (3002)

LIST SET (2367)

LIST SQL (2446)

RECALL (2422), (3048)

RENAME (2462), (3056)

RUN (2507), (3070)

SAVE (3075)

SET (2135), (2151), (2359), (3080)

START (2413), (3168)

STORE (2392), (3180)

description (1917)

DISPLAY (2529)

display commands

BACKWARD (2075), (2796)

COLUMN (2094), (2815)

description (2060)

DISPLAY (2823)

END (2107), (2834)

FORMAT (2218), (2314), (2851)

FORWARD (2067), (2912)

LEFT (2088), (2987)

PRINT (2116), (3020)

RIGHT (2082), (3060)

TAB (2098), (3189)

END (2832)

ERASE (2842)

EXIT (2049), (2847)

HELP (2921)

HOLD (2928)

IGNORE (2017), (2932)

INPUT (2937)

isolation level setting (2747)

ISQLTRACE (2979)

leaving from signon display (1966)

LIST (3001)

mode (2003)

display (2005)

wait (2004)

RECALL (3047)

RENAME (3055)

RUN (3069)

SAVE (3074)

SET (3079)

START (3167)

starting (1953), (1958), (1970)

stopping (2046), (2845)

STORE (3179)

transaction identifier (2482)

ISQL EXEC (1971), (2481)

ISQL session manager (1950)

ISQLTRACE (2978)

key

foreign

adding (2618)

creating (2613)

primary

adding (2604)

creating (2599)

keyboard, unlocked (1996)

keyword

in syntax diagrams (1884)

using more than one

ERASE command (2471)

FORMAT command (2261), (2298)

LIST command (2457), (3017)

PRINT command (2127), (3042)

SET command (2358), (3163)

language for message and HELP text (2355)

large display support (1905)

leading zeros

controlling (2252), (2876)

LEFT command

example (2087)

PF key (3223)

reference (2985)

LENGTH (SET command) (2353)

length attribute of column

changing (2256)

limiting

privilege by using a view (2656), (2661)

LIST

examples (2453)

obtaining printed reports (2378)

reference (2993)

setting more than one characteristic (2361)

listing

format characteristics (2369)

more than one stored command (2451)

name

column in table (2550)

stored SQL statement (2444)

table (2536)

view (2537)

operational characteristics (2995)

stored SQL statement (2994)

locking

data (2710)

isolation level (2711), (3120)

logical unit of work (LUW) See LUW (logical unit of work)

long-running commands, canceling (2029)

lowercase characters

input (2188), (3091)

LUW (logical unit of work)

AUTOCOMMIT setting (2130), (2154)

canceling (2022)

managing your own table (2534)

master profile routine (2480)

message

alternate language (2357)

description (1968), (1972)

ISQL status (1995)

minimum

content of a table (2581)

mode

display (2002), (2174)

wait (2001), (2173)

modifying the separation between columns (2222), (2332)

more than one keyword with FORMAT command (2299)

moving

data with INSERT command (2573)

through a query result

backward (2078), (2798)

forward (2070), (2915)

left (2091), (2989)

right (2085), (3062)

multiple language HELP text (2037)

name

column

changing display (2241)

description (1912)

table (1915)

NAME option of FORMAT command

description (2246)

using several keywords (2264), (2301)

NOT NULL option (2580)

NULL option

FORMAT command (2311), (2895)

LIST command (3008)

SET command (2364)

description (2341)

displayed character (2340)

reference (3141)

null value

controlling what is displayed (2309), (2338)

for added column (2593)

formatting field (2310)

formatting with null field (2308)

found in grouped column (2968)

preventing occurrences of in a table (2583)

setting characters displayed

query result (2896)

terminal session (2339), (3142)

nullifying input

BACKOUT (2792)

IGNORE (2931)

numeric

field punctuation (2324)

omitting column from a display (2229), (2880)

online

reference information

HELP command (2919)

HELP text (2031)

introduction (1926)

setting isolation level (2732)

ONLY option

FORMAT command (2238)

operational characteristic

listing (2372), (2998)

setting (3082)

operational characteristics See query format characteristics

operator commands

COUNTER (2819)

ending (2831), (2841)

SHOW (3165)

optional

default parameter

in syntax diagrams (1895)

item

in syntax diagrams (1890)

keyword

in syntax diagrams (1894)

ORDER BY clause (2973)

ordering

columns of a query result (2958)

rows of a query result (2976)

OUTLINE keyword (2898)

outlining

columns (2883)

controlling (2899)

report (2274)

output area

correcting line (2168)

description (1990), (1994)

output class

for printed reports (3026)

setting for a session (3096)

owner of table (2643)

PA1 key (2776)

page

locking (3132), (3139)

size of printed report (3145)

PAGESIZE keyword

LIST command (3010)

SET command (2351), (3144)

parameter

RUN command (3071)

START command

description (2216)

example (2416)

reference (3175)

parentheses

in syntax diagrams (1887)

password (1942)

performance, query (2694)

PF key

description (1934)

FULLSCREEN (3226)

resetting (3227)

summary (3214)

template (1935)

using (2789), (3193)

PF keys (3213)

PF1 key (2039)

PF10 key (2092)

PF11 key (2086)

PF12 key (2172)

PF2 key (2165)

PF4 key (2118)

PF7 key (2079)

PF8 key (2072)

PF9 key (2210)

placeholder See also variable

profile routine (2479)

routine (2493)

RUN command (3072)

START command (3176)

used in

current SQL statement (2213)

routine (2502)

stored SQL statement (2415)

preventing

selection of duplicate row (2951)

SQL statement from being processed (2209), (2926)

previous SQL statement

recalling (2424), (2428), (3051)

storing restriction (2397)

primary key

activating (2622)

adding (2601)

creating (2598)

deactivating (2623)

privilege required (2594)

PRINT (2113), (3018), (3218)

print characteristics (2778)

printed reports

bottom title (2293), (2859)

date (2120), (3040)

introduction (1923)

multiple copies

CP SPOOL command (2785)

PRINT command (2123), (3030)

page number (2119), (3038)

page size, specifying (3147)

printing (1924), (3022)

remote printer (2783)

routine (3035)

routing (2377), (3037), (3150)

routing to alternate printer (2777)

SET command (2345), (3105)

top title

example (2290)

TTITLE option of FORMAT command (2865)

PRINTROUTE keyword

LIST command (3011)

SET command (3149)

private dbspace

description (2666)

isolation level repeatable read (3127)

setting isolation level (2737)

storing table (2561)

privilege

restricting

specific column (2657)

specific row (2650)

processing

current SQL statement (2162), (3172)

routine (2508)

stored SQL statement (3170)

profile routine (2477)

Program Function key (PF key) See PF key

PROJ_ACT sample table (3206)

PROJECT sample table (3202)

protecting

existing stored commands (2400), (2404)

public dbspace

creating tables in (2668)

isolation level

cursor stability (3129)

repeatable read (3126)

uncommitted read (3136)

setting isolation level (2718), (2739)

storing tables in (2562)

punctuation

for display of a numeric column (2321), (3110)

punctuation mark

in syntax diagrams (1886)

QCE (Query Cost Estimate)

description (2059)

how to display (3107)

query

description (1901), (2050)

terminal settings (2944)

Query Cost Estimate (QCE) See QCE (Query Cost Estimate)

query format characteristics

listing (2370)

setting (2320), (2362)

query result

displaying (2063), (2103)

ending (2105), (2829)

formatting (2220), (2375), (2855)

grouping rows (2967)

moving

backward (2800)

display to a particular column (2817)

forward (2914)

left (2991)

right (3064)

ordering rows

ORDER BY clause (2977)

printing (2117), (3023)

viewing columns too wide for the display (3192)

RECALL command

description (2420)

PF5 (3219)

reference (3043)

recalling a stored SQL statement

description (2418)

isolation level (2742)

RECALL command (3044)

reference information

online (2032), (2920)

reference material

sample tables (3195)

tables, example, DB2 Server for VSE & VM (3196)

RENAME command (2460), (3052)

renaming

stored SQL statement (2458), (3053)

repeat symbol

in syntax diagrams (1892)

repeatable read

guidelines (2754)

isolation level (2719), (3118)

SET command (3123)

REPLACE keyword

introduction (2405)

message (2406)

reference (3183)

saving format information (2437)

report

formatting (2269), (2316), (2856)

isolation level setting (2729)

formal reports (2763)

obtaining multiple copies (2126), (2347)

page size (2350)

printed

bottom title (2295), (2860)

date (2122), (3041)

page number (2121), (3039)

page size (2349), (3146)

setting output class (3095)

setting output class for a particular report (3027)

setting the number of copies (3103)

setting the number of copies for a particular report (3029)

top title (2291), (2864)

printing (2112), (3024)

required item

in syntax diagrams (1889)

reserved words

SQL (1897)

resource authority (2532), (2564)

restricting

privilege by using a view (2654), (2660)

RETRIEVE facility

CHANGE command (2193)

description (2166)

introduction (2018)

PF12 (2179), (3225)

retrieving

data (2051)

RETURN (2773)

RIGHT command

example (2081)

PF11 (3224)

reference (3058)

ROLLBACK

use of (2133), (2143)

rolling back

changes (2134), (2805)

routine

creating (2491)

description (2475)

DISPLAY commands (2530)

displaying query result (2824)

entering data into table (2494)

error mode processing (2515), (3153)

INPUT command (2521)

profile (2478)

running (2500), (3068)

SELECT statements (2525)

setting isolation level (2745)

sharing (2510)

storing (2490)

table (2483)

updating (2496)

where they are stored (2485)

ROUTINE table (2486)

routing

printed output

to POWER remote workstation (2381)

to terminal (2379)

printed reports (2376)

row

description (1909)

granting privilege (2653)

inserting

data from another table (2572)

locking (3131), (3138)

ordering for display

ORDER BY clause (2975)

selecting (2945)

RUN command

description (2505), (3066)

example (2504)

isolation level setting (2748)

RUNMODE keyword

LIST command (2519), (3012)

SET command (2517), (3151)

running

routines

description (2501)

isolation level (2746)

RUN command (3067)

sample table

ACTIVITY (3203)

CL_SCHED (3211)

DEPARTMENT (3197)

EMP_ACT (3207)

EMPLOYEE (3199)

IN_TRAY (3209)

PROJ_ACT (3205)

PROJECT (3201)

SAVE command (3073)

saving format information

CHANGE (2811)

reference (2948)

START (3177)

STORE (2435), (3186)

saving input

on an INPUT command (3076)

saving SQL statements See stored SQL statements

scrolling through a query result

backward (2799)

description (2071), (2073)

forward (2916)

left (2990)

right (3063)

search condition

group (2971)

SELECT privilege

routine (2511)

SELECT statement (2941)

data and isolation level setting (2730), (2753)

isolation level setting (2760)

online reference information (2923)

routine (2523)

using (2054)

selecting

column (2052)

data from

another user's table or view (2674)

data from a table (2943)

online help information (2033)

typing a command while viewing a HELP display (2041)

separation between columns, modifying (2224), (2334)

separator

column

character displayed (2335)

modify (2227)

setting for a session (3155)

setting for current query result (2902)

decimal (2328), (3114)

thousands (2327), (3115)

SEPARATOR keyword

FORMAT command

description (2225)

multiple keywords (2262), (2303)

reference (2900)

STORE (2396)

LIST command (2373), (3013)

SET command

character displayed (2331)

example (2365)

reference (3154)

session

DB2 Server for VSE & VM terminal

definition (1938)

starting (1939), (1960)

DB2/VM terminal

starting (1948)

session manager

support (1951)

SET

isolation level (2722), (3119)

LIST command (2371), (2520)

SET command

AUTOCOMMIT option (2149)

description (2323), (2374)

reference (3078)

SET keyword of LIST command (3016)

setting

autocommit of changes to tables (2147)

autocommit of data (3088)

characters displayed

FORMAT command (2904)

FORMAT NULL command (2897)

SET command (2330), (3156)

SET NULL command (2337), (3143)

continuation character (3100)

displayed width for variable character field (2907)

language for message and HELP text (2354)

number of copies for printed reports (2343), (3102)

operational characteristics (3081)

output class for printed reports (3097)

page size for printed report (2348)

punctuation displayed for numeric column (2322), (3111)

routing printed output

to POWER remote workstation (2382)

to terminal (2380)

RUNMODE option (2518)

uppercase input (3092)

sharing

routines (2509)

table with another user (2641), (2662)

SHOW (3164)

signing on

to ISQL (1963)

to ISQL from another CICS task (3229)

signon screen

description (1962)

suppressing (3228)

size

printed page for reports (3148)

SQL

command buffer (2160)

command line buffer (2171), (2192)

description (1900)

keyword

LIST command (2449), (3015)

statements

ALTER TABLE (2591)

COMMENT (2548)

COMMIT (2140)

CREATE INDEX (2699)

CREATE SYNONYM (2682)

CREATE TABLE (2557), (2585)

current (2393), (2432)

DROP INDEX (2704)

DROP SYNONYM (2685)

DROP TABLE (2578)

GRANT (2647)

INSERT (2570)

listing more than one stored (2456)

listing those previously stored (2447)

preventing immediate processing (2204)

previous (2398), (2426)

recalling one previously stored (2423)

renaming one previously stored (2463)

replacing (2403)

ROLLBACK (2144)

SELECT (2055)

starting stored statement (2407)

UPDATE STATISTICS (2707)

SQLCODE (1977)

SQLINIT EXEC (1956)

SQLQRY (2025)

stacking SQL and ISQL commands (2787)

START command

correcting errors (2189)

description (2164)

isolation level setting (2749)

no parameter (2411)

parameter (2215)

PF key (3216)

reference (3166)

starting

current SQL statement (2163), (3171)

ISQL (1931), (1952), (1957), (1969)

stored queries and isolation level setting (2744)

stored SQL statement (2409), (3169)

statistics (2706)

status

area (1985), (1991)

stopping

ISQL (2045), (2846)

logical units of work (2021)

running command (2020)

STORE command (2390), (3178)

stored SQL statements

changing (2440)

effect of table changes (2637)

erasing (2465), (2470), (2839)

isolation level setting (2741)

listing (2443), (2452), (2999)

protecting (2402)

recalling (2419), (3045)

renaming (2459), (3054)

routine (2512)

starting (2410), (2417), (3174)

storing

current SQL statement (2395), (3181)

display format information (2386), (3184)

isolation level setting (2743)

routine (2489)

Structured Query Language (SQL) See SQL

subquery

CREATE VIEW command (2655)

INSERT command (2574)

subtotal

creating (2281)

report (2280)

specifying when to subtotal (2885)

specifying which columns to subtotal (2887)

SUBTOTAL keyword (FORMAT command)

multiple keyword (2306)

reference (2886)

report total (2279), (2287)

synonym

creating (2679)

dropping (2688)

routine (2513)

syntax diagram

notation conventions (1882)

SYSTEM

(in PRINT command) (2384)

(in SET command) (2385)

keyword (3034)

TAB (2097), (3187)

table

accessing those belonging to other users (2673)

adding

column (2588)

data (2936)

foreign key (2614)

primary key (2602)

referential constraint (2615)

altering (2603), (2616)

column (1910)

copying data from another table (2567)

creating

description (2554)

foreign key (2612)

primary key (2600)

share (2665)

deleting (2576)

description (1906)

determining name (2540)

example (1907)

index

creating (2696)

dropping (2702)

listing name (2539)

minimum content (2582)

naming conventions (1916)

owner (2642)

ROUTINE

creating (2484)

entering data (2495)

row (1908)

selecting data (2946)

sharing with another user (2644), (2663)

synonym

creating (2677)

dropping (2689)

trace (2982)

using another user's (2676)

value (1913)

TERMID keyword (3032)

terminal

display (1903), (1930)

session (1940)

starting ISQL (1947), (1959)

thousands separator (2325), (3113)

title for printed report (2288), (2857), (2863)

total, final (2889)

total for report

erasing (2286)

TOTAL keyword (2276)

TOTAL option of FORMAT command

create total (2277)

erasing (2284)

reference (2888)

TOUSER keyword (3036)

tracing (2981)

TTITLE option of FORMAT command

creating top title (2289)

example (2297)

reference (2862)

typing errors

CHANGE (2187)

correcting (2014)

IGNORE (2013), (2200)

RETRIEVE (2170)

uncommitted read

guidelines for using (2723)

isolation level (2721), (3133)

SET command (3134)

unique constraint

activating (2626)

deactivating (2627)

privilege required (2596)

UPDATE statement

isolation level setting (2759), (2762)

UPDATE STATISTICS statement (2709)

updating

routine (2497), (2498)

uppercase characters, input (3089)

user ID

for ISQL session (1941)

USER special register (2545)

value

description (1914)

VARCHAR keyword

FORMAT command (2905)

LIST command (3014)

SET command (3158)

variable See also placeholder

current SQL statement (2214)

routines (2503)

stored SQL statements (2414)

variable character column

current query result (2908)

session (3159)

view

determining name (2541)

listing name (2538)

privilege, restricting (2652), (2659)

restricting privilege (2651), (2658)

synonym

creating (2678)

dropping (2690)

using another user's (2675)

viewing columns too wide for the display (3191)

commands (2765)

functions (2764)

wait mode (2007), (2175)

WHERE clause

SELECT statement (2962)

width displayed

changing

any column (2257), (2875)

VARCHAR columns (3162)

WIDTH option

FORMAT command (2259), (2267)

SET command (2352)

ZEROS option of FORMAT command (2253), (2266)

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