Hello Elke,
"Zabach, Elke" wrote:
>
> Dirk Zoettl wrote:
>
> > first of all for doing arithmetics the column type of
> > Pos has to bee changed. Replace "Pos LONG NOT NULL,"
> > by "Pos FIXED(5) NOT NULL," .
>
> I do not think that Tilmann was able to create a table with
> a long column as primary key. Therefore I think, LONG was
> a misspelling in the mail.
> If not, I would like to know.
>
[...snip...]
I was surprised that the following SQL commands did not give any errors:
create table aaa ( bbb long primary key, nnn fixed(5))
insert into aaa ( bbb , nnn ) values ('murks', 4711)
insert into aaa ( bbb , nnn ) values ('und geht doch, aber warum', null)
The JDBC Metadata stated, that bbb actually is the only primary key column.
Tested with DbVisualizer 2.1 on:
SAP DB Kernel 7.3.0 Build 020-000-000-000
SAP DB package com.sap.dbtech.jdbc, "SAP DB JDBC Driver", "SAP AG", "7.3.0 Build
021-000-085-000"
Sincerely,
Dirk Z�ttl
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
