Andreas Goldstein wrote :
>
>Hi Listmembers,
>
>I try to define a updateable join view with the followin statements:
>
>CREATE TABLE WWIND.KD (
> KUNDENNR FIXED(10) default serial PRIMARY KEY,
> FIRMA CHAR(40) NOT NULL,
> KONTAKTPERSON CHAR(30),
> FUNKTION CHAR(30)
>)
>//
>CREATE TABLE WWIND.ADR (
> ADRESSNR FIXED(10) PRIMARY KEY,
> STRASSE CHAR(60),
> ORT CHAR(15),
> REGION CHAR(15),
> PLZ CHAR(10),
> LAND CHAR(15),
> TELEFON CHAR(24),
> TELEFAX CHAR(24),
> FOREIGN KEY (ADRESSNR) REFERENCES WWIND.KD ON DELETE CASCADE
> )
> //
>CREATE VIEW WWIND.VKUNDEN AS
> SELECT
> K.KUNDENNR,
> K.FIRMA,
> K.KONTAKTPERSON,
> K.FUNKTION,
> A.STRASSE,
> A.ORT,
> A.REGION,
> A.PLZ,
> A.LAND,
> A.TELEFON,
> A.TELEFAX
> FROM WWIND.KD K INNER JOIN WWIND.ADR A
> ON K.KUNDENNR = A.ADRESSNR
>WITH CHECK OPTION
>
>
>After commiting these statements to the DB I am able to insert records
>through the view by the following statement:
>
>INSERT INTO WWIND.VKUNDN (FIRMA, STRASSE, ORT, PLZ, LAND, KUNDENNR)
>VALUES ('Company', 'Streetname', 'Cityname', '12345', 'DE', 100)
>
>
>But when I try to delete or update the record by one of the following
>statements I receive an errormessage :(
>
>UPDATE WWIND.VKUNDEN SET FIRMA = 'Firmenname' WHERE KUNDENNR = 100
>//
>DELETE FROM WWIND.VKUNDEN WHERE KUNDENNR = 100
>
>The DBMS states in both cases:
>Base table not found; -4004 POS(xy) Unknown table name:VKUNDEN
>
>So this seems not be an updateable view. Can someone please
>explain what is
>the reason for this and how I can modify the view- or
>tabledefinitions to
>get an updateable join view?
>
>Thanks a lot & Best regards
>I assume WWIND is a schema, not a user ? Seems that schemas are not considered there yet, i.e. this is a bug ! Best Regards, Thomas
smime.p7s
Description: S/MIME cryptographic signature
