Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

While creating trigger im getting -20100 SQL abend

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
nileshbhosle

New User


Joined: 25 Feb 2008
Posts: 9
Location: hydrabad

PostPosted: Thu Mar 27, 2008 5:14 pm    Post subject: While creating trigger im getting -20100 SQL abend
Reply with quote

while creating trigger im getting -20100 SQL abend
wht is this abend ..
Back to top
View user's profile Send private message

Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 788
Location: Chennai, India

PostPosted: Thu Mar 27, 2008 5:24 pm    Post subject:
Reply with quote

MVS QW gave better explanation for this abend...
Please follow the instructions given on Programmer Response...
Back to top
View user's profile Send private message
Mohankalyan99

New User


Joined: 06 Apr 2005
Posts: 16

PostPosted: Thu Sep 10, 2009 5:24 pm    Post subject: While creating trigger im getting -20100 SQL abend
Reply with quote

Here is the trigger I am using:

CREATE TRIGGER TG1
AFTER INSERT ON TABLE1
REFERENCING NEW AS N
FOR EACH ROW MODE DB2SQL
BEING ATOMIC
DECLARE X CHAR(1);
DECLARE Y CHAR(9);
SET (X,Y) = (SELECT OWN_TYPE, EMP_NO
FROM TABLE2 B
WHERE B.BAR_CODE = N.BAR_CODE
AND B.CURRENT = 'C')
END

I am also getting the -20100 SQL abend with SQLCODE=-199 at the time of execution of First Declare statement.
when i check QW, A syntax error was detected in the statement at the point where the keyword keyword appears.
And also saying partial list of VALID tokens is provided in SQLERRM as token-list.
But I couldn't get the valid list and I am not able to execute that trigger.

Can you please help me on how to get the valid list else what all token can i use as variables?

Thanks
Mohan Kalyan.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts hot to get details when "EXEC CI... Andi1982 CICS 11 Tue Sep 20, 2016 5:01 pm
No new posts Creating an 'Enter' event with IMS MF... dileep chirasani Java & MQSeries 1 Sat Aug 06, 2016 2:23 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us