{"id":3906,"date":"2023-09-23T23:32:05","date_gmt":"2023-09-23T21:32:05","guid":{"rendered":"https:\/\/www.skillup.cloud\/?p=3906"},"modified":"2024-01-23T17:45:41","modified_gmt":"2024-01-23T16:45:41","slug":"campi-logical-file","status":"publish","type":"post","link":"https:\/\/www.skillup.cloud\/it\/campi-logical-file\/","title":{"rendered":"Campi Logical File"},"content":{"rendered":"\n<p>Per sapere da quali campi e in quale sequenza \u00e8 composto un Logical file (LF) \u00e8 possibile utilizzare il File QSYS.QADBKFLD.<br>Il campo DBKPOS indica la posizione dei campi all&#8217;interno della LF.<\/p>\n\n\n\n<p>Esempio:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT * FROM QSYS.QADBKFLD WHERE DBKLIB = 'ASCOGE_LFI' AND DBKFIL = 'MOVCOGL1' ORDER BY DBKPOS <\/pre>\n\n\n\n<p>Result:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">---\nDBKLIB    DBKFIL    DBKFMT    DBKFLD    DBKPOS    DBKORD    DBKATR    DBKFMP    DBKLB2    DBXDEVKEY    DBXISDEVKY    DBXDVKYUDF    IASPNUMBER\nASCOGE_LFI    MOVCOGL1      RKMOVCOG      MDTREG        1    A    S    1    ASCOGE_LFI        N        33\nASCOGE_LFI    MOVCOGL1      RKMOVCOG      MNUPRO        2    A    S    1    ASCOGE_LFI        N        33\nASCOGE_LFI    MOVCOGL1      RKMOVCOG      MNUREG        3    A    S    1    ASCOGE_LFI        N        33\n---<\/pre>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-3817\" style=\"width: 32px;\" src=\"https:\/\/www.skillup.cloud\/wp-content\/uploads\/2023\/11\/Actions-help-hint-icon.png\" alt=\"\">Casi in cui pu\u00f2 essere utile:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>per sapere i campi che sono in una LF<\/li>\n\n\n\n<li>per sapere la sequenza dei campi di una LF<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Per sapere da quali campi e in quale sequenza \u00e8 composto un Logical file (LF) \u00e8 possibile utilizzare il File QSYS.QADBKFLD.Il campo DBKPOS indica la posizione dei campi all&#8217;interno della LF. Esempio: SELECT * FROM QSYS.QADBKFLD WHERE DBKLIB = &#8216;ASCOGE_LFI&#8217;&#8230;<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[17],"tags":[40,46,69,83,29],"class_list":["post-3906","post","type-post","status-publish","format-standard","hentry","category-piu-in-profondita","tag-iseries","tag-sql","tag-lf","tag-qadbkfld","tag-as400"],"_links":{"self":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts\/3906","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/comments?post=3906"}],"version-history":[{"count":1,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts\/3906\/revisions"}],"predecessor-version":[{"id":3907,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts\/3906\/revisions\/3907"}],"wp:attachment":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/media?parent=3906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/categories?post=3906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/tags?post=3906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}