Passing a parameter to a Stored Procedure

20 views
Skip to first unread message

Virginia Sarsfield

unread,
Apr 8, 2014, 10:52:58 AM4/8/14
to web-obje...@googlegroups.com
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

unread,
Apr 10, 2014, 12:29:05 PM4/10/14
to web-obje...@googlegroups.com
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.

- 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.

Reply all
Reply to author
Forward
0 new messages