I need to prepare a cursor column as n (12, 8)

I’m trying:

select field1, field2, ..., val(“000.00000000”) as MyNumericField ...


but I’m getting a numeric with format n(15,2) for MyNumericField

Could somebody give a hint in order to get the numeric field as n(12,8)?

Thanks in advance and regards.


Oscar Corte