#1483 System i Metadata: Source for View wont show correctly

[Claus]

We use jt400 in newest Version to connect to a System i / AS400 Database 7.3
I use SQuirreL 4.2.0 or current snapshot. I have loaded DB2 Plugin.

If I open Source-Tab i won't get my code for Views, while Tables work.
Only a ; can be found there.

[Gerd Wagner]

The DB2 Plugin tried to read tables from qsys2.systables.
I replaced this for now by

SELECT VIEW_DEFINITION
FROM QSYS2.SYSVIEWS
WHERE TABLE_SCHEMA = '...'
AND TABLE_NAME = '...'

This for my example reads the view source almost right. But the table name it returns seems not right although I can execute the source SQL.

Nonetheless the change is committed and will be available in future snapshots.

If you know of a better place to read view sources from. please let me know.