Micro Focus Enterprise Test Server 2.3 Update 2 > Data Access > Database Access > SQL Option for DB2 > Reference > Error Messages > PIC - Picture Error Messages

PIC - Picture Error Messages

PIC000: Error system error: Unknown error errorID.
The program attempted to display an error that was not found in this error file.
PIC001 Syntax error in mask definition.
The Numeric Format specified in the Options is invalid.
PIC002 Grouping character found twice or in illegal position.
The Numeric Format defined in Options contains two grouping characters (e.g., two commas) or the grouping character is in the wrong position (e.g., after the decimal point).
PIC003 No grouping length.
A serious internal error has occurred in Option's picture parser. Contact Micro Focus Technical Support.
PIC004 Decimal character found twice or in illegal position.
The Numeric Format defined in Options contains two decimal characters (e.g., two decimal points) or the decimal character is in the wrong position (e.g., 99.99,).
PIC005 Rounding character in illegal position.
The Numeric Format defined in Options contains an incorrectly placed rounding character (r). This character, when used, must be the very last character in the picture string (e.g., xxx,9.99+r).
PIC006 Illegal character in picture specification.
A character, other than those allowed, is included in the Date, Time or NumericFormat specified in Options.
PIC007 $ character found on both sides of decimal.
The Numeric Format defined in Options contains a money character (e.g., $) on both sides of the decimal character (e.g., $$$$.$$ is invalid). This character can appear only on the left side of the decimal.
PIC008 Sign character found on both sides of the decimal.
The Numeric Format defined in Options contains a sign character (e.g., +) on both sides of the decimal character (e.g., +$99.99+r is invalid). This character can be placed on the left or the right of the decimal point, but not both.
PIC009 Error in substitution portion of picture definition.
The $=, .=, or ,= clause in the Numeric Format defined in Options is invalid. It may, for example, contain an invalid character or be missing the required delimiters.
PIC010 Illegal decimal found in picture.
The Numeric Format defined in Options contains an invalid decimal sign character. Only a period can be used in the picture portion of a Numeric Format. For example: 999.99 .=',' is valid; 999,99 .=',' is not.
PIC011 Illegal rounding character found in picture.
The Numeric Format defined in Options contains an invalid rounding character. Only an "r" can be used to indicate rounding, and this character must appear at the end of the picture string.
PIC012 Illegal dollar sign found in picture.
The Numeric Format defined in Options contains an invalid money character. Only a dollar sign can be used in the picture portion of the format. For example: $$9.99 .='>=' is valid; >=>=9,99 .='>=' is not.
PIC013 Closing single quote not found in substitution string.
The substitution character string defined in the $=, .=, or ,= clause in the Numeric Format defined in Options does not end with a single quote. For example: $999.99 .$='fl' is valid; $999,99 .='fl is not.
PIC014 Value too wide for picture field.
The numeric value being entered or displayed is larger than the Numeric Format picture defined in Options.
PIC015 Error in time/date picture definition.
The Time Format or the Date Format in Options is incorrectly specified.
PIC016: Error trying to identify the picture format type.
A serious internal error has occurred because the active program received an illegal data type. Contact Micro Focus Technical Support.
PIC017 Invalid year value.
The date value being entered or displayed is inconsistent with the Date Format specified in Options.
PIC018 Invalid separator in value.
The numeric or money value being entered or displayed contains a separator character (e.g., the comma in 1,000) that is inconsistent with the Numeric Format currently specified in Options.
PIC019 Invalid character in value.
A value that is being entered or displayed contains a character that is inconsistent with a picture currently specified in Options.
PIC020 Money value error.
The money value being entered or displayed is inconsistent with the Money Format currently specified in Options.
PIC021 Numeric value error.
The numeric value being entered or displayed is inconsistent with the Numeric Format currently specified in Options.
PIC022 Illegal Integer value.
The integer value that is being entered or displayed is out of range. It contains more digits than specified by the NumericFormat in Options.
PIC023 Illegal Time value.
The time value that is being entered or displayed is inconsistent with the Time Format currently specified in Options.
PIC024 Illegal Date value.
The date value that is being entered or displayed is inconsistent with the Date Format currently specified in Options.
PIC025 Scale is bigger than precision.
The Float Decimal Places value (i.e., scale) specified in Options is larger than the total number of digits allowed for a float value on your system (i.e., precision).
PIC026 Invalid separator in time value.
The time value being entered or displayed contains a separator character (e.g., the colon in 4:00) that is inconsistent with the Time Format currently specified in Options.
PIC027 Invalid separator in date value.
The date value being entered or displayed contains a separator character (e.g., the dash in 03-30-86) that is inconsistent with the Date Format currently specified in Options.
PIC028 Invalid separator in timestamp value.
The timestamp being entered or displayed contains a separator character (e.g., the colon 04:00) that is inconsistent with the Time Format currently specified in Options.

Parent topic: Error Messages