CA Dataquery displays the following messages on your query output when it encounters a problem in a column when processing a query request.
The following are the special error codes for the DQL Mode PRINT and DISPLAY commands.
A numeric column named in a SET, PRINT, or DISPLAY command contains non-numeric data.
A SET statement with a division operation was processed but a zero divisor was detected.
The final result of a SET statement is too large to fit in the temporary result. The integer portion of the precision definition is too small.
A column named in a SET statement belongs to a table not named in a FIND statement.
The SET statement is too complex. You can nest parentheses only to 10 levels.
The accumulated amount of the column is too large and an overflow resulted.
One or more columns used to develop this total are in error.
Internal Error - collect data on the query, a dump of the request, and call support.
The column belongs to a CA Datacom/DB row deleted by another batch or online job after the FIND executed but before the PRINT, SET, or DISPLAY executed.
The edit pattern provided does not allow the data value to be displayed without truncation of significant digits.
Internal Error - collect data on the query, a dump of the request, and call support.
A positive numeric column named in a PRINT, SET, or DISPLAY command contains more than 18 digits in decimal representation.
A negative numeric column named in a PRINT, SET, or DISPLAY command contains more than 18 digits in decimal representation.
A floating-point format number cannot be displayed because its absolute value is less than 1e - 78.
CADATE format error.
COUNT verb is not valid for any variation of the CA Dataquery JOIN processing. The COUNT verb is only valid for a single table query or multiple table queries using RELATED-BY. A JOIN in any part of a multiple table query will receive this error when the COUNT verb is also used.
|
Copyright © 2014 CA.
All rights reserved.
|
|