Using QMF

Index

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

Special Characters

&variable parameter (4272)

access
- current location name (3887)
- OS/390 editor from QMF (4085)
- QMF from a VM editor (4078)
- QMF with document interface (4077), (4084)
- remote data (3899)
accessing data, methods of (3028)
add
- break heading/footing (3569)
- break segments and text (3566)
- columns (3817), (4180)
- conditions
  - in a CONDITIONS box (4213)
  - to an example table (4201)
  - using AND (4358)
- data to long fields (3785)
- date, time, page number to report (3559)
- dates and times (3431)
- dates/times (3424)
- expressions (4214)
- information to queries (3237)
- lines to a query (3309)
- new column to report (3490)
- page heading/footing to report (3536)
- rows (3800), (4455)
  - I (insert) (4456)
- subtotals to report (3528)
- target tables (4227)
addition of dates and times (3430)
administrator, QMF (3058)
alias
- deleting (3773)
- for table (3768)
- for view (3769)
alias, in place of three-part name (3902)
ALL keyword (4352)
- QBE (4353)
AND keyword (4361)
- QBE (4362)
AO keyword (4379)
application requester (3873), (3881), (3930)
application server (3919), (3931)
arithmetic (4179), (4621)
- expressions (4622)
- overflow (4178)
ascending order, sorting sequence (3176), (4371)
ASIS formatting type (4054)
asterisk (*), placement of cursor (4334), (4344)
authorization
- granting on table (3823)
- revoking on table (3831)
- to use objects (3053)
automatic interrupt (3225)
AVG column function (4389)
AVG column function in SQL (3342)
AVG keyword (4390)

BAR chart format (3617)
batch mode
- procedures
  - errors (3711), (3712)
  - example for MVS (3703)
  - example for VM (3701)
  - restrictions (3697)
  - termination (3713)
  - using IMPORT/EXPORT commands (3705)
  - using the QMF EXIT command (3707)
  - writing (3696)
BETWEEN keyword (4400)
- QBE (4401)
bilingual command (3946)
BLOB (3818)
break segments, adding to reports (3565)
break text, adding to reports (3568)

calculated values
- average (4385)
- columns of expressions (4186), (4633)
- count (4404)
- displaying on reports (3586)
- for groups (4448)
- maximum (4498)
- minimum (4505)
- of expressions (4634)
- total (4574)
CANCEL command (3213)
canceling a command or query (3212)
case operand for Prompted Query (3142)
changing
- appearance of a report (3108)
- column names in queries (3245)
- date/time values using scalar functions (3377)
- default chart format (3646)
- information in queries (3242)
- row conditions in queries (3244)
- rows (4586)
  - U operator (4587)
- saved query (3227)
- sort order in queries (3243)
- table names in queries (3246)
CHAR
- scalar function (3386)
CHAR scalar function (3385)
character
- constants (4193)
- data
  - in conditions (4177)
  - in descriptive columns (4195)
  - with LIKE (4477)
CHART database object (3049)
charts (3644)
- changing
  - data, using QMF forms (3638)
  - formats, using the ICU (3640)
  - properties, using the ICU (3639)
- creating (3612), (3651)
- default type (3637)
- fixing problems (3647)
- format
  - changing (3641)
  - creating (3615)
  - saving (3642)
- formats, QMF (3614), (3616)
- location of data
  - on pie charts (3632)
  - on the X-axis (3630)
  - rules for specifying (3626)
- printing (3650)
- size limits for data (3633)
- specifying type (3636)
- ways to display data (3613)
CHECK command (3601)
CICS
- and remote unit of work (3917)
- restrictions
  - calculated values in reports (3583)
  - document interface (4043)
  - external editors (4012)
  - procedures with logic (3915)
  - QMF BATCH command (3694)
  - viewing data in tables (3829)
CLIST
- used with editor (4004)
CLIST used with editor (4003)
CLOB (3819)
CMS
- exporting objects into (3837)
- importing objects from (3850)
- note facility (4037)
- NOTE facility (4036), (4071)
- used with QMF document interface (4038)
- XEDIT (4072)
codes
- edit (3513), (3516)
- usage (3524)
column
- functions
  - AVG (3343), (4388)
  - COUNT (3354), (4409)
  - MAX (3346), (4501)
  - MIN (3348), (4508)
  - SUM (3351), (4577)
column functions (3339), (3355), (4384), (4403), (4497) , (4504), (4573), (4578)
column names
- changing
  - in queries (3251)
- distinguishing between
  - using correlation names (3325)
  - using qualifiers (3323)
- finding (3274)
columns
- adding to reports (3489)
- changing
  - alignment of headings and data, on reports (3505)
  - column spacing (3500), (3501)
  - headings, on reports (3498)
  - on reports (3477)
  - order, on reports (3496)
  - spacing, on reports (3503)
  - widths, on reports (3502)
- column functions (3419)
- creating (3278)
- creating empty (4181)
- edit codes in (3515)
- expressions (4624), (4630)
- fixed, on reports (3541)
- functions
  - nesting within scalar functions (3420)
- joining (3315)
  - in Prompted Query (3183)
  - multiple (3192), (3318)
- names (4183)
- punctuating (3514)
- select
  - using P. (4129), (4555)
- selecting (3268), (4128), (4554)
- specifying, on reports (3542)
- unnamed (4182)
- with calculated values (4623)
command (3075)
- CANCEL (3215)
- CHECK (3602)
- CONNECT
  - compared to the DSQSDBNM parameter (3863)
  - from the command line (3858)
  - prompt panels for (3871)
  - user ID (3928)
- CONVERT (4292)
  - QBE to SQL (4293)
- DBCS data (3974)
- DELETE (4300)
  - using QBE (4301)
