{"id":251,"date":"2023-02-22T17:29:39","date_gmt":"2023-02-22T16:29:39","guid":{"rendered":"http:\/\/www.sepchat.com\/SC\/?p=251"},"modified":"2023-02-23T15:00:26","modified_gmt":"2023-02-23T14:00:26","slug":"ibm-i-des-couleurs-dans-le-resultat-dune-requete-sql","status":"publish","type":"post","link":"http:\/\/www.sepchat.com\/SC\/index.php\/2023\/02\/22\/ibm-i-des-couleurs-dans-le-resultat-dune-requete-sql\/","title":{"rendered":"IBM\u00a0i – Des couleurs dans le r\u00e9sultat d\u2019une requ\u00eate SQL"},"content":{"rendered":"\n

En 5250, il est possible d’afficher le r\u00e9sultat d’une requ\u00eate avec plusieurs couleurs.<\/p>\n\n\n\n

tout d’abord, il faut savoir que les couleurs se d\u00e9finissent pas des code Hexa :<\/p>\n\n\n\n

x\u201920\u2019 Vert
x\u201921\u2019 Vert en inverse vid\u00e9o
x\u201922\u2019 Blanc
x\u201923\u2019 Blanc en inverse vid\u00e9o
x\u201928\u2019 Rouge
x\u201929\u2019 Rouge en inverse vid\u00e9o
x\u20192A\u2019 Clignotant
x\u20192B\u2019 Clignotant en inverse vid\u00e9o
x\u20193a\u2019 Bleu<\/p>\n\n\n\n

SELECT CASE
 WHEN COUNT(*) > 10 THEN (X’20’!!CDAPL)
 WHEN COUNT(*) >  5 THEN (X’22’!!CDAPL)
 WHEN COUNT(*) >  0 THEN (X’28’!!CDAPL)
 END  AS CODE_APPLI,
 LIBELLE AS LIBELLE,
 COUNT(*) AS NOMBRE_OPTIONS
FROM MNOPT1PF GROUP BY CDAPL, LIBELLE
HAVING COUNT(*) > 0<\/p>\n\n\n\n

Et hop !<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n
\n
Cet article vous a \u00e9t\u00e9 utile ? N\u2019h\u00e9sitez pas \u00e0 le partager.<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

En 5250, il est possible d’afficher le r\u00e9sultat d’une requ\u00eate avec plusieurs couleurs. tout d’abord, il faut savoir que les couleurs se d\u00e9finissent pas des code Hexa : x\u201920\u2019 Vertx\u201921\u2019 Vert en inverse vid\u00e9ox\u201922\u2019 Blancx\u201923\u2019 Blanc en inverse vid\u00e9ox\u201928\u2019 Rougex\u201929\u2019 Rouge en inverse vid\u00e9ox\u20192A\u2019 Clignotantx\u20192B\u2019 Clignotant en inverse vid\u00e9ox\u20193a\u2019 Bleu SELECT CASE WHEN COUNT(*) > 10 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[],"_links":{"self":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/posts\/251"}],"collection":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/comments?post=251"}],"version-history":[{"count":3,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/posts\/251\/revisions"}],"predecessor-version":[{"id":330,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/posts\/251\/revisions\/330"}],"wp:attachment":[{"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/media?parent=251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/categories?post=251"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sepchat.com\/SC\/index.php\/wp-json\/wp\/v2\/tags?post=251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}