Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
Altering table to add long varchar results in 7032
From: Konrad Bloor (konradintercognition.com)
Date: Wed Jun 02 2004 - 12:58:24 CDT
I wonder whether anyone can help. I'm trying to add a LONG VARCHAR column
to an existing table, and I can't get it to work. (Not in Oracle mode).
Consider an example in SQL Studio, where I set up this test table:
create table test (
If I try to add a long varchar to this table using the following expression:
alter table test add thirdcol long varchar
I get the following error:
Native error: -7032
Text: [SAP AG][SQLOD32 DLL][SAP DB]General error;-7032
POS(32768) SQL statement not allowed for column of data type LONG:THIRDCOL.
What I need to know is how to add an empty LONG VARCHAR column to this
existing table. I'd REALLY appreciate any pointers with this one.
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb