Hi,
I have a datasource that validated before, but now it doesn't. In NAB the preview of the SQL statement (step 1) stays 'validating'. When I press next I get the same.
The grid still shows, only the pagination is broken "no data to display" where the count is shown.
I am running on the latest version. No error in the error app, no message in QSYSOPR, nothing in VVGENLOG.
See SQL statement below.
Regards,
Theo
I have a datasource that validated before, but now it doesn't. In NAB the preview of the SQL statement (step 1) stays 'validating'. When I press next I get the same.
The grid still shows, only the pagination is broken "no data to display" where the count is shown.
I am running on the latest version. No error in the error app, no message in QSYSOPR, nothing in VVGENLOG.
See SQL statement below.
Regards,
Theo
Code:
WITH libifs(ifsfullname, ifsoid) AS ( SELECT trim(fullname), oid FROM ludodta.libbes AS l2 ) SELECT l.name AS l_name, l.tags AS l_tags, l.type AS l_type, l.descript AS l_descript, l.oid AS l_oid, l.addedby AS l_addedby, l.addedon AS l_addedon, l.path AS l_path, l.extention AS l_extention, l.fullname AS l_fullname, l.keytype AS l_keytype, l.keyvalue1 AS l_keyvalue1, l.keyvalue2 AS l_keyvalue2, l.contractor AS l_contractor, l.changedby AS l_changedby, l.changedon AS l_changedon, z.access_timestamp AS z_access_timestamp, z.data_change_timestamp AS z_data_change_timestamp, z.last_used_timestamp AS z_last_used_timestamp, z.days_used_count AS z_days_used_count, z.allocated_size AS z_allocated_size, z.data_size AS z_data_size FROM libifs AS i CROSS JOIN LATERAL ( SELECT * FROM ludodta.libbes AS x WHERE (i.ifsoid = x.oid) ) AS l CROSS JOIN LATERAL ( SELECT * FROM TABLE( qsys2.ifs_object_statistics( start_path_name => i.ifsfullname, subtree_directories => 'NO' ) ) ) AS z WHERE ( issuperuser() = 'J' or l.contractor in ( SELECT * FROM TABLE(authorisedcontractor()) ) ) ORDER BY l.addedon DESC
Comment