- DISPLAY (4258)
  - using QBE (4259)
- DRAW (3802), (4235), (4313)
  - using QBE (4236), (4314)
- EDIT (4021), (4022)
- ENLARGE (4328)
- FORM.COLUMNS (3486)
- governor interrupt (3216)
- how to issue (3076)
- interrupt (3214)
- LAYOUT (3544)
- line (3738)
  - global variables (3737)
- LIST (4106)
  - under QBE (4107)
- QBE-specific (4284)
- REDUCE (4336)
- RUN (4270)
  - substitution variables (4271)
- SHOW FORM (3483)
command line (3071)
comment
- in QBE query (4308), (4347)
COMMENTS box (4307), (4346)
concatenation, rules for (3448)
conditions
- character data in (4175)
- data types in (4209)
- DBCS characters (4211)
- grouping (3299)
- in a CONDITIONS box (4215)
- in an example table (4208)
- multiple
  - AND (3295), (4365)
  - BETWEEN (4393)
  - IN (3301)
  - in Prompted Query (3173)
  - OR (3297), (4541)
- negative (4518)
- opposite (3290)
- quotation marks in (4174)
- row (3288)
- selection symbols in (3292)
- special characters in (4210)
- two on one row (4370)
- values in a set (4474)
- with equalities (4641)
- with example elements (4148)
- with expressions (4225)
- with inequalities (4642)
- writing (4142), (4155)
CONDITIONS box (4218), (4312), (4341)
- deleting (4311)
- drawing (4326)
- reducing (4340)
- restricting data presentation (4217)
CONNECT command
- compared to the DSQSDBNM parameter (3862)
- from the command line (3857)
- prompt panels for (3870)
- user ID (3927)
connecting
- from DB2 to DB2 (3933)
- from DB2 to SQL/DS (3937)
- from SQL/DS to SQL/DS (3935)
- general considerations (3861)
- QMF CONNECT command prompt panel (3869)
- to database from QMF with remote unit of work (3877)
- using QMF CONNECT command (3856)
- with remote unit of work (3859), (3860), (3868)
constants (4192)
conversion functions
- scalar (3364)
conversion scalar functions (3363)
CONVERT command (4294)
- QBE to SQL (4295)
converting
- QBE to SQL (4289)
converting queries to SQL (4288)
copy tables (3759), (4427)
correcting, saved query (3228)
correlation names
- rules for (3338)
- used in a subquery (3337)
- used to distinguish between columns (3326)
COUNT
- column function (3353), (4406)
COUNT column function (3352), (4405)
counting number of values in a column (4413)
creating
- expressions (3161)
- new column in report (3162), (3279)
- reports (3109)
- reusable procedures (3669)
- row conditions (3103), (3167)
currency symbol
- changing (3520)
current location
- changing (3864)
- DSQAO_CONNECT_LOC (3891)
- procedures, forms, and queries (3922)
- QMF objects (3909)
- QMF's governor exit (3893)
CURRENT SQLID (3918), (3932)

D operator (4417)
data
- deletion (4421)
- entry (4457), (4590)
  - inserting rows (4458)
  - updating rows (4591)
- retrieval by remote unit of work (3904)
- type (4163), (4493)
DATA database object (3046)
Data Extract
- See DXT (3994)
data type
- dependencies with LIKE (4494)
- result of operation (4164)
data types
- conversion using scalar functions (3358)
- GRAPHIC (3970)
- LONG VARGRAPHIC (3972)
- valid (3967)
- VARGRAPHIC (3971)
- with DBCS (3973)
database (3944)
- enhancements (4667)
- erasing queries from (3255)
- objects, types of (3044)
- release support (4668)
- retrieving saved query from (3233)
Database Status Panel (3221)
DATE
- scalar function (3380)
DATE scalar function (3379)
date/time
- adding
  - to page headings/footings (3558)
- arithmetic, date/time (3421), (3439)
- data (3427)
- edit codes (3393)
- formats (3395)
- scalar functions (3378), (3402)
DAY scalar function (3396)
DAYS scalar function (3434)
DB2/6000 for AIX
- requirement for QMF (3012)
- specific QMF function support in (4671)
DB2 for MVS
- requirement for QMF (3011)
- specific QMF function support in (4670)
DB2 for VM
- user ID and application requester (3929)
DBCLOB (3820)
DBCS (double-byte character set)
- appearance compared to SBCS data (3960)
- changing lengths of names and fields (3963)
- description (3951), (3992)
- display from database object list (3961)
- exporting (3988)
- followed by SI delimiter (3953)
- graphic data type (4212)
- how data truncation is handled (3987)
- how incorrect data string is handled (3986)
- importing (3990)
- in forms (3984)
- in input fields (3976)
- in queries (3978)
- on non-DBCS terminals (3962)
- preceded by SO delimiter (3952)
- sorting (4383), (4435)
- with example elements (4147)
DCF (Document Composition Facility)
- formatting type (4047)
- how to insert a QMF report (4048)
DECIMAL
- SQL scalar function (3366)
DECIMAL scalar function (3365)
decrementing dates, times, or timestamps (3426)
default
- chart format, changing (3645)
- report format (3472)
- report format, changing (3474)
- report format,changing (3110)
defining
- example elements (4144)
- expressions (3163)
- new column in report (3164)
DELETE
- command
  - using QBE (4303)
DELETE command (4302)
deleting
- aliases (3777)
- COMMENTS box (4306)
- CONDITIONS box (4309)
- example table (4310)
- information from queries (3253)
- lines from a query (3310)
- query (3258), (4299)
- rows from a table (4422)
  - using QBE (4423)
