definition (continued)

 

 

 

 

 

 

 

display

(continued)

 

 

 

 

 

 

 

changing

30, 173

 

 

 

 

 

 

Define Result Fields

57

 

 

 

changing (example)

211

 

 

 

 

Define Spooled Output

151

 

 

copying

177

 

 

 

 

 

 

 

Define the Query

 

28

 

 

 

 

copying before changing

 

173

 

 

Describe Date/Time Field Editing

128

creating

27, 30

 

 

 

 

 

 

Describe Numeric Field Editing

124

creating (example)

206

 

 

 

 

 

Display Date Format

69

 

 

 

deleting

179

 

 

 

 

 

 

 

Display File Selections

42

 

 

 

displaying 179

 

 

 

 

 

 

Display Join Tests

53

 

 

 

 

DLTQRY command

178

 

 

 

 

 

Display Report Layout

8

 

 

 

information printed

181

 

 

 

 

 

Exit This Query

167, 169

 

 

 

migrating restriction

197

 

 

 

 

Fields Missing from File Definition

54

naming

27

 

 

 

 

 

 

 

 

Format Report Break

143

 

 

 

printing

180

 

 

 

 

 

 

 

IDDU main (system) menu

199

 

renaming

178

 

 

 

 

 

 

 

Select and Sequence Fields 87

 

running

8

 

 

 

 

 

 

 

 

Select Collating Sequence

113

 

saving 167

 

 

 

 

 

 

 

 

Select Definition Type (IDDU)

200

selecting files

33

 

 

 

 

 

 

Select File

37

 

 

 

 

 

 

 

specifying authority

168

 

 

 

 

 

Select Member

40

 

 

 

 

 

definition display

 

 

 

 

 

 

 

 

Select Record Format

41

 

 

 

moving through

30

 

 

 

 

 

 

Select Records

92

 

 

 

 

 

definition step

 

 

 

 

 

 

 

 

 

Select Report Summary Functions

136

description

29

 

 

 

 

 

 

 

 

Select Sort Fields

105

 

 

 

 

selecting on Define the Query display

28

Select Translation Table

116

 

 

Delete Query (DLTQRY) command

11, 178

selecting for query output

145

 

 

deleting

 

 

 

 

 

 

 

 

 

Selecting Output Type and Output Form 146

file selections from a query

 

36

 

 

 

Specify Cover Page

152

 

 

 

query definition

 

 

 

 

 

 

 

 

Specify Edit Code

129

 

 

 

 

DLTQRY command

178

 

 

 

 

 

Specify Edit Word

131

 

 

 

 

Query for iSeries menu

11

 

 

 

Specify File Selections

33

 

 

 

Query menu

178

 

 

 

 

 

 

Specify How to Join Files

44

 

 

Work with Queries display

12, 179

Specify Page Headings and Footings 153

descending sequence

 

 

 

 

 

 

Specify Processing Options

163

 

sorting records

105

 

 

 

 

 

 

Specify Report Column Formatting

120

Describe Date/Time Field Editing display

128

Specify Type of Join

43

 

 

 

Describe Numeric Field Editing display

 

124

System Sort Sequence

118

 

 

describing

 

 

 

 

 

 

 

 

 

time format

69

 

 

 

 

 

 

 

numeric field editing 124

 

 

 

 

 

Work with Database Files (IDDU)

203

detailed output

145

 

 

 

 

 

 

 

Work with File Definitions (IDDU)

200, 202

DFU (data file utility)

4

 

 

 

 

 

 

Work with Queries

171

 

 

 

differences between Query/36 and Query for iSeries

display date and time format

 

 

 

commands

195

 

 

 

 

 

 

 

F17 function key

 

18, 69

 

 

 

maximum length of character fields

195

Display File Selections display

42

 

number of files that can be joined

195

Display Join Tests display

53

 

 

 

operational

 

 

 

 

 

 

 

 

 

Display Report display

8

 

 

 

 

joining files

195

 

 

 

 

 

 

Display Report Layout display

8

 

 

types of joins

195

 

 

 

 

 

 

displaying

 

 

 

 

 

 

 

 

 

DIGITS function

 

 

 

 

 

 

 

 

files selected for a query 41

 

 

argument rules

62

 

 

 

 

 

 

format

 

 

 

 

 

 

 

 

 

syntax diagram

62

 

 

 

 

 

 

date

17

 

 

 

 

 

 

 

 

display

 

 

 

 

 

 

 

 

 

decimal separator

17

 

 

 

Confirm Delete of Queries

179

 

 

 

time

17

 

 

 

 

 

 

 

 

Copy Queries

177

 

 

 

 

 

 

join tests 53

 

 

 

 

 

 

 

Create and Select Field Definitions (IDDU) 200, 202

lists

9

 

 

 

 

 

 

 

 

 

Create Field Definitions (IDDU)

201

 

query

249

 

 

 

 

 

 

 

 

Create File Definition (IDDU)

200

 

 

query definition

12, 179

 

 

 

Define Collating Sequence

115

 

 

 

query output

145

 

 

 

 

 

 

Define Database File Output

155

 

 

report layout using F13

8

 

 

 

Define Numeric Field Editing

122

 

 

report using F5

8, 169

 

 

 

 

Define Printer Output

148

 

 

 

 

 

text about items in a list

15

 

 

Define Report Breaks

139

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

268Query for iSeries Use V5R2

Page 280
Image 280
IBM SC41-5210-04 manual Definition Display