IBM ISERIES SC41-5210-04 Manual de usuario Pagina 105
- Pagina / 294
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Comparison values in Query for iSeries
The value you compare the field with can be:
v Another field
v A numeric constant
v A character constant (SBCS or DBCS)
v A date constant
v A time constant
v A timestamp constant
The field and the value you are comparing must be compatible data types. The following are valid
comparisons for record selection tests:
v SBCS character field with:
SBCS character
DBCS-either
DBCS-open
v DBCS-either field with:
SBCS character
DBCS-either
DBCS-open
DBCS-only
v DBCS-open field with:
SBCS character
DBCS-either
DBCS-open
DBCS-only
v DBCS-only field with:
DBCS-either
DBCS-open
DBCS-only
v DBCS-graphic field with:
DBCS-graphic
v UCS2-graphic field with:
UCS2-graphic
v Numeric field with a numeric field
v Date field with:
SBCS character
Date
DBCS-either
DBCS-open
v Time field with:
SBCS character
Time
DBCS-either
DBCS-open
v Timestamp field with:
Chapter 7. Selecting records in Query for iSeries 93
- ERserver 1
- ER s e r v e r 3
- “Notices” on page 261 4
- Contents 5
- Contents v 7
- Contents vii 9
- Query for iSeries Use V5R2 10
- About Query for iSeries Use 11
- 2 Query for iSeries Use V5R2 14
- 4 Query for iSeries Use V5R2 16
- Query for iSeries definitions 17
- 6 Query for iSeries Use V5R2 18
- 8 Query for iSeries Use V5R2 20
- 10 Query for iSeries Use V5R2 22
- 12 Query for iSeries Use V5R2 24
- 14 Query for iSeries Use V5R2 26
- 16 Query for iSeries Use V5R2 28
- 18 Query for iSeries Use V5R2 30
- 20 Query for iSeries Use V5R2 32
- 22 Query for iSeries Use V5R2 34
- 24 Query for iSeries Use V5R2 36
- 26 Query for iSeries Use V5R2 38
- 28 Query for iSeries Use V5R2 40
- 30 Query for iSeries Use V5R2 42
- 32 Query for iSeries Use V5R2 44
- 34 Query for iSeries Use V5R2 46
- 36 Query for iSeries Use V5R2 48
- 38 Query for iSeries Use V5R2 50
- Format display 52
- Selections display 53
- 42 Query for iSeries Use V5R2 54
- 44 Query for iSeries Use V5R2 56
- 46 Query for iSeries Use V5R2 58
- 48 Query for iSeries Use V5R2 60
- 50 Query for iSeries Use V5R2 62
- 52 Query for iSeries Use V5R2 64
- 54 Query for iSeries Use V5R2 66
- 56 Query for iSeries Use V5R2 68
- Query for iSeries expressions 70
- AMOUNT = QUANTITY * PRICE 71
- QUANTITY 71
- 5 + QUANTITY 71
- 60 Query for iSeries Use V5R2 72
- 62 Query for iSeries Use V5R2 74
- VARCHAR ( expression 75
- , length 75
- DEFAULT , ccsid 75
- 64 Query for iSeries Use V5R2 76
- 66 Query for iSeries Use V5R2 78
- Query for iSeries date 79
- Query for iSeries time 79
- Query for iSeries timestamp 80
- 70 Query for iSeries Use V5R2 82
- 72 Query for iSeries Use V5R2 84
- HIREDATE + 2 MONTHS + 14 DAYS 85
- HIREDATE - BIRTHDATE 85
- 74 Query for iSeries Use V5R2 86
- DATE ( expression ) 87
- DATE(STRDATE) 87
- DAY ( expression ) 87
- 76 Query for iSeries Use V5R2 88
- MINUTE ( expression ) 89
- 78 Query for iSeries Use V5R2 90
- TIME ( expression ) 91
- TIMESTAMP ( expression ) 91
- 80 Query for iSeries Use V5R2 92
- 82 Query for iSeries Use V5R2 94
- 84 Query for iSeries Use V5R2 96
- 86 Query for iSeries Use V5R2 98
- 88 Query for iSeries Use V5R2 100
- 90 Query for iSeries Use V5R2 102
- 92 Query for iSeries Use V5R2 104
- 94 Query for iSeries Use V5R2 106
- 96 Query for iSeries Use V5R2 108
- 98 Query for iSeries Use V5R2 110
- G’s/o__DD__%%HH%%s/i’ 112
- (MONTH EQ 1 AND YEAR EQ 87) 114
- Specifying edit words 143
- Totals for Glendale CA 156
- JY Clarke 156
- RESULT10 9+9+9+9+9 999999 200
- Query for iSeries 201
- Part 4. Appendixes 205
- Query/36 207
- Select one of the following: 211
- 1. Work with data definitions 211
- Press the Enter key again 230
- Press the Enter key 241
- Bibliography 271
- Trademarks 274
- Special Characters 275
- Index 265 277
- Index 267 279
- Index 269 281
- Index 271 283
- Index 273 285
- Index 275 287
- Index 277 289
- Index 279 291
- Printed in U.S.A 294
- SC41-5210-04 294
Relacionado con productos y manuales para Manuales de software IBM ISERIES SC41-5210-04
Manuales de software IBM C3 Manual de usuario
(248 paginas)
(248 paginas)
Manuales de software IBM SC34-4499-03 Manual de usuario
(356 paginas)
(356 paginas)
© 2020, manymanuals.es. Todos los derechos reservados | 0.042 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales