IBM SC41-5210-04 manual Specifying Query for iSeries processing options

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:

vSee substitution characters in your output.

vEncounter 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