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
 

 

How to test Stored Procedure using Xpediter

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
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    Post subject: How to test Stored Procedure using Xpediter
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts Calling procedure with multiple entri... steve-myers PL/I & Assembler 5 Fri Jan 27, 2017 3:33 pm
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 COOLGEN - TSO TEST FACILITY indianrajput CA Products 4 Wed Nov 02, 2016 9:28 pm


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