RE: DSPFD SQL instructions

David - TEXT is probably a varying length field - do a DSPFFD on SYSVIEWS to find out. If so, the first 2 characters you see in a CL are the length of the text. I forget if there is a compile option to ignore that, for all practical purposes. Otherwise, do a %BIN on the first 2 characters to get the length, then do a %SST on the field using that length to get the text.

HTH
Vern

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

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
To:
Midrange Systems Technical Discussion
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

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.

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