Add column Packed Decimal 1

[simian336]

Does anyone know the syntax to Alter table and add Packed-Decimal columns?

I have a field FRNPA that is FIELD TYPE=P, FIELD LENGTH=3, DEC POS=0 and I need to duplicate it with a tmp field.

Guessing something like

Alter table test add column TMPPA P(3,0)

Thanks

Simi

 

[mikrom]

I'm using DB2 on IBM iSeries and here the DECIMAL field is signed packed field.
So, if you need signed packed decimal with length 3, without decimal positions simply declare it as DECIMAL(3, 0)

 

[simian336]

That seems to have worked. Thanks!!

Simi