Andreas Grund wrote:
>
> Hi,
>
> i created a simple table:
> CREATE TABLE "ROOT"."3_0_TEST"
> (
> "ID" Fixed (10,0) NOT NULL DEFAULT
> SERIAL (1),
> "NAME" Varchar (30) ASCII,
> "DATE" Timestamp DEFAULT TIMESTAMP,
> PRIMARY KEY ("ID")
> )
>
> ROOT ist the SYSDBA. First i want to enter some datas in the
> table with:
> insert into "3_0_TEST" ("NAME","DATE") values ('Dirk',
> '20030515000000')
> but i get the Error Invalid timestamp format:ISO. I tried the
> format 2003-05-15 a well, but it does not work. So I wanted
> to change the datatype of the colum date from timestamp to
> date, because only the date is interessting and not the time.
> But i get following error:
>
> ---- Error -------------------------------
> Auto Commit: Off, SQL Mode: Internal, Isolation Level: Committed
> Communication link failure;-807 Connection down, session released.
> ROLLBACK
>
> I tried it several times and get everytime the same error.
> For the change i use the SQL-Studio-Assistent to alter the
> table (right click on the table and then Alter table) and I
> tried an sql-statement in the sql-dialog too. Without any
> success. Where is my failure?? My OS is WinNT 4.0 SP 6 and i
> work with SAP DB 7.4.3.17.
>
It's unfortunately a bug in the kernel.
Will be fixed with the next version, see PTS 1122684.
Try to drop the default before modifying the table
(or drop it and recreate it. no problem in your case).
Thank you for reporting
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
