IFS Filenamen aus PATH_NAME extrahieren

[camouflage]

Wenn Du nur den Filenamen brauchst:

SELECT SUBSTR(PATH_NAME, LOCATE_IN_STRING(PATH_NAME, '/', -1) + 1) AS FILENAME
FROM TABLE(IFS_OBJECT_STATISTICS(
START_PATH_NAME => ('/temp'),
OBJECT_TYPE_LIST => '*STMF'))
WHERE UPPER (PATH_NAME) LIKE '%.TEMP%'



@Baldur: Holger hätte sicher noch Free Accounts auf seiner PUB400 ;-)