SQL/MX 2.3.x to SQL/MX 3.0 Database and Application Migration Guide (H06.22+, J06.11+)

Considerations for upgrading to SQL/MX Release
3.0
HP NonStop SQL/MX 2.3.x to SQL/MX 3.0 Database and Application Migration Guide—666210-002
2-8
Conversions from numeric to char or varchar

Example 1
>>create table tnumeric (a numeric (18,6));
--- SQL operation complete.
>>insert into tnumeric values (123456789012.345678);
--- 1 row(s) inserted.
>>select cast(a * 10 as char(18)) from tnumeric;
*** ERROR[8402] A string overflow occurred during the evaluation of a
characterexpression. Conversion of Source Type:DECIMAL
SIGNED(REC_DECIMAL_LSE) Source
Value:0x2B0001020304050607080900010203040506070800 to Target
Type:CHAR(REC_BYTE_F_ASCII).
--- 0 row(s) selected.