Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 401
  • Last Modified:

test a stored proc

I have created a sample stored procedure which should return the customer details from the customer file. I am not able to test it at the backend.

Can someone pls recommend me how can i test it

The procedure is TESTSTPROC in library SNEHA.
0
royalcyber
Asked:
royalcyber
1 Solution
 
daveslaterCommented:
Hi
you can do it through Iseries Navigaor under databases.

It is the Run SQL script option

Dave
0
 
royalcyberAuthor Commented:
i am using WSAD for iseries ; it has remote explorer but it does not have databases in it

can u pl shelp
0
 
daveslaterCommented:
Hi
Operastions navigator is part of client access, it comes on some CD's and is loaded onto your PC.

I am not too sure if you can do it via WSAD.

Dave
0
 
Dushan De SilvaTechnology ArchitectCommented:
You can embed your SP to RPG program (SQLLE). Then you can test it.

BR Dushan
0
 
samic400Commented:
If you are looking to test it from an Intel platform, with ASP code, I could provide some assistance.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now