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.
Greeting and thanks,
Andreas
________________________________________________________________
Mit der Grupppen-SMS von WEB.DE FreeMail k�nnen Sie eine SMS an alle
Freunde gleichzeitig schicken: http://freemail.web.de/features/?mc=021179
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