- synonyms (3776)
- tables (3774)
- views (3775)
descending order, sorting sequence (3177), (4428)
detail blocks
- using panel variations to change (3573)
- using to refine report format (3571)
DIGITS scalar function (3367)
display
- form panels (3466)
DISPLAY command (4256)
- using QBE (4257)
displaying (3123)
- a list of database objects using the List key (3124)
- calculated values on reports (3585)
- correcting queries (3235)
- duplicate rows (4348)
- form panels (3467)
- QBE Query panel (4097), (4251)
- reports (3206)
- representative reports (3547)
- special conditions on reports (3589)
distributed unit of work (3025), (3939)
division sign (/) (4170)
DO keyword (4438)
Document Composition Facility (4045)
document interface (4087)
- CMS note facility (4039)
- how to insert a QMF report
  - using XEDIT (4040), (4041)
- restrictions (4076)
- using (4075)
double-byte character set (DBCS) (3950)
double byte data (3968)
DRAW command (3803), (4233), (4315), (4323)
- using QBE (4234), (4316), (4327)
Draw function key (3275)
drawing
- COMMENTS box (4324)
- CONDITIONS box (4325)
- example tables (4114), (4319)
- target tables (4228), (4321)
DSN option, GETQMF (4062)
DSQAO_CONNECT_LOC (3890)
DSQDC_COST_EST (3728)
DSQSDBNM program parameter (3865), (3880)
duplicate rows
- eliminating (4245), (4597)
duplicate rows in reports, eliminating (3185), (4244), (4596)
durations
- date/time arithmetic (3435)
- incrementing and decrementing
  - dates (3436)
  - times (3438)
  - timestamps (3440)
- making easier to read (3437)
DXT (Data Extract) (3995)
- brief description (3997)
- end user dialogs
  - EXTRACT command prompt panel (4009)
  - extract request (4008)
  - main menu (4007)
  - used within QMF (4005)
- EXTRACT command (3996)
- prerequisites (4006)

echo area, definition (3097)
edit codes
- changing (3521)
- character data (3509)
- currency symbol (3519)
- date/time (3394)
- definition (3507)
- numeric data (3510)
- percent data (3511)
- specifying punctuation for values, in report columns (3508)
- suppressing zero values (3517)
EDIT command (4020)
editing
- in CMS NOTE (4073)
- in ISPF-PDF (4064)
- in PROFS (4068)
- in PS/TSO (4070)
- QMF objects (4013), (4017)
- using CLIST (4019)
- using CLIST as editor name (4016)
- using editors with QMF (4010)
- using EXEC as editor name (4015)
- using ISPF/PDF (4014)
- using XEDIT (4018), (4063), (4069), (4074)
- within QMF
  - ISPF (4011)
eliminating duplicate rows in reports (3186), (4246), (4603)
ending QMF session (3073)
ENLARGE command (4329)
equalities (4638)
error
- messages
  - HELP command (3087)
error messages, getting help for (3086), (3088)
European format, date/time edit codes (3391)
evaluation of expressions, rules (4153)
example
- elements (4146)
- table
  - conditions in (4207)
  - deleting (4305)
  - description (4116)
  - drawing (4318)
  - enlarging (4331)
  - expressions in (4205), (4206)
  - reducing (4339)
  - restrictions on (4241)
  - with added columns (4191)
  - with example elements (4199), (4239), (4240)
  - with target table (4231)
example, database connection (3925), (3941)
example elements (4145)
example table
- conditions in (4204)
- deleting (4304)
- description (4115)
- drawing (4317)
- enlarging (4330)
- expressions in (4203)
- reducing (4338)
- restrictions on (4198), (4238)
- with added columns (4189)
- with example elements (4197), (4237)
- with target table (4230)
- with unnamed columns (4190)
exercises
- using QBE (4645)
exercises for Query-By-Example (4644)
EXPORT command
- CICS (3842)
- HTML reports (3845)
- language (3947)
- language parameter (3839)
- TSO (3835)
exporting
- DBCS data (3989)
- HTML reports (3844)
- objects
  - into CICS/VSE (3841)
  - into CMS (3838)
  - into TSO (3834)
expressions
- arithmetic (4619)
- definition (3159)
- evaluating (4154)
- in a CONDITIONS box (4216)
- in conditions (4219)
- in example tables (4202)
- numeric data in (4171)
- order of evaluating (4160)
- results with nulls (4532)
- summary functions (3160), (3165)
- use of parentheses (4161)

FILE option, GETQMF (4060)
final text, specifying on reports (3575)
FLOAT
- scalar function (3369)
FLOAT scalar function (3368)
footings
- adding
  - date, time, page number (3557)
  - to reports (3535)
- changing alignment of (3561)
- refining, on reports (3551)
- using global variables in (3555)
form
- panel
  - changing column names (4200)
FORM.BREAKn panel (3531)
FORM.CALC panel (3587)
FORM.COLUMNS panel (3485)
FORM.CONDITIONS panel (3593)
FORM database object (3047)
FORM.DETAIL panel (3572)
FORM.FINAL panel (3576)
FORM.MAIN panel (3480)
FORM.OPTIONS panel (3543)
FORM.PAGE panel (3537)
formats
- time and date functions (3388)
formats for time and date functions (3387)
formatting reports
- for document type
  - ASIS (4053)
  - DCF (4046)
  - PROFS (4050)
- using QMF forms (3464), (3611)
forms
- correcting errors on (3600)
- displaying (3465)
- resetting to default values (3605)
- saving (3603)
- using DBCS data in (3985)
- using to create reports (3463), (3610)
FORMS panels, displaying (3479)
function keys (3069), (4117), (4333), (4343)
- defined (3068)
- enlarging (4332)
- reducing (4342)
function keys (and synonyms) and remote unit of work (3920)

