$) would create an excel file that would not open. Using the TABLE command to create an xlsx file from a host table with data containing a special character (i.e. In 11.14 CVTDATE was modified and no longer worked when using an remote database connection to another IBM i. SQJENDSVR introduced in 11.14 waits indefinitely for the Sequel Java Server (SEQJVASVR) to stop. When saving results to Excel or opening up results in Excel, negative values with currency symbol editing had two dollar signs ($$).Ī *LOCALSYS/*SEQUEL connection using file.field syntax will not ignore edit codes. WRKDCTUSR Fails when scrolling if more than 9999 user profiles existĮXPR Variable input value was truncated at 50 characters but now allows 80 characters which is the maximum default value.ĬHGVIEW on any view, pressing F23 causes error RNQ0202. *PGMs ANZAUDDTAC and DLTAUDDTAC will now determine the product library from GETSQLIB *PGM instead of the *PRDDFN which is no longer used. This driver supports MSSQL version 2012 and above, and requires Java 1.8. The Microsoft JDBC Driver version 9.2 is now shipped with the Software. This command can be used before an install to check for object locks.Īn enhancement was made to include subtotal details in a view when using DSPVIEWD or the Print Definition in Viewpoint The command CHKIFSLOCK checks for locks on sequelcc.jar which is used in connections types using JDE, ADS and *LOCALSYS/*SEQUEL. This method eliminates the need to configure a VPServer to use RUNRMTCMD or VPListener to use VPTRMTCMD. The SQJCRO command runs a Client Report in batch and from SWI using the Sequl Java Server on the host. SQJCRO will now resolve the library when *LIBL is specified. This caused corrupted entries into the journal receivers, and the data was not available to load into the audit history files Support for IBM Db2 Mirror for i added.Ī fix was made to correct the way Script Views were being analyzed during the audit process.A fix was made to display more complex charts ie: stacked bar charts when CRO is processed with the SQJCRO command.Generic SQJ1216 error when running a CRO from the Sequel Java Server when column names are longer than 10 characters.These spaces have been replaced with a null character. Some printers where not handling output from SQJCRO because of spaces at the end of the spooled file. Client Report output using barcodes will not show the correct font when the font exists in the /QOpenSys/QIBM/ProdData/JavaVM/jdk80/64bit/jre/lib/fonts or /QOpenSys/QIBM/ProdData/JavaVM/jdk80/32bit/jre/lib/fonts folder.Emailing a CRO with SQJCRO would fail if the text or subject began with a *.A fix was made when running a CRO report with SQJCRO would not display DATE type fields.SQJCRO fails if more than one email recipient is specified.Running a CRO report with SQJCRO that has a formula written using the last column in the Select clause will fail.
0 Comments
Leave a Reply. |