Comparing DBCS fields through the Open Query File (OPNQRYF) command
When you compare two fields or constants, fixed-length fields can be compared to variable-length fields if the types are compatible.
The table shows the valid comparisons for double-byte character set (DBCS)
fields through the Open Query File (OPNQRYF) command.
|
Table 1. Valid comparisons for DBCS fields through the OPNQRYF command
|
| Any numeric
| Character
| Hexa- decimal
| DBCS- open
| DBCS- either
| DBCS- only
| DBCS- graphic
| UCS2- graphic
| Date
| Time
| Time- stamp
|
| Any numeric | Valid | Not valid | Not valid | Not valid | Not valid | Not valid | Not valid | Not valid | Not valid | Not valid | Not valid
|
| Character | Not valid | Valid | Valid | Valid | Valid | Not valid | Not valid | Valid | Valid | Valid | Valid
|
| Hexa- decimal | Not valid | Valid | Valid | Valid | Valid | Valid | Not valid | Not valid | Valid | Valid | Valid
|
| DBCS- open | Not valid | Valid | Valid | Valid | Valid | Valid | Not valid | Valid | Valid | Valid | Valid
|
| DBCS- either | Not valid | Valid | Valid | Valid | Valid | Valid | Not valid | Valid | Valid | Valid | Valid
|
| DBCS- only | Not valid | Not valid | Valid | Valid | Valid | Valid | Not valid | Valid | Not valid | Not valid | Not valid
|
| DBCS- graphic | Not valid | Not valid | Not valid | Not valid | Not valid | Not valid | Valid | Valid | Not valid | Not valid | Not valid
|
| UCS2- graphic | Not valid | Valid | Not valid | Valid | Valid | Valid | Valid | Valid | Not valid | Not valid | Not valid
|
| Date | Not valid | Valid | Valid | Valid | Valid | Not valid | Not valid | Not valid | Valid | Not valid | Not valid
|
| Time | Not valid | Valid | Valid | Valid | Valid | Not valid | Not valid | Not valid | Not valid | Valid | Not valid
|
| Time- stamp | Not valid | Valid | Valid | Valid | Valid | Not valid | Not valid | Not valid | Not valid | Not valid | Valid
|
|
Parent topic:
Using DBCS fields in the Open Query File (OPNQRYF) command