{"id":383,"date":"2025-11-04T16:56:28","date_gmt":"2025-11-04T16:56:28","guid":{"rendered":"https:\/\/fhix.fr\/?p=383"},"modified":"2025-11-05T08:33:10","modified_gmt":"2025-11-05T08:33:10","slug":"chercher-les-programmes-en-erreur-de-niveau","status":"publish","type":"post","link":"https:\/\/fhix.fr\/index.php\/2025\/11\/04\/chercher-les-programmes-en-erreur-de-niveau\/","title":{"rendered":"Chercher les programmes en erreur de niveau"},"content":{"rendered":"\n<p>Permet de rep\u00e9rer les programmes RPG qui vont planter en erreur de niveau suite \u00e0 une \u00e9volution de la base de donn\u00e9es.<\/p>\n\n\n\n<p><strong><mark style=\"background-color:var(--base-3)\" class=\"has-inline-color has-accent-color\">1) Lister les r\u00e9f\u00e9rences des programmes dans un fichier temporaire :<\/mark><\/strong><br><code>DSPPGMREF PGM(BIBPGM\/*ALL<em>)<\/em> OUTPUT(OUTFILE) OBJTYPE(*PGM) OUTFILE(QTEMP\/LISTEPGM)<\/code><\/p>\n\n\n\n<p style=\"font-style:normal;font-weight:300\"><strong><mark style=\"background-color:var(--base-3)\" class=\"has-inline-color has-accent-color\">2) Croiser les \u00ab\u00a0format level ID\u00a0\u00bb entre la liste des r\u00e9f\u00e9rences des programmes et la liste des fichiers<\/mark><\/strong><br><code><strong>SELECT<\/strong> whlib, whpnam, whlnam, whfnam, whrfnm <br><strong>FROM<\/strong> qtemp.listepgm <br><strong>LEFT JOIN<\/strong> sysfiles <strong>ON<\/strong> whfnam=system_table_name <strong>AND<\/strong> whrfnm=format_name <br><strong>WHERE<\/strong> whrfsn <\/code>&amp;lt;&amp;gt;<code> format_level_id <\/code><br><code><strong>AND<\/strong><\/code> <code>system_table_schema <strong>IN<\/strong> ('BIBFICHIER1' , 'BIBFICHIER2')<\/code><\/p>\n\n\n\n<p>On obtient la liste des programmes de la biblioth\u00e8que BIBPGM en erreur de niveau sur les fichiers des biblioth\u00e8ques BIBFICHIER1 et BIBFICHIER2 :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"466\" height=\"49\" src=\"https:\/\/fhix.fr\/wp-content\/uploads\/2025\/11\/image.png\" alt=\"\" class=\"wp-image-395\" srcset=\"https:\/\/fhix.fr\/wp-content\/uploads\/2025\/11\/image.png 466w, https:\/\/fhix.fr\/wp-content\/uploads\/2025\/11\/image-300x32.png 300w\" sizes=\"auto, (max-width: 466px) 100vw, 466px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Il n&rsquo;y a plus qu&rsquo;\u00e0 recompiler le ou les programmes trouv\u00e9s (dans l&rsquo;exemple BIBPGM\/ADDCUST). La m\u00e9thode fonctionne aussi pour les PRTF et les DSPF.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Permet de rep\u00e9rer les programmes RPG qui vont planter en erreur de niveau suite \u00e0 une \u00e9volution de la base de donn\u00e9es. 1) Lister les r\u00e9f\u00e9rences des programmes dans un fichier temporaire :DSPPGMREF PGM(BIBPGM\/*ALL) OUTPUT(OUTFILE) OBJTYPE(*PGM) OUTFILE(QTEMP\/LISTEPGM) 2) Croiser les \u00ab\u00a0format level ID\u00a0\u00bb entre la liste des r\u00e9f\u00e9rences des programmes et la liste des fichiersSELECT &#8230; <a title=\"Chercher les programmes en erreur de niveau\" class=\"read-more\" href=\"https:\/\/fhix.fr\/index.php\/2025\/11\/04\/chercher-les-programmes-en-erreur-de-niveau\/\" aria-label=\"En savoir plus sur Chercher les programmes en erreur de niveau\">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":[4],"tags":[],"class_list":["post-383","post","type-post","status-publish","format-standard","hentry","category-rpg"],"_links":{"self":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts\/383","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=383"}],"version-history":[{"count":16,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts\/383\/revisions"}],"predecessor-version":[{"id":409,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts\/383\/revisions\/409"}],"wp:attachment":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/media?parent=383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/categories?post=383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/tags?post=383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}