MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

RE: SQL equivalent for DDS?



fixed

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.







Return to Archive home page | Return to MIDRANGE.COM home page

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