Passing a parameter to a Stored Procedure

[Virginia Sarsfield]

I am a new user to WOW Community Edition.  I have a Stored Procedure (CL) that I can successfully call from WOW that runs an existing RPGLE print program.  What I want to do is enable the user to select a number of copies of that report and pass that number (CAST as a CHAR 2)  in the CALL to the Stored Procedure ... How do I do that?

[King, Wesley]

Hey Virginia.  

You should be able to tell WOW which field descriptor to use for your prompt by field descriptor id.  

Example: CALL schema.table ( ?12345 )

I'm not sure if you've searched the WOW Builders guide yet, so I apologize if this is repeat information.  Here are few links with info that may help out.

• https://sites.google.com/a/planetjavainc.com/wow_builders_guide/home/36-stored-procedures
  
• https://sites.google.com/a/planetjavainc.com/wow_builders_guide/home/17-parameters/SQL--Field-Descriptor-Prompt

Let me know if you want me to expand further.  Hope this helps.

- Wes

On Tue, Apr 8, 2014 at 7:52 AM, Virginia Sarsfield <vasar...@gmail.com> wrote:

I am a new user to WOW Community Edition.  I have a Stored Procedure (CL) that I can successfully call from WOW that runs an existing RPGLE print program.  What I want to do is enable the user to select a number of copies of that report and pass that number (CAST as a CHAR 2)  in the CALL to the Stored Procedure ... How do I do that?

--
You received this message because you are subscribed to the Google
Groups "Web Object Wizard Community PlanetJ" group.
To post to this group, send email to web-obje...@googlegroups.com
To unsubscribe from this group, send email to
web-object-wiz...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web-object-wizard?hl=en?hl=en
To add features to your CE software, visit PlanetJ at www.planetjavainc.com/products
---
You received this message because you are subscribed to the Google Groups "Web Object Wizard Community PlanetJ" group.
To unsubscribe from this group and stop receiving emails from it, send an email to web-object-wiz...@googlegroups.com.
Visit this group at http://groups.google.com/group/web-object-wizard.
For more options, visit https://groups.google.com/d/optout.