Re: SQL SP - Using Decimal (8,6) for Parameters

[Michael Ryan <michaelrtr@xxxxxxxxx>]

Hmmm...I'm wondering if I have a different issue. I'm trying a different
technique than I've used in the past with this type of thing. I'm trying to
connect to a different system based on a parameter. So I have an:

         Exec Sql
           Connect to <system> User :WebUser Using :WebPass;

in my code. It's actually two different connects conditioned by a Select
statement. I *know* I'm connecting to the right system - I can see the
incoming connection as an active job.

I've tried a wrapper with CL (as an SP) to do the decimal conversion to
character....doesn't seem to be working.


On Fri, Jul 12, 2013 at 10:52 AM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

> I've also tried using slash and dot for the separator between the library
> and procedure.
>
>
> On Fri, Jul 12, 2013 at 10:50 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>wrote:
>
> > Could you please poste how the parameters are defined and how you call the
> > procedure?
> >
> >
> > Mit freundlichen Grüßen / Best regards
> >
> > Birgitta Hauser
> >
> > "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> > Brown)
> > "If you think education is expensive, try ignorance." (Derek Bok)
> > "What is worse than training your staff and losing them? Not training them
> > and keeping them!"
> >
> > -----Ursprüngliche Nachricht-----
> > Von: midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Michael Ryan
> > Gesendet: Friday, 12.7 2013 15:41
> > An: Midrange Systems Technical Discussion
> > Betreff: SQL SP - Using Decimal (8,6) for Parameters
> >
> > I'm having trouble calling a stored procedure (i to i) that's using
> > decimal
> > parameters. I'm getting an SQL0204 - Not Found - when it's clearly there.
> > I
> > can call another SP that's defined the same way (calling a different
> > program
> > with all character parms), and that works fine. I know that if an SP won't
> > be found if it isn't called with the right parms, and I'm thinking I'm
> > running into that for some reason. Anyone have any ideas why (or if)
> > specifying decimal parms would matter? Thanks!
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> > unsubscribe,
> > or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> > moment to review the archives at http://archive.midrange.com/midrange-l.
> >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.