We are running an iSeries at V7R1. When I run a sql query (from run sql scripts or strsql) like:
Select * from qsys2.systables
The TABLE_TEXT and LONG_COMMENT fields are blank. With SYSCOLUMNS table the COLUMN_TEXT field is populated.
If I run the command DSPFD <TABLENAME> the “text description” does have this information.
Is there something I need to do to get the table_text field populated?