Hi,
I want to use one of IBM's table functions to retrieve information on uploaded IFS files.
I created the following (working) SQL. statement:
Unfortunately the datasource validator doesn't accept this statement:
Is there a way around this?
Kind regards, Theo
I want to use one of IBM's table functions to retrieve information on uploaded IFS files.
I created the following (working) SQL. statement:
PHP Code:
WITH libifs (ifsfullname, ifsoid) AS(
SELECT
trim(fullname),
oid
FROM
LIBBES l2
)
SELECT
l.*,
z.*,
FROM
libifs i,
libbes l,
LATERAL (
SELECT
*
FROM
TABLE(
QSYS2.IFS_OBJECT_STATISTICS(
START_PATH_NAME => ifsfullname,
SUBTREE_DIRECTORIES => 'NO'
)
)
) AS z
WHERE
i.ifsoid = l.oid
PHP Code:
Expected Semicolon or end of input but "(" found
Kind regards, Theo
Comment