G keyword (4444)
G literal (3983)
GETQMF editor macro (4042)
global variable
- add (3722)
- change (3721)
- delete (3723)
- display (3720)
- list (3717), (3732)
  - and the CASE option (3735)
  - to add or remove a variable (3733), (3734)
  - to change or delete a variable (3718)
- location (3889)
- panel (3726)
- remove (3736), (3744)
- reset (3743)
- RESET GLOBAL command (3747)
- set (3714), (3719), (3742)
- SET GLOBAL command (3748)
governor interrupt routine (3223), (3894)
GRANT statement (3911)
graphic data in Prompted Query (3144)
GRAPHIC data type (3964), (3969)
graphic data with LIKE (4478), (4496)
grouping data (4441)

HEX scalar function (3370)
HISTOGRAM chart format (3623)
home panel
- starting a session (3064)
Home panel (3062), (3882), (3885)
HOUR scalar function (3399)

I keyword (4452)
I operator (4464)
ICU (Interactive Chart Utility)
- used with editor (4002)
IMPORT command (3848), (3852), (3855)
importing
- DBCS data (3991)
- objects
  - from CICS (3854)
  - from CMS (3851)
  - from TSO (3847)
IN keyword (4470)
- using in QBE (4471)
- with NOT (4519)
IN with NOT (4520)
incrementing dates, times, or timestamps (3425)
inequalities (4639)
- in conditions (4640)
information, adding or changing in queries (3236), (3241)
input fields (3977)
inserting
- a row into a table (4463)
- CMS NOTE (4031)
- GETQMF macro (4057)
- ISPF (4027)
- PROFS (4028)
- PS/TSO (4030)
- QMF report from an editor (4026)
- reports (4055), (4061)
- rows into tables (4462)
- USEQMF option (4056)
- XEDIT (4029)
INTEGER
- SQL scalar function (3372)
INTEGER SQL scalar function (3371)
interrupt
- a command or query (3217)
- by the governor (3224)
ISO format, date/time edit codes (3389)
ISPF-PDF (Interactive System Productivity Facility-Program Development Facility) (4000)
- accessing from QMF (4023)
- primary option menu panel (4024), (4025)
- supported environments (4065)
- used while in QMF (4001), (4066)

JIS format, date/time edit codes (3390)
joining
- columns
  - in Prompted Query (3182)
  - in QBE (4253)
  - in SQL (3322)
- multiple tables (3190), (3317), (4252)
- strings (3444), (3447)
- tables in Prompted Query (3179)

keys, program function (PF), on home panel (3067)
keywords (4575), (4582), (4606)
- ALL (4351)
- AND (4359)
- AO (4377)
- AVG (4386)
- BETWEEN (4398)
- COUNT (4407)
- D (4415)
- DISTINCT (3303)
- DO (4436)
- G (4442)
- I (4450)
- IN (4468)
- keywords, QBE (4598)
- LIKE (4479)
- MAX (4499)
- MIN (4506)
- NOT (4515)
- NULL (4527)
- OR (4535)
- P (4546)
- UNQ (4599)
- USER (4607)
keywords, QBE
- ALL (4350)
- AND (4360)
- AO (4378)
- AVG (4387)
- BETWEEN (4399)
- COUNT (4408)
- D (4416)
- DO (4437)
- G (4443)
- I (4451)
- IN (4469)
- LIKE (4480)
- MAX (4500)
- MIN (4507)
- NOT (4516)
- NULL (4528)
- OR (4536)
- P (4547)
- SUM (4576)
- U (4583)

language operand for Prompted Query (3141)
LANGUAGE parameter
- SET PROFILE command (4094)
LANGUAGE parameter on SET PROFILE command (4093)
LAYOUT command (3545)
LENGTH
- string function (3407)
LENGTH string function (3406)
LIKE keyword
- any number of characters (%) (4488)
- any single character (_) (4485)
- data type dependencies (4492)
- graphic data (4495)
- selecting on conditions (4484)
- with NOT (4521)
limits for size of chart data (3635)
LINE chart format (3619)
linear procedures
- example (3658)
- guidelines (3659)
LIST command (3127), (4110)
- under QBE (4111)
List function key (3125)
- command prompt panel (3126)
- QMF CONNECT prompt panel (3874)
list of database objects
- displaying (3119), (3121)
listing tables (3152)
local DB2 and location name (3876)
locating data on charts
- in general (3628)
- on pie charts (3631)
- on the X-axis (3629)
location name
- global variable for (3888)
- list panel (3878), (3879)
- QMF CONNECT prompt panel (3875)
- QMF's governor exit (3895)
- viewing (3883)
LONG VARGRAPHIC data type (3966)

manipulating character/graphic strings (3361)
MAX column function (3345)
- in QBE (4502)
- in SQL (3344)
message line (3070)
methods of accessing data (3029)
MICROSECOND scalar function (3403)
MIN column function (3347), (4509)
minimum unique abbreviations, for commands (3077)
minus sign (-) (4165), (4614)
- in expressions (4615)
- order of evaluation (4166)
MINUTE scalar function (3400)
model queries (4260)
MONTH scalar function (3397)
More Help, for error messages (3089)
more than one table, presenting data from (4248)
multiple
- columns, joining (3193)
- conditions (4367), (4543)
  - under QBE (4368), (4544)
- table queries (3312)
- tables, joining (3189)
multiplication operator (*) (4169)

