Filter
Top Products
Whether you choose to have decimal data errors ignored depends on whether your data contains values
that cause decimal data errors. You may want to define your query to ignore decimal data errors if the files
it uses have zoned or packed numeric fields that contain data that is not normally interpreted as zoned or
packed data. For example, some applications write blank into a zoned field when the user leaves a prompt
blank. Also, some direct files set all records to hex 40.
Ignoring decimal data errors can have a significant performance cost and should be avoided if the file
does not contain such data. If you define your query to not ignore decimal data errors, it may run faster.
Note: If your query was created on an iSeries system, a Blank is shown as the default. If Query
determines that your query was migrated from System/36, a Y is used so that the query can be
processed as it was on System/36. Ignore the character substitution warning.
Ignoring character substitution warnings during Query for iSeries
processing
The Ignore Character Substitution prompt lets you specify whether or not character substitution warnings
should be ignored when converting data or a collating sequence from one CCSID to another.
Each character field, literal, and collating sequence is associated with a CCSID. This makes it possible to
convert field and literal values to a different coding representation, and to convert collating sequences for
use with data in a different coding representation. Character conversion, when required, is automatic and
transparent to the user. CCSID conversion usually occurs when the user is running in a multilingual
environment. A unique character may be substituted during character conversion for any character in the
source coding representation that does not have a match in the target coding representation.
Y=Yes
Character substitution is ignored and no error messages are issued. Leave the default Y if your
system contains all files with the same CCSID. If you have a primary and secondary language (such
as Spanish and English), character conversion may be done. Leave the default Y if no substitution is
possible, or if you do not care if this happens. If your files have different CCSIDs and you ignore
character substitution, you may:
v See substitution characters in your output.
v Encounter unexpected matching (when differing characters are substituted).
N=No
An error message is issued if a character substitution occurs or could occur when converting from one
CCSID to another, and the request being processed is ended with output incomplete.
Using collating sequence for all character comparisons during Query
for iSeries processing
The Use collating sequence for all character comparisons prompt lets you specify whether use of the
selected collating sequence should be unrestricted.
Y=Yes
Use the selected collating sequence for all character comparisons. When you choose this option, A
equals a if they share a collating weight in the sequence regardless of the test or data type.
N=No
Do not use the selected collating sequence for EQ, NE, LIST, NLIST, LIKE, and NLIKE tests or for
SBCS data in DBCS fields or constants. This is the default for queries restored from a release prior to
Version 2 Release 3 or converted from a System/36.
Chapter 14. Specifying Query for iSeries processing options 165