select col1 from table_a where col1 > 0 and col1 <11

select col1 from table_a where col1 >= 0 and col1 <11

select col1 from table_a where col1 >= 0 and col1 <= 11

select col1 from table_a where col1 > 0 and col1 < =11

Top to Bottom

Front to Back

Right to Left

Left to Right

Concatenated key

path call

first occurrence

last occurrence

Concatenated key

path call

first occurrence

last occurrence

Concatenated key

path call

first occurrence

last occurrence

Concatenated key

path call

first occurrence

last occurrence

path call

set parentage

path call ignore

last occurrence

path call

path call ignore

set parentage

Concatenated key

DBD

PSD

PSB

SSA

QUALIFIED SSA

UNQUALIFIED SSA

All the above

None of the above

Message Input Data

Message Output Data

Data Input Format

Data Output Format

Function code

PCB mask

Segment I/O Area

SSA's

Function Code

PCB Mask

SSA

I/O Area

10

15

125

255

IO-PCD

DBD

IO-AREA

SSA

Zeros

Spaces

Both

None of these

PCB

PSB

ACB

DBD

ENTRY 'CBLDLI' USING ....

ENTRY 'DLICBL' USING ....

ENTRY 'DLIPLI' USING ....

ENTRY 'PLICBL' USING ....

End of database

Segment not found

Parentage not set

Successful IMS call

ADDM

AWR

Data dictionary views

Dynamic performance views