Re: *varying vs varchar

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Thanks Charles - I knew there was something wrong with Options(*varchar) but since it _appeared_ to be from real code ...


Jon P.

> On Apr 29, 2022, at 11:05 AM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
>
> There is no options(*varchar)
>
> I assume from the title you mean options(*varsize)
>
> options(*varsize) and varchar()/varying are two very different things
>
> ...and Jon beat me to the details... :)
>
> Charles
>
> On Fri, Apr 29, 2022 at 8:37 AM Greg Wilburn <
> gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> > I have an older procedure interface defined like this:
> >
> > dcl-pr  myProc;
> >  myfield              char(6) const options(*varchar);
> >  myfield2            char(100) const options(*varchar);
> > end-pr;
> >
> > If I call this procedure like this:
> >
> > Callp  myProc('123':'This is myfield2');
> >
> > The value of myfield in the procedure is not just "123"...
> >
> > What am I missing?
> > Should I change the Procedure Interface to be VARCHAR instead?  And what
> > are the ramifications of that?
> >
> > I apologize for asking as I have a strange sense of déjà vu.
> >
> > [Logo]<https://www.totalbizfulfillment.com/>    Greg Wilburn
> > Director of IT
> > 301.895.3792 ext. 1231
> > 301.895.3895 direct
> > gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
> > 1 Corporate Dr
> > Grantsville, MD 21536
> > www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>
> > --
> > This is the RPG programming on IBM i (RPG400-L) mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/rpg400-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com
> -- 
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com