test a stored proc

Posted on 2006-03-27
Last Modified: 2008-03-17
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.
Question by:royalcyber
    LVL 14

    Expert Comment

    you can do it through Iseries Navigaor under databases.

    It is the Run SQL script option


    Author Comment

    i am using WSAD for iseries ; it has remote explorer but it does not have databases in it

    can u pl shelp
    LVL 14

    Expert Comment

    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.

    LVL 17

    Accepted Solution

    You can embed your SP to RPG program (SQLLE). Then you can test it.

    BR Dushan
    LVL 13

    Expert Comment

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

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This paper addresses the security of Sennheiser DECT Contact Center and Office (CC&O) headsets. It describes the DECT security chain comprised of “Pairing”, “Per Call Authentication” and “Encryption”, which are all part of the standard DECT protocol.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now