Previous Topic: -229 - TOO MANY DIGITS PER NODE IN STRING: xxxxNext Topic: -231 - NUMBER OF SLASHES IS n, ONLY TWO ALLOWED: xxxx


-230 - THE VALUE OF A NODE IS OUT OF RANGE: xxxx

Explanation

The DATE/TIME function is scanning a character string to determine its DATE/TIME format but has detected invalid characters in the string (xxxx). The query you issued probably contains a character string representation of a date, time, or TIMESTAMP in an invalid format. See the CA Datacom/DB SQL User Guide for correct formats.

The SQLSTATE that equates to this SQL return code is 22008.

User Response

Ensure the character string in the query is the proper format.