{"id":177,"date":"2025-11-01T23:42:28","date_gmt":"2025-11-01T23:42:28","guid":{"rendered":"http:\/\/www.navan.com.au\/wp\/?page_id=177"},"modified":"2025-11-02T04:42:26","modified_gmt":"2025-11-02T04:42:26","slug":"genhtml-a-scripting-language-for-the-ibm-i","status":"publish","type":"page","link":"https:\/\/www.navan.com.au\/?page_id=177","title":{"rendered":"GENHTML"},"content":{"rendered":"\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<h3>A powerful scripting language for the IBM i<\/h3>\r\n<p>The GENHTML command brings together the power of IBM i, Microsoft Windows, CoolSpools, NUTIL, HTML, QSH, Java Script , Google Charts, CGI and Python to provide a rich user experience by modernising the user interface.<\/p>\r\n<p>Use GENHTML to:<\/p>\r\n<ul>\r\n<li>present IBM i business data in HTML tables, text, csv, pdf, excel and optionally attach documents to a CoolSpools HTML formatted email<\/li>\r\n<li>embed SQL statements inside the script (source member) to extract Business data and present as HTML tables or Charts.<\/li>\r\n<li>customise an email message using HTML and CSS<\/li>\r\n<li>create HTML pages with tables populated with Business Systems data<\/li>\r\n<li>create dashboards<\/li>\r\n<li>create google charts<\/li>\r\n<li>extract data using SQL and optionally display or export results in excel format<\/li>\r\n<li>extract data using SQL and optionally place results in IFS document (JSON data)<\/li>\r\n<li>presents data in a WebApp<\/li>\r\n<li>extract and present data using the MSSQL SQL Server command interface<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>GENHTML script members by default are stored in the source file NUTIL\/HTMLTXT.<\/li>\r\n<li>GENHTML script members maintained by SEE\/Change are stored in the source file QHTMLSRC.<\/li>\r\n<\/ul>\r\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; A powerful scripting language for the IBM i The GENHTML command brings together the power of IBM i, Microsoft Windows, CoolSpools, NUTIL, HTML, QSH, Java Script , Google Charts, CGI and Python to provide a rich user experience by modernising the user interface. Use GENHTML to: present IBM i business data in HTML tables,&nbsp;&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-177","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.navan.com.au\/index.php?rest_route=\/wp\/v2\/pages\/177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.navan.com.au\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.navan.com.au\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.navan.com.au\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.navan.com.au\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=177"}],"version-history":[{"count":19,"href":"https:\/\/www.navan.com.au\/index.php?rest_route=\/wp\/v2\/pages\/177\/revisions"}],"predecessor-version":[{"id":221,"href":"https:\/\/www.navan.com.au\/index.php?rest_route=\/wp\/v2\/pages\/177\/revisions\/221"}],"wp:attachment":[{"href":"https:\/\/www.navan.com.au\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}