RE: DSPFD SQL instructions -- MIDRANGE-L

Yes but how do you extract it in a program?

Also, I'm reading the SYSVIEWS file in a CLP. I'm getting strange characters before the SELECT. Like this :' SELECT * FROM FOXWELL.CLVE01 '

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx
Envoyé : mercredi 30 juillet 2008 16:37
À : Midrange Systems Technical Discussion
Objet : RE: DSPFD SQL instructions

the table(s) used by the view are embedded in the SQL statement used to create the view.

Thanks,
Tommy Holden

From:
David FOXWELL <David.FOXWELL@xxxxxxxxx>
To:
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:
07/30/2008 09:34 AM
Subject:
RE: DSPFD SQL instructions

There doesn't seem to be anyway of finding the table used for the view without looking at the TEXT field.

Maybe DSPDBR first and then join on SYSVIEWS. Is that reasonable?

Thanks.

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [
mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de vhamberg@xxxxxxxxxxx Envoyé : mercredi 30 juillet 2008 12:02 À : Midrange Systems Technical Discussion Objet : RE: DSPFD SQL instructions

David

The TEXT field in SYSVIEWS is only 10,000 characters long - so maybe if you have something that big, you would need these other methods. So I would think you would not normally need to look at the others.

Vern

-------------- Original message --------------
From: David FOXWELL <David.FOXWELL@xxxxxxxxx>

Wow thanks.
I'd actually already seen that table before and completely forgotten

about it.

Is there any point in persuing with QSQGNDDL, RTVSQLSRC, GENDDLSRC or
Tommy's genddl? I haven't had the time yet to look at them.

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de
vhamberg@xxxxxxxxxxx Envoyé : mardi 29 juillet 2008 18:53 À : Midrange
Systems Technical Discussion Objet : RE: DSPFD SQL instructions

David, et al.

You can also find this in the system catalog - field is TEXT in
SYSVIEWS. Here is an SQL SELECT to see it

select text from sysviews where name = 'your-view' and dbname =

'your-lib'
--
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.

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