N literal (3982)
name
- column (3016), (4188)
- for columns of calculated values (4187)
- for form panels, displaying list of (3471)
- for tables (3021)
- location qualifier (3023)
- owner qualifier (3022)
- query, maximum length (3145)
- tables (3017)
National Language Feature (3949)
National Language Feature (NLF) (3698)
negative conditions (4512)
NLF (National Language Feature) (3699), (3948)
NOT keyword (4517)
Notices (4672)
null
- definition of (4524)
- in condition with IN keyword (4475)
- passing in expressions (3492)
- replacing with data (3493)
- values
  - defined (4529), (4530)
  - prints and displays as (4531)
  - replacing using the VALUE function (3413)
  - results in expressions (4533)
  - using the VALUE function (3414)
  - with conditions (4226)
  - with G (4449)
  - with I (4466)
- with NOT (4522)
numeric
- constants (4194)
- data (4172)
  - in expressions (4173)

object owner (3054)
objects (3035)
- CHART (3041)
- current location (3906)
- DATA (3038)
- database (3036)
- displaying a list of (3120), (3122)
- exporting
  - HTML reports (3843)
  - into CICS (3840)
  - into CMS (3836)
  - into TSO (3833)
- FORM (3039)
- importing
  - from CICS (3853)
  - from CMS (3849)
  - from TSO (3846)
- listing (3154)
- PROC (3042)
- PROFILE (3043)
- QUERY (3037)
- REPORT (3040)
- retrieving from the database (3085)
- saving in the database (3083)
- sharing with other users (3084)
operators
- ALL (4354)
- AO (4380)
- D (4418)
- DO (4439)
- G (4445)
- I (4465)
- P (4549)
- U (4585)
- UNQ (4601)
option
- GETQMF macro (4044)
- USEQMF (4058)
OR
- keyword (4538)
OR keyword (4537)
order
- evaluating expressions (4162)
- of columns
  - ascending (4375)
  - descending (4432)
  - reversing (4130)
- rows in a report (3175), (3306), (4373), (4430)
  - ascending (4374)
  - descending (4431)
OS/390 (Multiple Virtual Storage) (4083), (4086)

P (present) keyword (4120), (4548)
page heading and footing (3116)
- adding to a report (3117)
page headings
- adding
  - date, time, page number (3556)
  - to reports (3534)
- changing alignment of (3560)
- refining, on reports (3550)
- using global variables in (3554)
panel
- CONVERT Command Prompt (4296)
- database status (3222)
- display form panels using the SHOW and DISPLAY commands (3469)
- home (3063)
- Prompted Query dialog (3134)
- QBE QUERY (4113)
- RUN command prompt (4273)
parentheses
- in expressions (4159)
parentheses in expressions (4158)
PASS NULLS field (3494)
percent sign (%)
- with LIKE (4491)
percent sign (%) with LIKE (4490)
performance
- database status panel (3219)
performance, database status panel (3218)
PF (program function) keys on home panel (3066)
PIE chart format (3618)
placement of cursor (4335), (4345)
plus sign (+) (4167), (4613)
- in expressions (4612)
- order of evaluation (4168)
POLAR chart format (3622)
presenting
- all columns of a table (4121), (4550)
- certain values in a set (4467)
- data (4545)
- data from more than one table (4247), (4567)
- maximum number of specific columns (4123)
- on either of two conditions (4534)
- on part of a value (4476)
- on the opposite of a condition (4511)
- on two conditions (4357)
- rows with a certain value (4143)
- rows with missing entries (4523)
- some columns in a table (4556)
- some rows in a table (4561)
- specific columns of a table (4124), (4557)
- specific rows of a table (4141)
- values within a range (4395)
printing
- charts (3649)
- DBCS reports (3993)
- reports (3607)
PROC database object (3050)
procedures
- batch
  - errors (3708), (3709)
  - example for MVS (3702)
  - example for VM (3700)
  - termination (3710)
  - using IMPORT/EXPORT commands (3704)
  - using the QMF EXIT command (3706)
  - writing (3695)
- bilingual command (3945)
- DBCS data (3975)
- for QMF
  - in CICS environment (3652)
  - in CMS environment (3653)
  - in TSO environment (3654)
- linear (3657)
  - connecting from, to a remote location (3686)
  - creating (3655)
- reusable
  - creating (3665)
- running in batch (3693)
- sharing with other QMF users (3664)
- to create queries (3689)
  - using global variables (3692)
  - using REXX variable values (3691)
  - using template SQL statements (3690)
- to run (3663)
- with logic
  - connecting from, to a remote location (3687)
  - creating (3656)
  - example (3660)
  - using REXX variables in (3674)
processing
- data and time values (3360)
- order (4157)
processing date and time values (3359)
processing order (4156)
profile
- saving changes in the database (3080)
- SET PROFILE command (4090)
- setting up (3078), (3095), (4089)
- viewing (3079)
PROFILE database object (3051)
PROFS
- and XEDIT (4067)
- formatting type (4051)
- how to insert a QMF report (4052)
- used while in QMF (3998)
- used with QMF document interface (4032)
Program Function (PF) keys
- on home panel (3065)
- QBE initial settings (4118)
Prompt panel
- variable data (4263)
prompt panel for variable data (4262)
prompt panels for QMF CONNECT (3872)
prompted query
- and echo areas (3133)
- dialog panels (3132)
- displaying a report (3204)
- eliminating duplicate rows in reports (3188)
- finding comments about tables (3156)
- general rules (3139)
- joining multiple columns in (3194)
- joining tables in (3181)
- listing tables (3153)
- main panel
  - command line (3136)
  - echo area (3138)
  - function key area (3135)
  - scroll indicator (3137)
- main panel (3131)
- profile requirements (3140)
- running a query (3203)
- selecting tables (3149)
- SQL equivalent of (3260)
- starting (3147)
- substitution variables in (3199)
Prompted Query
PS/TSO, used with QMF document interface (4035)
PULL statements to specify REXX variables (3677)

