{"id":260,"date":"2025-09-25T14:10:05","date_gmt":"2025-09-25T14:10:05","guid":{"rendered":"https:\/\/fhix.fr\/?p=260"},"modified":"2025-09-28T08:53:32","modified_gmt":"2025-09-28T08:53:32","slug":"boucle-de-lecture-en-sqlrpgle","status":"publish","type":"post","link":"https:\/\/fhix.fr\/index.php\/2025\/09\/25\/boucle-de-lecture-en-sqlrpgle\/","title":{"rendered":"Boucle de lecture en SQLRPGLE"},"content":{"rendered":"\n<p>Exemple : Lecture de la table utilisateur en filtrant les habitants de PARIS <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>**FREE\n<strong>\/\/ D\u00e9claration des variables<\/strong>\ndcl-s nom char(30);\ndcl-s prenom char(30);\ndcl-s ville char(20) inz('PARIS');\n\n<strong>\/\/ D\u00e9finition du curseur C01<\/strong>\nexec sql\n  declare C01 cursor for\n  select NOM , PRENOM\n  from UTILISATEUR\n  where VILLE = <strong><em>:ville<\/em><\/strong>\n  order by NOM , PRENOM;\n\n<strong>\/\/ Ouverture du curseur <\/strong>\nexec sql\n  open C01;\n\n<strong>\/\/ Boucle de lecture<\/strong>\ndow sqlcode = 0;\n  exec sql\n    fetch C01 into <em><strong>:nom , :prenom<\/strong><\/em> ;\n  if sqlcode = 0;\n    \/\/ lecture r\u00e9ussie, je fais mon traitement ici\n  endif;\nenddo;\n\n<strong>\/\/ Fermeture du curseur<\/strong>\nexec sql\n  close C01;\n\n*inlr = *on;\nreturn;<\/code><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Exemple : Lecture de la table utilisateur en filtrant les habitants de PARIS<\/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-260","post","type-post","status-publish","format-standard","hentry","category-rpg"],"_links":{"self":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts\/260","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=260"}],"version-history":[{"count":7,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts\/260\/revisions"}],"predecessor-version":[{"id":271,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts\/260\/revisions\/271"}],"wp:attachment":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/media?parent=260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/categories?post=260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/tags?post=260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}