RE: SQL equivalent for DDS?

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 (
ARFBEXLNRS ,
FIELDA ,
FIELDB ,
F2FLDA )
AS
SELECT
CAST ( Q02.ARFBEX AS NUMERIC(3, 0) ) ,
Q01.FIELDA ,
Q01.FIELDB ,
Q02.F2FLDA
FROM...

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)).

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
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 my
RTVSQLSRC command, put a couple of files together, and documented the

results here:

http://code.midrange.com/0f2a9ba153.html

Fascinating. Trust IBM to cross all the I's, and dot all the T's.

Strike that: reverse it.

--
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.