Q.APPLICANT sample table (4651)
Q.INTERVIEW sample table (4653)
Q.ORG sample table (4655)
Q.PARTS sample table (4657)
Q.PRODUCTS sample table (4659)
Q.PROJECT sample table (4661)
Q.STAFF sample table (4663)
Q.SUPPLIER sample table (4665)
QBE (Query-By-Example)
- calculated values in expressions (4412), (4625)
- commands (4285)
- keywords (4349), (4643)
- Query panel (4112)
QMF (3056)
- administrator, definition (3057)
- command line (3072)
- commands specific to QBE (4283)
- getting acquainted with (3009)
- Home panel (3061), (3094)
- objects, definition (3052)
- quick lessons in using (3090)
- session
  - ending (3074)
  - starting (3060)
qualifiers, to distinguish between columns (3324)
query (3030)
- adding
  - lines to (3240), (3307)
  - specifications to (3238), (3239)
- calculated values
  - columns of expressions (4632)
  - for groups (4447)
- calculated values in (4446), (4631)
- changing (3252)
- changing saved (3229)
- conditions
  - selecting on (4133), (4221)
- converting (4287)
  - to SQL (4286)
- creating using Prompted Query (3091), (3130), (3261)
- creating using SQL (3262), (3460)
- data entry (4453), (4588)
  - insert rows (4454)
  - update rows (4589)
- definition (3031)
- deleting
  - DELETE command (4298)
  - from database (3257), (4297)
  - information from (3254)
  - lines from (3308)
  - rows (4419), (4420)
- eliminating duplicate rows (4355), (4602)
- erasing from database (3256)
- example elements (4149)
- expressions
  - arithmetic (4620)
  - definition (4629)
  - in conditions (4224)
- format (3264)
- joining multiple columns in (3195)
- listing (4108)
  - LIST command (4109)
- making reusable (3197), (3450)
- model (4261)
- multiple table (3311)
- non-displaying, correcting (3234)
- ordering rows in a report (4372), (4429)
- Prompted Query (3033)
- Query-by-Example (3034)
- resetting (4096)
- retrieving from database (3232)
- reusing (4254)
- row conditions in (3169), (3287), (4132), (4222)
- rows (4223)
- running (3207), (3266), (4098)
  - under QBE (4099)
- saving (3209), (3457), (4100)
- select
  - all columns (4552)
  - from multiple tables (4569)
  - specific columns (4126)
- selecting
  - all columns (3157), (3269), (3270), (4551)
  - columns for a Prompted Query (3100)
  - from multiple tables (3178), (3328), (4568)
  - rows for a Prompted Query (3102)
  - specific columns (3158), (3271), (4125)
  - specific rows (3170), (3282), (4138), (4562)
  - table for a Prompted Query (3096)
- selecting on conditions
  - BETWEEN (4392)
  - IN keyword (4472)
  - multiple (4363), (4539)
  - negative (4513)
  - specific columns (4558)
  - specific rows (4139), (4563)
  - values within a range (4396)
  - with a certain string of characters (4481)
  - with equality and inequality (4635)
- sharing with other users (3211), (3459), (4610)
- sorting rows in (3174), (3305)
- SQL (3032)
- starting (3148), (3265)
- substitution variables in (3198), (3451)
- with DBCS data
  - graphic strings (3979)
- with substitution variable data (4264)
Query-by-Example (4088), (4647)
QUERY database object (3045)
quotation marks
- when needed (4176)
- with constants (4196)
- with LIKE (4483)

range of values (4402)
REDUCE command (4337)
reformatted text, mixing with tabular data (3595)
remote data access, DB2 environment (3024)
remote location, connecting from a procedure (3688)
remote unit of work
- accessing the current location name (3886)
- connect from
  - DB2 to DB2 (3934)
  - DB2 to SQL/DS (3938)
  - SQL/DS to SQL/DS (3936)
- granting privileges to other locations (3912)
- Lost Connection prompt panel (3897)
- QMF CONNECT command prompt panels (3867)
- QMF objects (3907)
- reconnecting to a location (3896)
- states of QMF when a connection is lost (3898)
- tables and views (3900)
- tips and techniques (3913), (3916), (3924)
- tips for procedures (3921)
- using QMF with (3903), (3908)
- using with distributed unit of work (3940)
replacing null values using the VALUE function (3415)
REPORT database object (3048)
reports
- adding
  - break segments (3564)
  - break text (3567)
  - new column to (3488)
  - page headings and footings (3111)
  - subtotals to (3526)
- calculating values on (3577)
- changing (3112)
  - alignment of headings and data (3504)
  - column heading (3497)
  - column names (3113)
  - column order (3495)
  - column width (3114), (3499)
  - columns in (3476)
  - default format (3475)
- completing before connecting to remote location (3866)
- correcting errors before display (3599)
- creating (3462), (3609)
- default report format (3115)
- definition (3118)
- displaying
  - calculated values in (3584)
  - FORMS panels for (3478)
  - representative (3546)
  - special conditions on (3588)
- edit codes in (3512)
- eliminating duplicate rows from (3187)
- final text in (3574)
- footings in (3533), (3539), (3549), (3553), (3563)
- FORM.COLUMNS command (3487)
- FORM.MAIN command (3482)
- formatting with detail blocks (3570)
- headings in (3532), (3538), (3548), (3562)
- mixing tabular data with reformatted text (3596)
- page headings (3552)
- printing (3608)
- SHOW FORM command (3481)
- showing totals across rows (3597)
- specifying fixed columns (3540)
- specifying punctuation for values in columns (3506)
- specifying text for subtotals (3530)
- specifying usage codes (3522)
- using default format (3473)
RESET GLOBAL command (3746), (3752)
RESET QUERY command (4095)
resetting forms to default values (3606)
restrictions
- AVG (4391)
- COUNT (4414)
- example elements (4152)
- MAX (4503)
- MIN (4510)
- SUM (4581)
- target tables (4243)
- unnamed columns (4242)
- variable names (4274)
retrieving
- data
  - from multiple tables (3316), (3330)
  - with QBE (4119)
