Simplest might be to use the DSPFD command. A SQL VIEW will show the related CREATE VIEW statement in the file description.
If the definition is needed in SQL itself, you can possibly query the SYSVIEWS table in QSYS2. A more standard way might be to query VIEWS in the SYSIBM library.
thank you very much
Last Wiki Answer Submitted: November 8, 2010 4:22 pm by TomLiotta108,105 pts.
All Answer Wiki Contributors: TomLiotta108,105 pts.