This got me wondering how IBM would do it. So I dusted off my
RTVSQLSRC command, put a couple of files together, and documented the
In an experimental study for my research project on substituting a
join for a PF:
I have the following in a join logical's DDS:
. . .
JFLD(U01095 ARFBEXLNRS) . . .
ARFBEXLNRS CONCAT(ARFBEX ARFBLN ARFBRS)
. . .
where U01095 is a zoned decimal field in our "stub" PF, and
ARFBEX, ARFBLN, and ARFBRS are zoned decimal fields in the "native"
file, whose values, concatenated together, match up with U01095.
How would I do the equivalent in an SQL join view?
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact