Re: Can I define a variable char field in DDS for a Physical file

[a4g atl <a4ginatl2@xxxxxxxxx>]

I am using VARLEN for an error message field. There may be 1 error message
in a few thousand so to waste 100 bytes on thousand of records  is a trade
off.

Essentially, the file is written to constantly but read a few times a week.

Darryl

On Thu, Sep 14, 2017 at 1:36 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

> If you want to use SQL I'd suggest to convert the physical file first:
> 1. Generate the SQL Script for the physical file with IBM i Navigator's or
> ACS' Generate_SQL functionality or with the GENERATE_SQL stored procedure.
> 2. Make sure it is a CREATE OR REPLACE TABLE ( and not a CREATE TABLE)
> command
> 3. Add your column with varying length (where ever you want) to the script.
> 4. Run the SQL Script
>
> ... and the table is not only converted into SQL but also enhanced by the
> additional column.
> ... and the most important thing: the data is still available
> All dependent objects, such as logical files, views, indexes, triggers etc.
> are adopted and do not need to
>
> CREATE OR REPLACE TABLE is one of the most powerful features.
>
> I just enhanced an old physical file in this way.
> The hardest part was recompiling the RPG programs where the table is
> accessed with native I/O.
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
> „Train people well enough so they can leave, treat them well enough so they
> don't want to.“ (Richard Branson)
>
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob
> Berendt
> Sent: Mittwoch, 13. September 2017 23:09
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Subject: Re: Can I define a variable char field in DDS for a Physical file
>
> If you do
> ALTER TABLE ... it does "do it in the PF this time".
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   a4g atl <a4ginatl2@xxxxxxxxx>
> To:     midrange-l@xxxxxxxxxxxx
> Date:   09/13/2017 04:27 PM
> Subject:        Can I define a variable char field in DDS for a Physical
> file
> Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
>
>
>
> If yes, how do I do it?
>
> Always done this is SQL but I need to do it in the PF this time.
>
> TIA
>
> Darryl Freinkel
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link:
> http://amzn.to/2dEadiD
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD