IBM SC41-5210-04 manual Example

dividing by zero (0)								example (continued)
example			83					running query			206
DLTQRY (Delete Query) command 11, 178								selecting and sequencing field						88
double-byte character set (DBCS)								selecting sort field				106
bracket characters						9		exercise
character constant								Query	199
shift-in character						60		Exit This Query display					167, 169
shift-out character							60	exiting
data representation						8		Query for iSeries				7, 167
pictograph			4					expression
shift-in character					60			character
shift-out character						60		definition		58
sorting character data							111	considerations when creating						83
space requirements						9		creating	83
symbolic characters						4		date
duration								definition		58
date	73							date data type			68
labeled		73						numeric
time	73							definition		58
timestamp			74					result field
								character		60
E								creating		83
								numeric		59
edit code								spanning lines			84
modifier		131						time
numeric fields				129				definition		59
specifying			129					time data type			68
edit word								timestamp
different CCSIDs					132			definition		59
numeric field				131				timestamp data type					68
specifying			131
editing numeric field								F
defining		122
describing editing								field
currency symbol						126		character
date/time field					127			differences between Query/36 and Query for
date/time separator							128	iSeries		196
decimal point					125			using result fields					60
negative sign					125			comparison		92

replacing leading zero				127		date
thousands separator				125		expressions	66
specifying edit code			129			using result fields		66
specifying edit word			131			DBCS 4, 45
EE (double-byte E)		8				brackets 9
ending query definition			167			Display Report Layout display				8
entering data	203					expressions	60
EQ (equal) comparison test				95, 96, 165		field naming convention 4
error						length(graphic) 120
handling	18					LIKE comparison test			99
ignoring in numeric field				164		migration(graphic)		241
Specify File Selections display					36	NLIKE (not like) comparison test 99
EUR (IBM European standard)						printed record format			182
date and time 67						rules for join tests		45
example						rules for join tests(graphic) 45
changing query definition				211		selecting records		93
code page	114					shift-out and shift-in characters				9
connecting record selection test					101	definition 3
creating database file			203			editing
creating query definition				206, 215		defining numeric		122
defining result field 86						describing numeric 124
IDDU definition		199				floating-point	8

Index 269