IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Problems while creating Stored Procedures and Triggers


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
Reply with quote

HI webxpertin ,


Writing and preparing an external
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: 677
Location: NJ

PostPosted: Thu Nov 03, 2005 2:37 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts C++ problems Java & MQSeries 3
No new posts Creating Unix Directory using COBOL i... COBOL Programming 2
No new posts Creating Report using SORT DFSORT/ICETOOL 7
No new posts MFT File transfer problems All Other Mainframe Topics 5
No new posts Creating CSV file from Variable recs ... DFSORT/ICETOOL 11
Search our Forums:

Back to Top