The latest one is always the one that's on the server. Right click the VIEW in the iSeries navigator and click on the generate SQL option and follow the prompts. That will always be the latest version.
-----Original Message-----
From: Hoteltravelfundotcom [mailto:hoteltravelfun@xxxxxxxxx]
Sent: Tuesday, September 03, 2013 4:53 PM
To: Midrange Systems Technical Discussion
Subject: How to see the code of a VIEW
I have a VIEW but was written now some weeks back. I would like to see the actual code that created this view.
If Iook back in STRSQL, how can I be assured that I am looking at the latest one?
--
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 mailing list archive is Copyright 1997-2025 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.