IBM SC41-5210-04 manual 189

increasing the decimal precision 190 information for programmers, advanced 187 interactive data definition utility (IDDU)

data dictionary		4
definition	199
example
creating IDDU definition				199
introduction 4
main (system) menu			199
interactive processing
limiting 243
restricting	243
internal numeric calculations
length and decimal positions				189
International Standards Organization (ISO)
date and time		67
introduction to Query
concepts	3
IS (is) comparison test			95, 96
ISNOT (is not) comparison test				95, 96
ISO (International Standards Organization)
date and time		67

J

Japanese Industrial Standard (JIS)

date and time 67

JIS (Japanese Industrial Standard)

date and time 67

JJ(double-byte J) 8 join operation

performance recommendations 239 join selection tests

definition 231 join test

CCSID (coded character set identifier) 252
code
L, T, or Z		45
data restrictions			45
displaying		53
specifying		43
valid comparisons			45
joining files	42
advanced information for 188
description		43
differences between Query/36 and Query for
iSeries	195

example

selecting matched records for all selected

files	47
selecting matched records using a primary
file	48
selecting unmatched primary file records 48
sequencing secondary files for a primary join 49
how to join		43
matched records join 43
matched records with primary file join 43
rules 44
secondary file sequence rule 49
types of join		43

unmatched records with primary file join 43

K

key function 8 Print 9

keyed sequence access path definition 231

L

L, T, or Z
join test		45
labeled duration
definition			73
labeled duration
adding	235
subtracting			235
language code-page CCSIDs							256
language collating sequence query 114
layout
displaying report					8
LE (less than or equal) comparison test									95, 96, 165
leading zero
replacing		127
length
fields in a report					120
result field			85, 188
length and decimal positions
used for internal numeric calculations									189
level, break		139
library
definition		5
selecting for file selection							34
selecting from list					10
selecting items from list
Work with Queries display								16
special names				10
library default
S/36 environment					196
LIKE (like) comparison test						165
DBCS	99
similar patterns				95, 98
LIKE pattern
DBCS-graphic				100
DBCS-only			100
DBCS-open			100
non-DBCS character 99
linked file
differences between Query/36 and Query for
iSeries		195
list
(LIST) comparison test						95
displaying			9
generic name
using to obtain a subset list								14
library (*LIBL) 10
names of queries
Work with Queries display								14
NOT LIST comparison test							95
positioning
Work with Queries display								15

272Query for iSeries Use V5R2