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

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