- query from database (3231)
- saved query (3230)
reusable procedures, creating (3666)
reusing queries (4255)
reversing order of columns (4131)
REXX error-handling instructions
- using messages with the EXIT instruction (3682)
REXX error-handling statements
- branching to subroutines (3681)
REXX EXECs
- calling from a procedure with logic (3683)
  - with substitution variables (3685)
  - without substitution variables (3684)
- writing (3491)
REXX logic in procedures
- example (3661)
- guidelines (3662)
REXX variables
- differences from substitution variables (3679)
- passing values to procedures with logic (3678)
- specifying values, using SAY and PULL statements (3675)
- using in procedures with logic (3673)
rows
- adding (4459)
- conditions
  - changing in queries (3249)
  - specifying (3286)
- deleting (4425)
- duplicates in reports, eliminating (3184)
- eliminating duplicates (3302), (4356), (4604)
- from multiple tables (4572)
- inserting (4460)
- ordering (4376), (4440)
- select
  - specific (4137)
- select on conditions
  - AND (4366)
  - BETWEEN (4394)
  - OR (4542)
- selecting
  - both conditions true (3294)
  - one of two conditions true (3296)
  - specific (3171), (3281)
  - using character values (3284)
  - using conditions (3285)
  - using grouped conditions (3298)
  - using multiple conditions (3293)
  - using multiple OR conditions (3300)
  - using multiple row conditions (3172)
  - using opposite conditions (3289)
  - using selection symbols (3291)
  - with no data (3283)
- selecting on conditions (4136)
- selecting some (4566)
- sorting (3304)
- updating (4592)
- with nulls (4526)
rules
- for creating a subquery (3332)
- for date/time addition (3429)
- for date/time subtraction (3433)
- for location of data on charts (3627)
RUN command (3104), (4102), (4268)
- description (4103)
- substitution variables (4269)
- to run a query (3105)
running (3106)
- a prompted query (3107), (3205)
- an SQL query (3267)

sample tables (3026), (4649), (4666)
SAVE command (4104)
- under QBE (4105)
saved query, changing (3226)
saving
- chart format (3643)
- queries in the database (3208), (3456), (4101)
- report forms (3604)
SAY statements to specify REXX variables (3676)
scalar functions (3356), (3375), (3417)
- nesting (3418)
- uses of (3357), (3376)
SCATTER chart format (3625)
SCRIPT/VS
- how to insert a QMF report (4049)
SECOND scalar function (3401)
select (3092)
- all columns (3272), (4553)
- columns for a Prompted Query (3098), (3099)
- maximum number of specific columns (4122)
- multiple tables (4571)
- on conditions (4134)
  - introduction (4135)
  - multiple (4364), (4540)
  - negative (4220), (4514)
  - values in a set (4473)
  - values within a range (4397)
  - with a certain string of characters (4482)
  - with equality and inequality (4637)
- rows (3101), (3168), (3280)
- some columns (3273), (4560)
- some rows (4565)
- specific columns (4127)
- specific rows (4140)
- table (3093)
- tables (3150), (3277)
selecting (4559), (4564), (4570), (4636)
selection symbols (3128)
SET GLOBAL command
- creating global variables (3751)
- extended syntax (3745)
SET PROFILE command (4091)
- LANGUAGE parameter (4092)
sharing
- queries (3210), (3458), (4611)
shift in delimiter (SI) (3954), (3980)
shift in delimiter character (3957)
shift out delimiter (SO) (3955), (3981)
shift out delimiter character (3956)
shortened form panel names (3470)
SHOW command
- globals (3716), (3750)
- to display forms (3468)
SHOW FIELD
- for long expressions (3730)
SHOW FIELD function key (3729)
SHOW FORM command (3484)
SHOW GLOBAL command (3725), (3749)
Show Global Variable panel (3731)
SHOW GLOBALS command (3715), (3724)
SI character (3959)
size limits for chart data (3634)
slash (/) (4616)
- in expressions (4617)
SO character (3958)
solutions to exercises for QBE (4646)
sort order
- changing in queries (3247)
- specifying (3248), (4382), (4434)
sorting sequence
- AO (ascending order) (4381)
- DO (descending order) (4433)
special characters in Prompted Query (3143)
special conditions
- displaying on reports (3590)
- identifying using expressions (3592)
- identifying using REXX EXEC (3591)
SQL
- converting queries to (4290)
- equivalent of prompted query (3259)
- functions, advanced
  - date/time arithmetic (3422)
  - joining strings (3445)
  - multiple table queries (3313)
- statements (3263)
  - for adding columnns (3816)
  - for adding rows (3799), (3805)
  - for authorizing access to tables (3822)
  - for changing rows (3807), (3810)
  - for copying rows from one table to another (3814)
  - for deleting rows (3812)
  - using to work with data (3461)
- substitution variables in (3452)
SQL (Structured Query Language)
- functions
  - date/time arithmetic (3423)
  - joining strings (3446)
SQL/DS
- requirement for QMF (3010)
- specific QMF function support in (4669)
SQL query
- converting queries from QBE (4291)
starting
- Prompted Query (3146)
- QMF (3055)
status, database panel (3220)
string
- functions
  - LENGTH (3404)
  - SUBSTR (3408)
  - VALUE (3411)
string functions (3405), (3416)
string of characters with LIKE (4489)
subquery
- rules for creating (3333)
- to retrieve data from multiple tables (3331)
- to retrieve more than one value (3334)
- to satisfy a condition (3335)
- using a correlation name (3336)
substitution
- values (4275)
- variable
  - in a query (4265), (4277)
