DB2XTOOLS Change Log 2023-05-30 - Fixed program DB2CSVVC. 2023-03-31 - Commands DB2CSV, DB2HTML, DB2TXT and DB2XML now supporting parameter SBMJOB. 2023-03-31 - Commands DB2CSV, DB2HTML, DB2TXT and DB2XML now supporting parameter SBMJOB. 2020-08-02 - The Change Log can now be displayed as an HTML page from the online manual. 2016-08-04 - Module CHKIFS now supports reverse slashes. 2016-07-02 - HTTP configuration directives now supporting also APACHE 2.4 . 2016-05-07 - Updated validity check program DB2CSVVC of command DB2CSV. 2015-07-29 - Updated all DB2... programs to care for OS/400 release parameters dependencies in commands . CPYTOIMPF and CPYTOSTMF. - Corrected a severe bug in commands DB2... (Commands were missing parameter TOCCSID, requested in command programs). 2015-07-28 - Updated CLLESRC members DB2... to better care for authorities of objects in /Home/user_name IFS directory . 2015-07-21 - Fixed a comment in stream file /db2xtools/conf/httpd.conf 2014-11-02 - CGI pgm DB2XTOOLS now allows to display (download) DB2... generated files as text files. 2014-10-17 - A free trial version (file "db2xttry.zip") has been made available for V5R3 and subsequent releases. This version is "object code only" and can be used for 30 days. 2014-01-18 - Added parameter OPTION(*SYS) to commands CRTSQLRPGI in pgm DB2XTOOLS/COMPILE. 2013-10-20 - Fixed problem with parameter STRDLM in pgm DB2CSV. 2013-09-15 - Added parameter ROWDLM (row delimiter) to command DB2CSV. 2013-09-11 - Added parameter TOCCSID to commands DB2CSV, DB2HTML, DB2TXT, DB2XML. 2012-03-06 - Updated pgm DB2CSV to support single quote as field delimiter. 2012-02-23 - Updated pgm WRTHFRINF (remove single and double quotes from column headings) 2012-02-14 - Fixed pgm DB2CSV for the case when parameter &STRDLM contains a quote. 2012-02-02 - Support for NULL capable fields that actually contain the NULL value in DB2XML and DB2HTML, for character, numeric, date & time fields NO DATA will be returned if they contain a value of NULL. - If DB2XML and DB2HTML now crash with an SQLCOD < 0, meaning an SQL failed, they will send an escape message to the caller that can be monitored with MONMSG, the MSGID used is CPF9897. 2012-01-19 - Now really working also on V5R2. 2012-01-06 - Programs DB2CSV and DB2TXT now cutomized according to the OS/400 release. - Automated re-compile on OS/400 release change. 2011-12-29 - Accept any character for FLDDLM - Allow using field names iso column headings 2011-11-17 - A bug fixed ( encoding not always complete if > 1 character to encode ) + improved performance on command DB2XML. 2011-01-31 - Improved controls on CSV generation 2010-11-30 - Changed the CVTDB2XML/HTML modules to use *ISO. 2010-11-24 - Updated service program FUPLOAD/FUPSRVPGM2 in a way that makes it perfectly compatible with V5R2. 2010-11-12 - Added feature to run DB2XTOOLS from a WEB browser and receive result on the fly. 2010-11-02 - When running in same job DB2TXT did not recreate the column headings if a previous run of DB2TXT or DBTHT ML had occurred. That was fixed. - In DB2HTML column headings are now aligned to the left, which gives a neater look. 2010-09-07 - Changed the way a netork drive ID is identified: parameter NDTYPE replaced by parameter NDID. 2010-08-31 - Added parameter "SHOW" to all DB2XTOOLS/DB2xxx conversion commands. This parameter allows to request the execution of the appropriate PC Windows utility to display the generated stream file. 2010-08-16 - First release of this utility.