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
 

 

Problems while creating Stored Procedures and Triggers

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

New User


Joined: 05 Apr 2005
Posts: 9
Location: india

PostPosted: Thu Jun 23, 2005 4:45 pm    Post subject: Problems while creating Stored Procedures and Triggers
Reply with quote

I am under training in Mainframes, my current subject is DB2. I am getting lots of problems while creating Stored Procedures and Triggers. I am not getting the valid syntax for it. Can anyone of you help me giving me the exact syntax. My table name is CAPR and have columns like CID, CNAME, CSAL and Netsal. Please form some example based on these.
thanks
Greetings
Sandeep.

TITLE EDITED

WARNING:
USE MEANINGFUL TOPIC TITLE.
REMOVE THE LINK FROM YOUR SIGNATURE.
READ FORUM RULES.
Back to top
View user's profile Send private message

sudheer648

New User


Joined: 23 May 2005
Posts: 97
Location: Chennai

PostPosted: Thu Jun 23, 2005 5:49 pm    Post subject: Re: Can anyone help me?
Reply with quote

HI webxpertin ,


Writing and preparing an external
http://publib.boulder.ibm.com/infocenter/dzichelp/index.jsp?topic=/com.ibm.ims.doc.apdb_8.1.0/ie0p3mst97.htm
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Thu Nov 03, 2005 2:37 pm    Post subject: triggers
Reply with quote

hi frnd,
plz gothru the syntax of trigger and then try once agin. hope u have gone wrong with some syntax errors. gothru the book and then go ahead
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 Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Creating an 'Enter' event with IMS MF... dileep chirasani Java & MQSeries 1 Sat Aug 06, 2016 2:23 am
No new posts Is possible to call subprogram from c... cmsmoon COBOL Programming 3 Fri Aug 05, 2016 6:46 pm


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