Re: Can you convert a variable length field to a fixed length field in a LF? -- MIDRANGE-L

Subject: Re: Can you convert a variable length field to a fixed length field in a LF?
From: dlclark@xxxxxxxxxxxxxxxx
Date: Wed, 2 Oct 2019 13:28:07 -0400
List-archive: <https://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@lists.midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.lists.midrange.com>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on 10/02/2019
01:25:29 PM:

I have a situation where I have a key field that was defined by mistake

a variable length field. This is not a problem for ILE programs but it

not allowed for a OPM RPG program where we need to add a new file to the
RPG code.

I am trying to see if its possible to convert the field to a fixed

length

field in a logical file?

Does anyone have some feedback?

You can create an SQL VIEW that CASTs the VARCHAR column as CHAR.

Sincerely,

Dave Clark

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Can you convert a variable length field to a fixed length field in a LF? , a4g atl
RE: Can you convert a variable length field to a fixed length field in a LF? , Birgitta Hauser

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.