SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Parser and Compilation Messages (3000 through
3999)
HP NonStop SQL/MX Messages Manual—523730-004
5-11
SQL 3039
Cause. You specified a PIC X type with COMP, which is not supported.
Effect. The operation fails.
Recovery. Remove the COMP, or redefine the type, and resubmit.
SQL 3040
Cause. You specified an item with precision zero. You must add the number nine to
the PICTURE clause.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 3041
Cause. You specified UNSIGNED for a numeric or decimal type that has a scale
greater than nine, which is not supported.
Effect. The operation fails.
Recovery. Change the specification to SIGNED and resubmit.
SQL 3042
Cause. You specified UPSHIFT for a numeric type, which is not supported.
Effect. The operation fails.
Recovery. Change the specification and resubmit.
3039 PIC X types do not have any COMP representation.
3040 Precision zero is not valid. Add a '9' to the PICTURE
clause.
3041 UNSIGNED is not valid for a numeric or decimal type with
a scale greater than 9.
3042 UPSHIFT for a numeric type is not valid.