View previous topic :: View next topic
|
Author |
Message |
Heindba
New User
Joined: 11 May 2010 Posts: 16 Location: South Africa
|
|
|
|
Hi all,
I am trying to run the following statement and have read up and I know that something is wrong on my where clause according to the manuals, but not sure what. some expert help would be appreciated. Here is the Statement I am executing using spufi:
Code: |
CREATE TRIGGER STRDEVN.CS00504I
AFTER INSERT ON STRDEVN.ORDR_ONL_RCVD
REFERENCING NEW AS N
FOR EACH ROW
MODE DB2SQL
WHEN (OOR_ORDR_STA = 1
AND OOR_LUD_ID = 'CMAX')
BEGIN ATOMIC
CALL CS00504(N.OOR_REV_CRE_TMSTMP
,N.OOR_ORDR_STA);
END:
COMMIT: |
Please tell me what you can see.
thanks and much appreciated. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You don't have a WHERE . . . ?
What error(s) are being shown? |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Please post error message |
|
Back to top |
|
|
Heindba
New User
Joined: 11 May 2010 Posts: 16 Location: South Africa
|
|
|
|
Apologies, this is the Error message that I am getting:
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -20100, ERROR: AN ERROR OCCURRED WHEN BINDING A TRIGGERED
SQL STATEMENT. INFORMATION RETURNED: SECTION NUMBER : 1 SQLCODE
-203, SQLSTATE 42702, AND MESSAGE TOKENS OOR_ORDR_STA
DSNT418I SQLSTATE = 56059 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXORSO SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -630 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFD8A' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
Quote: |
-203, SQLSTATE 42702 |
and ... what happened when You looked Yourself at the manuals to understand the SQLCODE and the SQLSTATE
even a simple google search would have provided You with an answer faster than a forum
( just a plain cut and paste of the quoted string ) |
|
Back to top |
|
|
Heindba
New User
Joined: 11 May 2010 Posts: 16 Location: South Africa
|
|
|
|
My bad, I read the start of the error message where it contains the -20100 of the message so I went searching for that. |
|
Back to top |
|
|
|