List of errors that trigger the Skip Error Data function
When the errors shown in the following occur, they trigger the Skip Error Data function.
|
End code |
Details code |
Overview of error |
|---|---|---|
|
11 |
1 |
Extraction conditions are specified by date, but a character that cannot be compared as a date was found in the input data. |
|
2 |
The field type of output data is specified as D (date), but a character that cannot be converted to a date was found in the input data. |
|
|
4 |
||
|
12 |
8 |
Date operation is specified, but characters that exceed the maximum size of data operation are included in the input data. |
|
9 |
Date operation is specified, but a character for which date operation is not possible was found in the input data. |
|
|
20 |
1 |
A character that cannot be converted to a numeric value was found. |
|
43 |
1 |
The numeric data of the input CSV data begins with a period (.). |
|
3 |
Although the Enclosure character setting is specified, the character string is not enclosed by an enclosure character. |
|
|
5 |
The number of fields defined in the CSV format information and the number of fields in the file do not match. |
|
|
6 |
||
|
7 |
The field type of input data is specified as 9, but a character other than of the 9 type was found. |
|
|
8 |
The field type of input data is specified as F, but a character other than of the F type was found. |
|
|
9 |
The field type of input data is specified as S, but a character other than of the S type was found. |
|
|
11 |
The field type of input data is specified as F, but a character other than of the F type was found. |
|
|
15 |
The field type of input data is specified as Z, but a non-numeric character was found. |
|
|
16 |
A null character was found in the input data. |
|
|
17 |
The field type of input data is specified as D, but a non-date character was found. |
|
|
51 |
The field type of input data is specified as CSV, but the number of fields found in the input data exceeds the number of fields that can be processed. |
|
|
52 |
The number of fields defined in the CSV format information and the number of fields in the file do not match. |
|
|
55 |
The field type of input data is specified as CSV, but the number of fields found in the input data exceeds the number of fields that can be processed. |
|
|
66 |
The number of fields defined in the CSV format information and the number of fields in the file do not match. |
|
|
53 |
1 |
The input data cannot be converted to type N data. |
|
9 |
A character that cannot be converted to a numeric value was found during output to numeric type data. |
|
|
10 |
||
|
19 |
The input data cannot be converted to type X data. |
|
|
20 |
The input data cannot be converted to type N data. |
|
|
21 |
The input data cannot be converted to type X data. |
|
|
22 |
The input data cannot be converted to type N data. |
|
|
23 |
The input data cannot be converted to type N data. |
|
|
30 |
The field type of output data is specified as Z (numeric character string), but a character that cannot be converted to a numeric character string was found in the input data. |
|
|
31 |
||
|
38 |
A non-numeric character that cannot be included in a numeric operation is found in input data if the data is specified to be passed to a numeric operation. |
|
|
55 |
1 |
A character overflow occurred during the conversion to type 9. |
|
2 |
A character overflow occurred during the conversion to type B. |
|
|
3 |
||
|
4 |
||
|
7 |
A character overflow occurred during the conversion to type F. |
|
|
8 |
||
|
9 |
A character overflow occurred during the conversion to type S. |
|
|
10 |
A character overflow occurred during the conversion to type X. |
|
|
11 |
A character overflow occurred during the conversion to type M. |
|
|
12 |
A character overflow occurred during the conversion to type N. |
|
|
13 |
A character overflow occurred during the conversion to type I. |
|
|
14 |
A character overflow occurred during the conversion to type F. |
|
|
22 |
A character overflow occurred during the conversion to type D or type Z. |
|
|
27 |
A character overflow occurred during the conversion to type X. |
|
|
28 |
A character overflow occurred during the conversion to type N. |
|
|
29 |
||
|
31 |
A character overflow occurred during the conversion to type Z. |
|
|
32 |
A character overflow occurred during the conversion to type F. |
|
|
62 |
20 |
A field specified in the WHERE_ITEM argument of the REPLACE_DB function is of numeric type, but the input data is not numeric type data. |
|
34 |
A value in the DATE argument specified in the JULIANDAY function is invalid. |
|
|
52 |
There is an inconsistency between an argument in the DISPLAY_TO_Z function and the input data. |
|
|
65 |
There is an inconsistency between an argument in the Z_TO_DISPLAY function and the input data. |
|
|
66 |
There is an inconsistency between an argument in the DISPLAY_TO_Z function and the input data. |
|
|
67 |
A value that is not a numerical value is input in the input data of the Z_TO_DISPLAY function. |
|
|
102 |
A value in the MONTH argument specified in the CALC_MONTHS function is invalid. |
|
|
103 |
The input data in the CALC_MONTHS function is not a date string. |
|
|
117 |
A value in the MONTH argument specified in the CALC_MONTHS function is invalid. |
|
|
118 |
In an argument in the IF function a character string that cannot be converted into a date is specified as the comparison string of date type. |
|
|
123 |
The input data in the FORMAT_DATE function is not a date string. |
|
|
135 |
The input data of the FORMAT_NUM function is not a numeric value. |
|
|
147 |
Character code conversion in the TO_INCODE function failed. |
|
|
170 |
The input data of the SUBSTR function contains an invalid character. |
|
|
171 |
||
|
64 |
2 |
An attempt was made to use extraction conditions to convert a text string into a numeric value, but a character that cannot be converted was found in the input data. |
|
3 |
The input data cannot be used for the comparison of dates in a date extraction condition. |
|
|
65 |
1 to 9999 |
A custom error condition was met. |
|
66 |
1 to 9999 |
|
|
67 |
1 to 9999 |
|
|
68 |
1 to 9999 |
|
|
69 |
1 to 9999 |
|
|
70 |
1 to 9999 |
|
|
95 |
2 |
A number specified in the numeric operation formula exceeded the number of digits that can be specified. |
|
8 |
An attempt was made to divide by zero in the numeric operation formula. |
|
|
9 |
A character overflow occurred in the result of the numeric operation formula. |
|
|
10 |
A character overflow occurred during the calculation of the numeric operation formula. |
|
|
43 |
A number specified in the numeric operation formula exceeded the number of digits that can be specified. |
|
|
97 |
2 |
During the conversion to type X, a character that cannot be converted was found. |
|
3 |
||
|
4 |
During the conversion to a character string, a character that cannot be converted was found. |
|
|
6 |
Conversion is not possible for any of the following reasons.
|
|
|
7 |
A character that cannot be converted was found in the input data. |
|
|
9 |
||
|
11 |
Conversion is not possible for any of the following reasons.
|
|
|
12 |
A fraction resulted when a value was padded during conversion to type N data. |
|
|
20 |
Conversion is not possible for any of the following reasons.
|
|
|
24 |
||
|
30 |
||
|
34 |
||
|
56 |
An unregistered external character was found during conversion. |
|
|
57 |
Conversion is not possible for any of the following reasons.
|
|
|
58 |
An unregistered external character was found during conversion. |
|
|
59 |
Conversion is not possible for any of the following reasons.
|
|
|
60 |
An unregistered external character was found during conversion. |
|
|
61 |
Conversion is not possible for any of the following reasons.
|
|
|
62 |
||
|
73 |
||
|
74 |
||
|
87 |
||
|
102 |
2 |
When output was attempted from the middle of the field data, the length of the data was less than the specified data size. |
|
4 |
When output was attempted from the middle of the field data, the specified data size was 0. |
|
|
103 |
1 |
When output was attempted from the middle of the field data, the length of the data was less than the specified data size. |
|
2 |
When output was attempted from the middle of the field data, the specified data size was 0. |