SQLCODE -104 in CREATE TRIGGER

[Tborn2b]

DB2 V 7, Z/OS:

I receive an SQLCODE -104 for the following trigger :

CREATE TRIGGER TRSERED1
NO CASCADE BEFORE
INSERT
ON SEMINAR
REFERENCING
NEW AS ZUGANG
FOR EACH ROW
MODE DB2SQL
WHEN
( ZUGANG.REFNR IS NOT NULL )
BEGIN ATOMIC
SET ZUGANG.RNNAME_R ED=
( SELECT RNNAME
FROM REFERENT
WHERE REFNR=ZUGANG.RE FNR );
END ß

The corresponding error - message is:

DSNT408I SQLCODE = -20100, ERROR: AN ERROR OCCURRED WHEN BINDING A TRIGGERED
SQL STATEMENT. INFORMATION RETURNED: SECTION NUMBER : 2 SQLCODE -104,
SQLSTATE 42601, AND MESSAGE TOKENS RNNAME,+ ) -
DSNT418I SQLSTATE = 56059 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

What is wrong with the statement? I tried everything. Can anyone help me?

I would be very gladful for help!!!!!

Thanx
Peter

[Serge Rielau]

Re: SQLCODE -104 in CREATE TRIGGER

I don't think that DB2 V7 z/OS supports scalar fullselects.
Try SELECT INTO.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Tborn2b]

Re: SQLCODE -104 in CREATE TRIGGER

Serge Rielau <srielau@ca.e ye-bee-m.com> wrote in message news:<bs6q5h$pc a$1@hanover.tor olab.ibm.com>.. .[color=blue]
> I don't think that DB2 V7 z/OS supports scalar fullselects.
> Try SELECT INTO.
>
> Cheers
> Serge[/color]

Thanks a lot for your prompt answer. I will try this.
Bye Peter