Re: Question on converting a VARLEN field to a CHAR field in a LF

[Reeve <rfritchman@xxxxxxxxx>]

Sure.

In a logical with a different format name, define a fixed-length field like
this:
     A            FHXF30        30          RENAME(FHXF)
     A          K FHXF30

This is a handy technique when you want to build a multi-format logical
over key fields (columns) of different lengths; this approach enables
powerful lookup and search applications.  In SQL, you'd use the UNION ALL
clause and SQL happily resolves column size differences.

On Wed, Jan 20, 2021 at 8:27 AM <dfreinkel@xxxxxxxxxxxxxxxxx> wrote:

> I have a OPM RPG program that I added a new file to. All the fields in the
> added file are variable length fields.
>
>
>
> I need to chain to the file and update a flag in that file.
>
>
>
> I cannot compile the program because OPM RPG does not support variable
> length fields.
>
>
>
> I compiled using CVTOPT(*VARCHAR) but that does not convert the key fields.
>
>
>
> Is there a way to redefine a variable length field as a char field in a
> logical file?
>
>
>
> Thanks
>
>
>
> Darryl Freinkel
>
> A4G
>
> Telephone: 770.321.8562 Mobile: 678.355.8562
>
>
>
> --
> 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