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

Michael - saying "decimal parameters" is only part of the picture. Can you show us the definition and the call? It sounds like a signature error so I'm guessing that something you think is packed is actually zoned or vice-versa.


On 2013-07-12, at 9:40 AM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

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.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com