× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.