cancel
Showing results for 
Search instead for 
Did you mean: 

SQL to Alter Table Partitioned

02-04-2019 7:52 PM
savoine Explorer
593 views 1 comments
0 Likes
SAP Managed Tags
Subscribe

I need to change the size of decimal places in a field, but the table is partitioned and the message I can not do, what is the correct procedure?

ALTER TABLE "S_ADMIN"."HDW_PS" ALTER ("VLR_LIQUIDO01" DECIMAL(10,3));

SAP DBTech JDBC: [7]: feature not supported: modifying partition column failed: VLR_LIQUIDO01: line 1 col 43 (at pos 42)

0 Likes

Accepted Solutions (0)

Answers (1)

Answers (1)

pfefferf
Active Contributor

The message should be clear. The field is used to decide to which partition a data record is assigned. So you cannot change the field type. If you wanna do that, you have to undo the partitioning, adjust the field type and then create the partitions again.