Hmmm... but what surprised me, was the first column of the SELECT. Does
that coincide with what your LF is doing?
CREATE VIEW <lib>/JFILE1 (
CAST ( Q02.ARFBEX AS NUMERIC(3, 0) ) ,
IOW, It looks to me like the JOIN is OK, but the first column realized in
the view would be the unconcatenated ARFBEX?
Are the results of QSQGNDDL the same on your (hopefully non-V5R3) system?
BTW: I executed the generated DDL with RUNSQLSTM. What I got, was as
reflected above. In other words, the first column of output is only 3
digits long. So QSQGNDDL is definitely amiss in this case (way mobie old
V5R3 with unknown patch level (not my system)).
Unix is user-friendly. It's just very particular about who its friends are.
Dennis Lovelady wrote:
This got me wondering how IBM would do it. So I dusted off myresults here:
RTVSQLSRC command, put a couple of files together, and documented the
Fascinating. Trust IBM to cross all the I's, and dot all the T's.
Strike that: reverse it.
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.