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

How to test Stored Procedure using Xpediter


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
jasmitha

New User


Joined: 18 Dec 2007
Posts: 1
Location: chennai

PostPosted: Fri Feb 08, 2008 2:33 pm
Reply with quote

Hi All,


Please any one tell about how to test Stored Procedure useing Xpedit.

Thanks in advance.
Back to top
View user's profile Send private message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Fri Feb 08, 2008 3:37 pm
Reply with quote

Hi

I think we can't test Store Procedures using debugging tools.

Best way is using Display stmts or lets look for better answers from other members.

Cheers
Ashwin
Back to top
View user's profile Send private message
dr_te_z

New User


Joined: 08 Jun 2007
Posts: 71
Location: Zoetermeer, the Netherlands

PostPosted: Mon Feb 11, 2008 5:13 pm
Reply with quote

Don't know about Xpedit, but with the IBM debugger is works great. The "DISPLAY" alternative does not work for stored procedures. When you're really desparate you can generate a "snapshot" dump.
Back to top
View user's profile Send private message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Tue Feb 12, 2008 12:38 pm
Reply with quote

Hi,


The display statements works fine atleast in Cobol-Db2 (i have worked on it).

We used to execute the Stored procedure by calling it through another program, when you keep diaplay's in your procdure it won't show in the spool (with the Job name and User information) instead we need to change it setting's as User as Db2* and some more.

And i think IBM debugger something related to windows debugging tool not the Mainframes debugging tool (Just a Guess, heard about it long back).

Please correct me if i am wrong.

Cheers
Ashwin
Back to top
View user's profile Send private message
diwa_thilak

Active User


Joined: 13 Jul 2006
Posts: 205
Location: At my desk

PostPosted: Mon Mar 03, 2008 6:05 pm
Reply with quote

Bhargavi,

We cannot Xped the Store proc as it is. One simple way is to convert the store proc to Cobol program.

Its not a big deal, you can save the store proc as a cobol program by removing the store proc specific statements available in the first two lines of the program.

Just delete those lines and save it as a cobol program in the library and Xped.

Just try and let me know if you still have any questions.
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 -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts Zunit Test case editor error Testing & Performance 4
No new posts Invoke stored procedure via batch JCL. DB2 2
No new posts Calling COBOL DB2 program from a COBO... COBOL Programming 2
No new posts Copying GDG version(all/few) from pro... CLIST & REXX 13
No new posts Cond parameter and Rc code of a proce... JCL & VSAM 5
Search our Forums:

Back to Top