Re: Calling a Stored iSeries stored procedure from MS SQL Studio

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Elvis

That'd be very handy!

Vern

Elvis Budimlic wrote:
> Vern, while data type is part of the signature for UDFs, I don't think same
> holds for SPs.
>
> Elvis
>
> Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
> OS/400
> www.centerfieldtechnology.com
>
>
> -----Original Message-----
> Subject: Re: Calling a Stored iSeries stored procedure from MS SQL Studio
>
> Carl
>
> I will ancticipate a problem - besides my spelling!!
>
> Be sure either to have your parameters defined as VARCHAR for character 
> types - or have your SQL programmer cast the values to CHAR.
>
> SQL on iSeries treats literal character values as VARCHAR and will not 
> find the stored procedure if you defined it with CHAR.
>
> Vern
>
>
>