IBM ISERIES SC41-5210-04 User Manual

Page 280

Advertising
background image

definition (continued)

changing

30, 173

changing (example)

211

copying

177

copying before changing

173

creating

27, 30

creating (example)

206

deleting

179

displaying

179

DLTQRY command

178

information printed

181

migrating restriction

197

naming

27

printing

180

renaming

178

running

8

saving

167

selecting files

33

specifying authority

168

definition display

moving through

30

definition step

description

29

selecting on Define the Query display

28

Delete Query (DLTQRY) command

11, 178

deleting

file selections from a query

36

query definition

DLTQRY command

178

Query for iSeries menu

11

Query menu

178

Work with Queries display

12, 179

descending sequence

sorting records

105

Describe Date/Time Field Editing display

128

Describe Numeric Field Editing display

124

describing

numeric field editing

124

detailed output

145

DFU (data file utility)

4

differences between Query/36 and Query for iSeries

commands

195

maximum length of character fields

195

number of files that can be joined

195

operational

joining files

195

types of joins

195

DIGITS function

argument rules

62

syntax diagram

62

display

Confirm Delete of Queries

179

Copy Queries

177

Create and Select Field Definitions (IDDU)

200, 202

Create Field Definitions (IDDU)

201

Create File Definition (IDDU)

200

Define Collating Sequence

115

Define Database File Output

155

Define Numeric Field Editing

122

Define Printer Output

148

Define Report Breaks

139

display (continued)

Define Result Fields

57

Define Spooled Output

151

Define the Query

28

Describe Date/Time Field Editing

128

Describe Numeric Field Editing

124

Display Date Format

69

Display File Selections

42

Display Join Tests

53

Display Report Layout

8

Exit This Query

167, 169

Fields Missing from File Definition

54

Format Report Break

143

IDDU main (system) menu

199

Select and Sequence Fields

87

Select Collating Sequence

113

Select Definition Type (IDDU)

200

Select File

37

Select Member

40

Select Record Format

41

Select Records

92

Select Report Summary Functions

136

Select Sort Fields

105

Select Translation Table

116

selecting for query output

145

Selecting Output Type and Output Form

146

Specify Cover Page

152

Specify Edit Code

129

Specify Edit Word

131

Specify File Selections

33

Specify How to Join Files

44

Specify Page Headings and Footings

153

Specify Processing Options

163

Specify Report Column Formatting

120

Specify Type of Join

43

System Sort Sequence

118

time format

69

Work with Database Files (IDDU)

203

Work with File Definitions (IDDU)

200, 202

Work with Queries

171

display date and time format

F17 function key

18, 69

Display File Selections display

42

Display Join Tests display

53

Display Report display

8

Display Report Layout display

8

displaying

files selected for a query

41

format

date

17

decimal separator

17

time

17

join tests

53

lists

9

query

249

query definition

12, 179

query output

145

report layout using F13

8

report using F5

8, 169

text about items in a list

15

268

Query for iSeries Use V5R2

Advertising