View previous topic :: View next topic
|
Author |
Message |
jasmitha
New User
Joined: 18 Dec 2007 Posts: 1 Location: chennai
|
|
|
|
Hi All,
Please any one tell about how to test Stored Procedure useing Xpedit.
Thanks in advance. |
|
Back to top |
|
|
ashwinreddy
Active User
Joined: 16 Sep 2004 Posts: 106 Location: Hyderabad
|
|
|
|
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 |
|
|
dr_te_z
New User
Joined: 08 Jun 2007 Posts: 71 Location: Zoetermeer, the Netherlands
|
|
|
|
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 |
|
|
ashwinreddy
Active User
Joined: 16 Sep 2004 Posts: 106 Location: Hyderabad
|
|
|
|
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 |
|
|
diwa_thilak
Active User
Joined: 13 Jul 2006 Posts: 205 Location: At my desk
|
|
|
|
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 |
|
|
|