Ralf Schneider wrote: > how can I modify the code typ of a LONG column from ASCII to BYTE? > > I tried: > ALTER TABLE tab1 MODIFY (col1 LONG BYTE) > > but this brings an error message: Datatypes must be compatible. > > I also tried to drop the column but this also results in an error. > > Is there a way to change the code type of this column?
Within the kernel you do not have any chance to drop it or to change the column-type by now. You will need to use the replication manager to store the tables data inclusive LONG, to drop the table, to recreate it with the new LONG definition and to load the stored data. We are working on the possibility to add/drop LONG-columns. We have to decide if changing of ASCII-->BYTE should be possible. Elke _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
