Why ALTER TABLE MODIFY COLUMN DOES NOT FUNCTION in IQ

[Former Member]

We needed to modify a numeric column in a table from numeric (11,2) to numeric(18,8), to do this we had to:

- create a new table

- loa dthe data from old table

-Rename the new table to old name.

We could have naturally create a new column in the table and copy the data and rename the column, but we did not want to chnage the order of the columns.

I am trying to understand the technical reasons behind the inexistence of MODIFY column where one want to modify data type in IQ, while it should be easir in IQ dans in ASE. My question is why modify coulmn in Sybase IQ is not working? what are the technical reasons for it?

Taghi

[RolandKramer]

Hello

Did you had a look to the latest changes in IQ 16.1?

https://help.sap.com/viewer/a8955ad084f210159c929ca62a38bfde/16.1.4.2/en-US

Best Regards Roland

[Former Member]

I have also run into this problem. I am running IQ 16.0 sp1. I wanted to increase the number of characters in one of the columns so I have to create a new column, copy the data, delete the old column then rename the new column.

Is there any reason the MODIFY function is not implemented in IQ?

[rafaelbahia]

Same problem here. Anyone knows of any plans to implement this feature? Running SAP IQ/16.0.110.2461/10487/P/sp11.09

[Former Member]

IQ version:

'Sybase IQ/15.4.0.3014/120310/P/ESD 1/Sun_x64/OS 5.10/64bit/2012-03-10 11:23:59'