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

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.