substitution values (4276)
substitution variables (4266)
- differences from REXX variables (3680)
- in procedures with logic (3667)
- in QBE (4279)
- making queries reusable with (3196), (3449)
- specifying values for
  - as part of RUN command (3200), (3453)
  - on RUN Command Prompt panel (3201), (3454)
  - using global variables (3202), (3455)
- supplying values (3668)
  - using the RUN command (3670)
  - using the RUN command prompt panel (3672)
  - using the SET GLOBAL command (3671)
SUBSTR scalar function (3410)
SUBSTR string function (3409)
subtotals
- adding to reports (3527)
- specifying text for (3529)
subtraction of dates and times (3432), (3443)
SUM
- column function (3341), (3350), (4580)
SUM column function
- in QBE (4579)
- in SQL (3340), (3349)
summary
- conditions (4411)
summary conditions (4410)
summary functions (3166)
SURFACE chart format (3624)
synonym
- deleting (3772)
- for table (3764)
- for view (3765)

TABLE chart format (3621)
table editor
- ending a session (3796)
- for adding data to long fields (3784)
- for adding rows (3780), (3787)
- for changing rows (3789), (3793)
- for deleting rows (3795)
- search (3791)
- using column defaults (3782)
- using nulls (3783)
Table Editor
tables
- adding columns using SQL statements (3815)
- adding rows
  - using SQL statements (3797), (3804)
  - using the QMF DRAW command (3801)
  - using the Table Editor (3778), (3786)
- appending to existing (3757)
- authorizing access (3821)
  - to add new rows (3826)
  - to change rows (3827)
  - to delete rows (3828)
  - to update columns (3830)
  - to view (3824), (3825)
- changing rows
  - using SQL statements (3806), (3809)
  - using the QMF DRAW command (3808)
  - using the Table Editor (3788), (3792)
- columns, relationship to (3014)
- copying (3758), (4426)
- copying rows from one to another
  - using SQL statements (3813)
- creating (3753)
  - a view from (3760)
  - alias for (3766)
  - synonym for (3762)
  - using SQL statements (3755)
- deleting (3770)
- deleting rows
  - using QBE (4424)
  - using SQL statements (3811)
  - using the Table Editor (3794)
- inserting rows
  - using QBE (4461)
  - using SQL statements (3798)
  - using the Table Editor (3779)
- joining (3180), (3320)
- joining multiple (3191), (3321)
- listing (3155)
- location qualifier (3020)
- multiple
  - joining columns from (3319)
  - merging data from (3327)
  - retreiving data from (3329)
  - used to create a query (3314)
- names
  - changing in queries (3250)
  - specifying (3013)
- naming conventions (3018)
- owner qualifier (3019)
- planning to create (3754)
- presenting data from more than one (4250)
- revoking access (3832)
- rows, relationship to (3015)
- sample (3027), (4648)
  - Q.APPLICANT (4650)
  - Q.INTERVIEW (4652)
  - Q.ORG (4654)
  - Q.PARTS (4656)
  - Q.PRODUCTS (4658)
  - Q.PROJECT (4660)
  - Q.STAFF (4662)
  - Q.SUPPLIER (4664)
- saving (3756)
- selecting (3151), (3276)
- target (4229), (4322)
- updating rows (4595)
- using column defaults with Table Editor (3781)
- with null data (4525)
tabular data, mixing with reformatted text (3594)
target table, drawing (4232), (4320)
temporary storage
- QMF objects in (3082)
- saving to (3081)
three-part names
- CREATE ALIAS... (3943)
- GRANT statements (3910)
- QMF objects (3923)
- tablename (3905)
- use in an SQL statement (3942)
- use of an alias (3901)
TIME
- scalar function (3382)
TIME scalar function (3381)
times sign (*) in expressions (4618)
timestamp
- adding or subtracting duration (3442)
- scalar function (3384)
TIMESTAMP
TIMESTAMP data (3428)
TIMESTAMP scalar function (3383)
timestamps, adding or subtracting duration (3441)
tips
- fixing problems with charts (3648)
- for remote unit of work (3914)
totals, showing across rows in reports (3598)
TOWER chart format (3620)
two conditions on one row (4369)
two tables, presenting data from (4249)

U keyword and operator (4584)
underscore (_) (4151), (4486)
- example element (4150)
- with LIKE (4487)
UNQ (4600)
updating
- rows (4594)
updating rows (3790), (4593)
USA format, date/time edit codes (3392)
usage codes
- definition (3523)
- specifying (3525)
USEQMF option, GETQMF (4059)
user ID
- obtaining from QMF administrator (3059)
user ID parameter for CONNECT command (3926)
USER variable (4281), (4605)
using scalar functions to avoid null values (3362)

VALUE string function (3412)
values
- calculated (3578), (3580)
  - on reports (4185), (4627)
- expressions (4628)
- on reports
  - sources (3579), (3581)
  - specifying calculations for (3582)
values, calculated (4626)
- with unnamed columns (4184)
VARGRAPHIC
- data type (3965)
- scalar function (3373), (3374)
variables (4267)
- data (4278)
- delete (3741)
- reset (3740)
- substituting user ID for (4609)
- substitution (4280)
- USER (4282), (4608)
- value (3727), (3739)
view
- creating alias for (3767)
- creating from a table (3761)
- creating synonym for (3763)
- deleting (3771)
- location name (3884), (3892)
VM
- editor (4079), (4081)
- when QMF is active (4082)
- when QMF is inactive (4080)

wildcards (3129)

XEDIT editor
- used while in QMF (3999)
- used with QMF document interface (4033), (4034)

YEAR scalar function (3398)

zero values
- suppressing (3518)

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