RE: Passing equivalent of VB value vbNull in an RPG Program

[Richard Schoen <richard@xxxxxxxxxxxxxxx>]

They are actually using our RPG2SQL product and they want to pass a NULL value TO one of the parameter values in the stored procedure from the RPG app. 

We have a procedure for passing parm data to stored procedures.

The call is from the iSeries via our service program to our PC component which live on a Windows server and does the actual DB connectivity.

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
------------------------------

message: 2
date: Wed, 28 Nov 2012 16:05:45 -0700
from: Alan Campin <alan0307d@xxxxxxxxx>
subject: Re: Passing equivalent of VB value vbNull in an RPG Program

Are you saying that this value is being passed in a stored procedure call from the PC side? If yes, if the field is null, the OS always passes the null as a 0 or 1 flag.


On Wed, Nov 28, 2012 at 4:00 PM, Richard Schoen <richard@xxxxxxxxxxxxxxx>wrote:

> Just curious if anyone can answer this with certainty before I 
> research more.
>
> Have an RPG field as such to represent Null value:
> D Null            S              1A   Inz(X'00')
>
> Customer needs to pass this value to an API call in one of our service 
> programs and it goes thru EBCDIC to ASCII translation.
>
> Anyone know if this actually translates to an appropriate PC null value ?
>
> If not, do you know what character might translate to vbNull.
>
> Thanks in advance for any feedback.
>
> Regards,
> Richard Schoen
> RJS Software Systems Inc.
> Where Information Meets Innovation
> Document Management, Workflow, Report Delivery, Forms and Business 
> Intelligence
> Email: richard@xxxxxxxxxxxxxxx<mailto:richard@xxxxxxxxxxxxxxx>
> Web Site: http://www.rjssoftware.com<http://www.rjssoftware.com/>
> Tel: (952) 736-5800
> Fax: (952) 736-5801
> Toll Free: (888) RJSSOFT
>
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing 
> list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, 
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a 
> moment to review the archives at http://archive.midrange.com/rpg400-l.