CCSID (coded character set identifier) (continued)

character set support

 

 

definition

246

 

 

 

UCS2 level 1

4

 

 

displaying

17

 

 

 

character substitution warning 165

displaying query

249

 

checking query results

8

 

edit word

132

 

 

 

choices

 

 

 

 

 

 

file selection

252

 

selecting options 29

 

footing 253

 

 

 

CL (control language)

5

 

join tests

252

 

 

 

creating database files

5

language code page 256

code

 

 

 

 

 

 

marking

247, 254

 

Dec field

 

 

 

 

 

page heading

253

 

E

121

 

 

 

 

 

query

 

 

 

 

 

J

121

 

 

 

 

 

options list

256

 

L

121

 

 

 

 

 

running

256

 

 

O

121

 

 

 

 

 

table

256

 

 

 

T

121

 

 

 

 

 

query display

 

 

 

V

121

 

 

 

 

 

table

249

 

 

 

Z

121

 

 

 

 

 

record selection

 

253

 

edit

129

 

 

 

 

 

report break

253

 

 

L, T, or Z

 

 

 

 

 

result field

252

 

 

join test

 

45

 

 

 

run-time record selection 251

code page

 

 

 

 

 

Select Records display

97

definition

114

 

 

 

sort field

253

 

 

 

example 114

 

 

 

summary function

253

 

coded character set identifier (CCSID)

translation table

 

116

 

break text

 

253

 

 

VALUE function

 

 

 

changing query

250

 

results

63

 

 

 

collating sequence

112, 256

changing query

 

 

 

 

conversion

249

 

 

CCSID (coded character set identifier) 250

DBCS character field

248

definition

12

 

 

 

default

248

 

 

changing query definition

173, 211

defining

 

114

 

 

CHAR function

 

 

 

 

hexadecimal

248

 

argument rules

74

 

language

248

 

 

syntax diagram

74

 

SBCS character field

248

character

 

 

 

 

 

selecting

111, 114

 

constant

60

 

 

 

translation table

248

 

record selection test 94

user-defined

248

 

expression

 

 

 

column formatting

253

 

result fields

60

compatibility for conversions 254

field

60

 

 

 

 

cover page

253

 

 

name

60

 

 

 

 

definition

246

 

 

 

character comparisons 165

displaying format

17

 

character constant

 

 

displaying query

249

 

declaring

94

 

 

edit word

132

 

 

 

rules for using

60

file selection

252

 

shift-in character

60

footing 253

 

 

 

shift-out character

60

join test

252

 

 

 

character data

 

 

 

language code-page 256

Display Report Layout display 8

marking

247, 254

 

character field

248

 

page heading

253

 

differences between Query/36 and Query for

query

 

 

 

 

 

iSeries

196

 

 

options list

256

 

substring

 

 

 

 

running

256

 

 

example

61

 

table

256

 

 

 

valid comparisons

46

query display

 

 

 

character field name

 

table

256

 

 

 

valid entries

60

 

record selection

 

253

 

value

 

 

 

 

 

report break

253

 

 

description

61

 

result field

252

 

 

character result field

 

run-time record selection

251

rules for creating

60

Select Records display

97

264Query for iSeries Use V5R2

Page 276
Image 276
IBM SC41-5210-04 manual Character substitution warning