SQL Alter Column for Numeric Fields

Posted by rickkus on 30-Jan-2013 14:27

I am attempting to alter the width of a numeric field using an SQL Alter command. Here is an example of what I am trying to accomplish:

alter table SOME_SCHEMA.SOME_TABLE alter column SOME_NUM_FIELD set PRO_SQL_WIDTH 8,0

I see from this post that this is possible, but this syntax only works for character fields:


I've also seen documentation here that says this type of altering is not available for numeric fields:


Does this functionality really not exist for numeric fields? Every other database I've worked with previously has always allowed me to alter both numeric and character fields.

Is my only alternative for altering numeric fields through a native utility?


All Replies

This thread is closed