{"id":136,"date":"2025-08-16T10:22:35","date_gmt":"2025-08-16T10:22:35","guid":{"rendered":"https:\/\/fhix.fr\/?p=136"},"modified":"2026-04-07T09:58:02","modified_gmt":"2026-04-07T09:58:02","slug":"faire-du-menage-dans-lifs","status":"publish","type":"post","link":"https:\/\/fhix.fr\/index.php\/2025\/08\/16\/faire-du-menage-dans-lifs\/","title":{"rendered":"Faire du m\u00e9nage dans l’IFS selon la date des fichiers"},"content":{"rendered":"\n

Par exemple, supprimer tous les fichiers pdf de plus d’1 an dans un r\u00e9pertoire :
SELECT<\/strong> <\/code>
QCMDEXC<\/strong>('rmvlnk objlnk(''' CONCAT<\/strong><\/code> TRIM<\/strong>(CAST<\/strong>(path_name AS<\/strong> VARCHAR<\/strong>(200))) CONCAT<\/strong> ''')')<\/code> FROM TABLE<\/strong>(qsys2.ifs_object_statistics( '\/home\/monRepertoire<\/em>'))<\/code>
WHERE<\/strong> path_name LIKE<\/strong> '%.pdf<\/em>'<\/code> AND<\/strong> CREATE_TIMESTAMP < CURRENT_TIMESTAMP - 1 YEARS<\/code><\/p>\n\n\n\n

Explications :<\/strong>
– ifs_object_statistics<\/strong> permet de lister les fichiers d’un r\u00e9pertoire de l’IFS
exemple :
SELECT CAST(path_name AS VARCHAR(100))
FROM TABLE(qsys2.ifs_object_statistics('\/home\/monRepertoire'))<\/code>
– RMVLNK<\/strong> est la commande IBMi qui permet la suppression d’un fichier de l’IFS
– QCMDEXC<\/strong> permet d’ex\u00e9cuter une commande IBMi en SQL<\/p>\n","protected":false},"excerpt":{"rendered":"

Par exemple, supprimer tous les fichiers pdf de plus d’1 an dans un r\u00e9pertoire : SELECT QCMDEXC(‘rmvlnk objlnk(\u00a0\u00bb’ CONCAT TRIM(CAST(path_name AS VARCHAR(200))) CONCAT \u00a0\u00bb’)’) FROM TABLE(qsys2.ifs_object_statistics( ‘\/home\/monRepertoire’)) WHERE path_name LIKE ‘%.pdf’ AND CREATE_TIMESTAMP < CURRENT_TIMESTAMP – 1 YEARS Explications :– ifs_object_statistics permet de lister les fichiers d’un r\u00e9pertoire de l’IFS exemple : SELECT CAST(path_name AS … Lire la suite<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-136","post","type-post","status-publish","format-standard","hentry","category-sql-system"],"_links":{"self":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts\/136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/comments?post=136"}],"version-history":[{"count":13,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts\/136\/revisions"}],"predecessor-version":[{"id":226,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts\/136\/revisions\/226"}],"wp:attachment":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/media?parent=136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/categories?post=136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/tags?post=136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}