subject:"How to add a LONG with default value to a table"

RE: How to add a LONG with default value to a table

2006-01-31 Thread Kittel, Martin

Hi Michael, >ALTER TABLE "DBA"."A_PERSON" ADD ("COMMENT2"LONG ASCII DEFAULT '') ><<< > >the error > > >>> > Error --- >Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed > General error;-7035 POS(32768) DEFAULT specification not allowed for >this

How to add a LONG with default value to a table

2006-01-31 Thread mp

Hi group, the definition of a table with a field of type long with the default value '' such as >>> CREATE TABLE "DBA"."A_PERSON" ( "ID" IntegerNOT NULL, "NAME" Char (20) ASCII DEFAULT '', "COMMENT"Long ASCII DEFAULT '', PRIMARY KEY