Re: Logical (or SQL view) imposing a format on a flat PF?

[Michael Schutte <mschutte369@xxxxxxxxx>]

If change management is not in play, then the original creator needs to
document in the source.  Then the modifying programmer needs to pay
attention to the notes.

Also, CHGCMDDFT could be used to set the default of PAGESIZE to 64.

But yes, DDL is my preferred method.



On Wed, Apr 17, 2013 at 7:37 AM, <rob@xxxxxxxxx> wrote:

> Can be done with either DDS or DDL, but I'd go with DDL.  Looks like it
> may involve a lot of substringing and casting to numeric.  And if they do
> weird things like sign trailing vs sign leading it could be interesting.
>
> As far as any out of the box ideas I can think of a couple.  Find out if
> someone is taking a stream file and doing a cpyfrmstmf to make this flat
> file.  If they are, put the brakes on that right there!  Instead, use the
> templates from Scott Klements IFS APIs to read the stream file and convert
> it into a real table.  I get the idea you've worked in the bad old days
> (which seem to have come back around) where you had to carefully process
> each part of the row; yet you also have some new techniques, so using the
> IFS APIs shouldn't send you into the fetal position.
> Another idea, (not that I've used it), is a SQL Table function.  Help me
> if I've got the terminology wrong.  But the query against this function
> thinks they are accessing a table but it's really calling a program that
> can do the substringing, casting, etc.  Maybe even in languages other than
> SPL?
>
>
> 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:   "James H. H. Lampert" <jamesl@xxxxxxxxxxxxxxxxx>
> To:     "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>,
> Date:   04/16/2013 05:27 PM
> Subject:        Logical (or SQL view) imposing a format on a flat PF?
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
> I've been informed that we may be needing to create either a DDS LF or
> an SQL view imposing a format on an existing flat file. I'm not
> personally aware of what data types might be involved, so I'm assuming a
> worst case scenario.
>
> I seem to recall that there are ways to do it, as well as ways to use
> IDDU to impose a format on an existing flat PF. But I'm having trouble
> remembering what does and does not work in this regard.
>
> Can somebody point me in the right direction?
>
> --
> JHHL
> --
> 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: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> 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: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.