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'