How To Guide

Release Notes

Last Updated:
Nov. 21st, 2016

The following is a list of resolved issues or enhancements added to the listed version of Sequel, Sequel Viewpoint, Sequel Web Interface, Esend, Abstract and Anydate. The text describes the issue that required a change or update, or the enhancement.

Sequel 11

Currently Shipping Version: R11M05

The following enhancements are included in this version:

  • Added  EDTWRD and EDTCDE handling when using SERVER(*LOCALSYS) or SERVER(*LOCAL). f the underlying column/table/schema for a given result column can be determined, the edit word/edit code, if one exists for a numeric field, will be displayed as follows (in order of precedence): 1)The value provided by EDTCDE() or /*<S-EDTCDE()-S>*/ in the SQL, 2)The value provided by EDTWRD() or /*<S-EDTWRD()-S>*/ in the SQL, 3)The edit code or edit word associated with the field in the DDS, 4)The edit code J.
  • Within the user defaults (SETDFT), a prompt was added for selection of Default Data Base (SERVER).
  • SETAUDDFT command will not error when there are more 9,999 user data areas.
  • EXECUTE command now retains field text when creating output files when using SERVER(*LOCAL) or SERVER(*LOCALSYS).

The following updates are included in this version:

  • Using DSPVIEWD to generate CL source generates MCH0603 ‘an array index is out of range’ in program DSPVIEWD1 in rare instances when the formatted SQL string uses spaces at the end of the line feed.
  • Referencing a UDF without the qualified library that is not in the SEQUEL or SCSERVER10 library, generates an error that the item was not found in *LIBL, even though the UDF library is part of the Viewpoint or Green Screen job. Introduced in Mod 4.
  • Character fields defined with CCSID 65535 are unreadable when using Viewpoint Universal Driver for Advanced Database Security or JDE connections.
  • Using EXECUTE command, when no records are selected, still sends and email when SETDFT E-Mail Distribution flag is set to N. Mail should only be sent if ‘Send if no Data’ is set to Y.
  • All commands changed to Allow Limited Users *NO.
  • EXECUTE command creates output fields without field text when using SERVER(*LOCALSYS) or SERVER(*LOCAL).
  • Convert/Import Query (CVTQRY) command errors when the % sign is used in LIKE comparisons.
  • A host report over a *LOCALSYS view with runtime prompting ( SQLVIEWMP ) does not create a proper report definition (PRTRPTD).
  • Error RNX0100 ‘Length or start position is out of range for the string operation in SWPGETOBJD’ displays when saving a Client Table if the view has exactly 60 fields on the SELECT clause.
  • EXECUTE to an outfile sporadically displays message ‘MCH1210 in *PGM QRYO03 at instruction x'00EE'’ with views that are SERVER(*LOCALSYS) SYNTAX(*SEQUEL).
  • Running a Script View where the SCRETURN command has a TEXT parameter shows the script object text at runtime, not the text specified on the parameter.
  • Using the CHGVAR command in a script with a SERVER parameter to a remote database, fails to return a value.
  • ANZAUDDTA command fails with duplicate timestamps CPF5149 ‘Operation for program device or member CPIALL is not valid’.

The following updates are included in version R11M04:

  • Issue corrected when DSPVIEWD is used to create a source file, where derived fields with a certain length expression caused the line to break inappropriately, depending on the length of the keyword that follows the expression.
  • DSPVIEWD now supports the REMARKS parameter of a view, and wild card names like CUST* when used to create a source file.
  • For the JOBQ parameter of the BCHEXECUTE, BCHPRINT, BCHREPORT, RUNSCRIPT, RUNSCRIPTV and RUNSCRVPT commands, *JOB was removed as it was not a valid value.
  • The SEQUEL object ZLIB was renamed to SEQZLIB to avoid potential conflicts with objects of the same name.
  • Issue fixed where loading the Query Audit data (ANZAUDDTA) errored with ‘CPF5009 and CPF5026 duplicate key in QRYSUM when the timestamp of the requests is identical’.
  • The runtime SQL conversion for SERVER(*LOCALSYS) and SYNTAX(*SEQUEL) now supports CHAR(date, format) function with the formats JUL, JL1, MDY, YMD and DMY.
  • Issue corrected where scripts were incorrectly parsing out a RUNCMD command if prompted views are used in both the CMD and VIEW parameters of the command.
  • VALID_DATE function loops causing job to hang in rare instances.
  • Using the JDE driver, the descriptions of date fields were not displayed correctly.
  • Security setting *STRICT always gave error when view was SERVER(*LOCALSYS) and SYNTAX(*SERVER).

The following enhancements are included in version R11M04:

  • When using SYNTAX(*SERVER), the Edit Code (EDTCDE) and Column Heading (COLHDG) values will now be supported.
  • A new value for the user defaults for the Security setting of *ADS has been created. This setting makes it easier to enforce the Advanced Database Security settings..

The following updates are included in version R11M03:

  • DSPVIEWD now supports syntax of *LOCALSYS/*SERVER and will exclude host table objects (*SQLTBLV).
  • Within the user defaults (SETDFT) the expected behavior of the new Query Time Out setting is that if there is a value there (*NOMAX for example), that setting will be used, but if its left blank, the Query Time out Setting in the QAQQINI file will be used.
  • EDIT Function may result in the decimal being moved 1 position to the right for some fields.
  • Script Views that contain variables, do not retain the Description Text when they are saved. It keeps the default value of SEQUEL Script.
  • RUNSCRIPT was not handling SETVAR for EXPR variable with one value using all single quotes.
  • DSPSCRIPTD TYPE(*SRCCL) fails with ‘RNX0100 Length or Start position out of range’.

The following enhancements are included in version R11M03:

  • Excel and Access can now be referenced as a view data source.
  • Update Microsoft JDBC driver to 1.2 with hot fix for greater compatibility.

The following updates are included in version R11M02:

  • Runtime SQL conversion (SERVER(*LOCALSYS) and SYNTAX(*SEQUEL) cause error with the CEILING function.
  • A view with SERVER(*LOCALSYS) and Alt-named fields where the name contains the # character, produces quotes around the name which causes a syntax error.
  • When running command SCHSCRIPT to search for a given text string, a spooled file report is generated called SCRFNDRPL. Overprinting was changed to make the column headings visible.
  • REPORT and REPORTVPT commands allow *XLS for the PCFMT parameter when running Client Reports.
  • JDE driver connection caused error running view when a Julian date field is used in a CASE statement in SELECT clause with DATE function wrapped around it and same column added in GROUP BY. The JDE driver by default adds the DATE wrapper (if already not added) around such columns (JDE Julian date format column), hence the converted date field in GROUP BY clause was getting customized with Date() causing an error.

The following updates are included in version R11M01:

  • CVTQRY ( import query ) fails on a qry/400 query that has file and library names containing a period and gives error QRY3004 ‘String beginning 'T02 ON' is never ended or is longer than 256’.
  • CVTQRY (import query) fails on a qry/400 query that has file named ORDER and gives error QR2303.
  • *LOCALSYS views with an Edit Word for a trailing % causes JSON error in SEQUEL Web Interface.
  • Runtime SQL Conversion updates when using SERVER(*LOCALSYS) SYNTAX(*SEQUEL) in these conditions:
    • Unqualified field reference in join clause causes syntax conversion errors and invalid query results.
    • Partial Outer Join with some fields from the secondary file in the grouping clause produces a null value which caused erroneous where conditions preventing a valid drill down request.
    • A partial outer join with many files could qualify the field on the join clause with the wrong file when the view specifies joins that are not in the order that the files are listed.
    • Fields in views with three files ignored the column headings of the field.
    • CASE with CVTDATE and GROUP BY clause.
    • When one file joined to many files (F1 to F2 and F3 and F4) may give error SQL5001 Column qualifier or table xx undefined.
  • Runtime SQL conversion error using SEQUEL syntax and Oracle Server with the field names had special characters gives error ‘SQLSTATE 42000 Native Error Code 923’.
  • The REPORT command to create a stream file, when the user did not have an Esend default created, issues the error CPF4102 ‘File ESNDPF in library *LIBL with member X not found’.
  • DSPVIEWD to a CL source file when view has integrity tests using quotes can cause errors like CPD0014 ‘A matching apostrophe not found’.
  • DSPVIEWD on a view which has an expression greater than 2000 characters gives MCH0603‘Range of subscript value or character string error’.
  • Script view using a SCRETURN on an *LOCALSYS SQL statement causes 'Cannot translate Sequel syntax to local SQL' error.
  • Using DO or GOTO in a script MONMSG command gives CPD0031 ‘Command DO not allowed in this setting’.
  • CRTSCRIPT over CL Source member loops with CPF5812 ‘Member SCRCMDPF already exists in file SCRCMDPF in library QTEMP’.
  • DYNSQL was not working .
  • From the Green Screen script designer using DSNSCRIPT, F10 to toggle the script to a script view causes an MCH1210 ‘Receiver value too small to hold result’ error.
  • Script view with a variable length longer than 80 positions for the first variable will ignores other variables when run from the ViewPoint Explorer or SWI Explorer.
  • Script view with prompts could not create a PDF or RTF stream file from the EXECUTE command.

The following enhancements are included in version R11M01:

  • Create UDF for SQL to retrieve overridden dates and times named GETDATTIM. This function is useful with AnyDate.
  • The LOADJOINDB process utilized by the ViewPoint auto-join feature now supports *LOCALSYS and *LOCAL views when the join criteria is on the JOIN clause.
  • See the SEQUEL 11 Enhancements doc for a complete list of enhancements.

Sequel 10 (top)

The following updates are included in version R10M30:

  • TABLE command gives MCH0601 ‘Space offset’ error in TBLO01 when file has 1.95 million records.
  • Running a view with *LOCALSYS and syntax *SERVER with syntax in native DB2 for results sets greater than 32,000 bytes in total record size causes MCH0601 ‘Space offset’ unmonitored by QSQCLI in SQLEF.
  • Using an edit word (EDTWRD) with server *LOCALSYS and syntax *SEQUEL, was ignored.
  • Prefacing a command with a question mark in a script (i.e. ? DLTF FILE(library/file)) should cause the command to be prompted at run time from the green screen.
  • Using R10M29 and Java 1.5 (5722JV1 Option 8) with *LOCALSYS and syntax *SEQUEL, some views gave error CPF4278 ‘The specified query definition template contains a specification that is not valid.’
  • Application (SQLAPP) hangs when running a view with DBLIST with a filter because only a double quote was tested for, instead of double or single quote.
  • Using BCHEXECUTE with a prompted view to send an email, enclosed the message in single quotes.
  • The ViewPoint Report Designer ended in error when the view had more than 9,000 positions.

The following enhancement is included in version R10M30:

  • GETLASTLOC and GETLAST functions created. Using similar syntax, they return either the position for the last occurrence of a specified character, or return the remainder of the search string after the last occurrence of a specified character.

The following updates are included in version R10M29

  • Creating a remote database file with dates greater than year 2039 were written to the remote data base as the null value rather than the actual date.
  • Host tables that return a very large number of records were unable to rank correctly. Only the first row showed a rank of 1 and remaining rows are unranked.
  • UPDATE over a remote database view (SQLVIEWM) view gives an SQL conversion error.
  • SCRETURN used in Script Views did not handle *ALL or *OMIT for a variable value.
  • In the ViewPoint Script Designer, when prompting the EXECUTE command, the last PC format in the list did not show.
  • SCRETURN in a Script View over a Client Report or Host Report did not respect the UNIQUEKEY parameter.
  • Runtime SQL conversion causes syntax errors when multiple files had correlation names.
  • Runtime SQL conversion causes error when unqualified field name is the same as a file name.
  • Runtime SQL conversion did not handle the MIN and MAX functions with more than one parameter, rather than just one parameter.

The following enhancements are included in version R10M29:

  • The SYNTAX parameter was added to the CVTQRY command to facilitate Query conversion with view attributes to utilize the SQE.
  • Host Table performance on V6R1 and above was dramatically improved. Testing results were at least five times faster.

The following updates are included in version R10M28:

  • Designing a Host Report with an SQL statement over a remote database caused error MCH0801 ‘Argument associated with external or internal parameter not passed’.
  • In SWI, intermittent JSON errors or no records returned when more than 100 SWI results tabs opened. The limit was increased to 1,000.
  • From the Design View (DSNVIEW), F9 screen Green Screen designer produces .txt file when *XLSX was chosen.
  • When ViewPoint options set to send joblog when submitted job completes did not send email if a spooled joblog was not produced.
  • From SWI, PDF output can be truncated because page size attributes not used from user SEQUEL defaults (SETDFT).
  • SEQUEL Defaults (SEDFT) provides and allows a value of *JOB for the Job Description. This is not valid and should not be allowed.
  • The green screen Script Designer should not a host table to be placed on the SCRETURN command.

The following updates are included in version R10M27:

  • A Script Command Label name is truncated at seven characters when run from the green screen using RUNSCRIPT.
  • Scripts run from both green screen and ViewPoint are not properly monitoring for the message (MONMSG). Scripts ended with the error instead of continuing to process when the monitored message was encountered.
  • In ViewPoint Script Designer, saving a script to a Library that doesn't exist gives a false success message.
  • Saving script or running script from Script Designer when script has a comment line of all asterisks (*****) gives error RNX1255 - ‘Session or device error occurred in file SCRCMDD’.
  • Message handling was improved within the Script Designer to provide the statement number of the command line with the error.
  • If there is a remote server entry with a blank name, prompting the SQLCONNECT for list of servers shows none of them. Blank server entries will not be allowed to be entered through the MNTHOSTF command or ViewPoint Administrator.
  • Using the DURATION function in either STRSQL (even when properly qualified) or using *LOCALSYS and *SEQUEL produces the error SQL0204 - ‘DURATION in *LIBL type *N not found’.

The following updates are included in version R10M26:

  • DSPVIEWD to a source file with view variables with Integrity Checks close to the maximum size of 80 create a corrupted file.
  • Submitting a script in batch, produces the error ‘CPF4101 File SCRPROC in library QTEMP not found or inline date file missing - on program SCRRUNR2’
  • *STRICT authority was not enforced for Reports, Client Reports, and Client Tables.
  • Runtime SQL Conversion for server *LOCALSYS and syntax *SEQUEL errored with derived expressions on the JOIN clause.
  • Runtime SQL Conversion for server *LOCALSYS and syntax *SEQUEL errored when view with HAVING clause in subquery.
  • Runtime SQL Conversion for server *LOCALSYS and syntax *SEQUEL errored when the TIMESTAMP function was used.

The following enhancement is included in version R10M26:

  • Script views combine the multi-step processing capabilities of standard scripts with the ability to direct results to multiple output options like a view.

The following updates are included in version R10M25:

  • Authorization code support added for Live Partition Mobility.

The following updates are included in version R10M24:

  • In SWI, when a script that has multiple host reports to process, if any one of the reports returns no records, nothing gets displayed from that point down.
  • In SWI from the Explorer, scrolling through a large record set gives MCH0603 unmonitored by QRYO07BUF.
  • Application Drill-down failing from SWI with JSON Error and No Records Selected when the field referenced has an ALIAS (long field name) associated with it.
  • In jobs with DECFMT(J) or DECFMT(I), INSERT command results in QRY7010 ‘x fields specified for output but z were supplied as input’.
  • When emailing a host report emailed in RTF format, any fields that contains a slash (\) will truncate characters after the slash.
  • Improved EXECUTE with TOSERVER and OUTFILE parameter dependencies. The current change specifically prevents specification of OUTFILE and TOSERVER unless SERVER(*SEQUEL) is also used. All other requests, whether against *local, *localsys or other remote database will get QRY2234 'OUTFILE, TOSERVER and SERVER values are not compatible' if the OUTFILE parameter is provided.
  • REPORT command sending results to IFS, gets a CPE3486 'Path Name Too Long' error when the TOSTMF parameter uses one slash instead of two.

The following updates are included in version R10M23:

  • Running the UPDATE command, based on a view did not change the 'Last used Date' on the view object.
  • FNCCLN on a specific function, instead of *ALL, gives CPD3130 ‘Missing operator in expression’.
  • In SQL Runtime Conversion, SERVER(*LOCALSYS) and SYNTAX(*SEQUEL), gives SQL0122 ‘Column x or expression in SELECT list not valid’ on a grouping view with expression in SELECT clause.

The following enhancements are included in version R10M23:

  • The Search Script (SCHSCRIPT) command allows you to find text in the content of Script User Spaces, and optionally replace that text with alternative text.
  • The Create Script (CRTSCRIPT) command now allows many scripts to be created at one time using SCRMBR(*ALL).

The following fixes were included in version R10M22:

  • Multiple EXECUTES from a SEQUEL host table when the table is defined using a character field for the column (i.e. no summing, etc.) created inconsistent results when the runtime generated column names are forced to RENAMED001 and RENAMED002, and so on.
  • Reports created or saved from ViewPoint using a DBCS OPEN field returned an RPT7018 ‘Field &N defined in the report is not compatible with the query view’ message.
  • Issue where WEEKDAYS function wasn't always returning correct results resolved.

The following enhancement is included in version R10M22:

  • The SQLJOINDB file for Auto Join entries was increased from 256 positions to 2048 positions.

The following fixes were included in version R10M21:

  • Running a view with more than 378 quotes gave the error MCH0603 ‘Range of subscript value or character string error’.
  • Using the SQL runtime conversion gave error RNX0301 ‘Java exception’ when using CHARACTER() and DECIMAL().
  • Using the SQL runtime conversion, referenced fields will be expanded with the replacement value enclosed in parenthesis.

The following updates were added in version R10M20:

  • From the DSNVIEW green screen view designer, the FROM clause prompt won’t prompt for a member name when using SERVER(*LOCALSYS) SYNTAX(*SEQUEL).
  • EXECUTE to XLSX creates a temporary directory, such as XLSXDIRnnn, that is then zipped to create the actual .xlsx file. If the maximum .xlsx file size (uncompressed 4GB) was exceeded, the temporary directory was not cleaned up. Also improved the message text for QRY7018.
  • DBCS field attributes were returned incorrectly as zero length in both ViewPoint and green screen.
  • A view with columns that contain the $ character sending output as xlsx created a file that was empty when opened.
  • From SWI, a view display that contained a field with a \ as the last character in that field, caused the display to come out as an unformatted string, beginning with the JSON Decode Error.
  • Executing a view gave message, CPF950A storage limit exceeded for data queue, when creating a PC file or running a client table from views with large amounts of columns or data.
  • From the ViewPoint Administrator Set Defaults option, Apply to All Users to make a global change to the SYNTAX and SERVER parameters didn’t work.
  • From ViewPoint, a view with DBLIST with filter that passes a value of an ampersand looped.
  • DSPVIEWD with a generic library name did not return view definition data.
  • In the green screen tabler designer (DSNTABLE), editing a dimension and using the Expression Editor caused error, MCH0603—unmonitored by TBLO01.
  • EXECUTE to stream file as XLSX when no file extension was specified created a zip file, but the file extension should be blank.
  • VALID_TIME was not working when a single numeric field or value was specified.
  • Writing XLSX data that includes invalid character data resulted in Excel spreadsheets that wouldn’t open, and caused error QRY7018, Spreadsheet size or row limit exceeded. Unable to insert additional rows.'
  • DSNSCRIPT evaluates CONDSQL based on the value returned. RUNSCRIPT is correct in evaluating true if 1 or more records are returned, false otherwise.
  • BCHSCRIPT ships with ALWLMTUSR(*YES).
  • A limited user running a script could encounter error, CPD0175 Command xxx in library zzz not allowed.
  • A script would hang when the last statement was a MONMSG.
  • EXECUTE with FTP sent different messages whether using view (SQLVIEW) or a runtime prompted view (SQLVIEWP).
  • When there are more than 999 user default data areas , SETAUDDFT gave error RNX1255 unmonitored by SETAUDDFTR. The limit has been increased to 9,999.

The following enhancements were added to version R10M20:

  • The DISTANCE file used by the functions: DIST_KM, DIST_MILES, DIST_REF_KM, and DIST_REF_MILES has been updated with current zip codes.
  • A new function named DURATION easily creates a time duration in the specified elapsed time (such as, months, days, hours, etc.) from two time stamps.
  • In BLDJDELF, the number of UDC fields allowed was increased from 32 to 64.
  • Improved the space utilization of data queues, which are used when writing to PC files and Client Tables.
  • The non-prompted version of VPCLEANUP in SEQUEL was replaced with the prompted version from SEQUELEX.

The following updates were included in SEQUEL version R10M19:

  • When using EXECUTE to a stream file (TOSTMF), the change of the view was modified.
  • When using DSNVIEW to open a view with SERVER(*LOCALSYS), received RNQ0202, The call to *LIBL/GETTOK ended in error.
  • With EXECUTE and *XLSX when no records were selected, the stream file process ended abnormally. The files will be written out empty so that headers show.
  • With EXECUTE and *XLSX, the process was improved to more accurately calculate when the *XLSX spreadsheet reaches its internal 4GB limit and avoid message QRY7018, Spreadsheet row limit exceeded.
  • When running a script in green screen DSNSCRIPT, the MONMSG command did not correctly monitor for the specified message. For example, MONMSG MSGID(CPF0001) didn’t detect a CPF0001 escape message.
  • Prompting the PCFMT of the EXECUTE command did not show *TXT even though it was allowed.
  • Changed all service programs to be owned by QSYS.
  • DSPDASHD did not return results.

The following enhancements were added to version R10M19:

  • Made a performance enhancement to the ViewPoint Expression Editor in View Designer when using *LOCALSYS connections and join logical files.
  • Opening the green screen view designer using DSNVIEW *CREATE uses the Default Server from the user defaults (SETDFT).
  • Added a new function named WEEKDAYS to calculate the number of weekdays between two dates.
  • The RTVRPTD size limit for embedded SQL statements was increased to 20,000 positions.
  • CVTQRY now has a SERVER parameter so Queries can be imported to use *LOCALSYS.

The following update was included in SEQUEL version R10M18:

  • When using SEQUEL R10M17 and the RBTADMIN user profile didn’t exist on the system, SEQUEL gave error MCH1001, Attempt to use permanent system object DFMT10 without authority.

The following updates were included in SEQUEL version R10M17:

  • LONGJUL format of VALID_DATE returned all zeros implying the dates were not valid.
  • When creating xlsx output and the DECFMT is I or J, which uses a comma as the decimal separator, the command needed to be written in the xml data using a period.
  • From the SWI Explorer, sorting on a column with data with embedded double quotes (“) failed.
  • From the SWI Explorer view results, sorting on a field with an alias name caused error QRY2006, field specified in ORDER BY clause not found in file list, because the ORDER BY clause used the alias and not the field name.
  • Large, complex views with many single quotes caused MCH1202, Decimal Data Error, in GETSTR.
  • MONMSG in a script failed if preceded by a blank line.
  • Script with QSTRING variables run from a green screen environment was putting extra quotes around the variable.
  • LIDLOBJX used USRPRF(*OWNER), changed to USRPRF(*USER).
  • PRINT should not issue errors CPD4008, Printed record of file SQLPRT1 continued on next line, or CPD4090, Printer device not found.
  • BCHPRINT truncated SQL statements when it ran.
  • EXECUTE to PDF with password and runtime prompted view did not require the password when opening the PDF.
  • From the SWI Explorer, received an unexpected error when displaying user spaced dashboard (SQLDASH) saved from PC dashboard (.vpt) with ViewPoint 10.11.280.

The following enhancements were added to version R10M17:

  • Auditing now supports remote database views, including *LOCALSYS views.
  • Additional checking when designing or running a host report to detect the data type of fields has changed from numeric to non-numeric.
  • Number of SUM calculations in a host report was increased from 100 to 200 to avoid MCH0603 error in QRYO03.
  • Enhanced the xlsx process to use command SQZIP instead of ZIP to avoid potential conflicts.

The following updates were included in SEQUEL version R10M16:

  • In ViewPoint, fields with a Numeric edit code with a floating dollar sign (for example, EDTCDE(1$) ) gave error QRY2301, Identifier '$' preceding ') FROM seq' is used incorrectly.
  • Designing a host report over a view with a remote database connection with a 10-character field name on the ORDER BY clause caused error RP7011, Report summary levels are incompatible with query ordering.
  • SQVER gave error RNX0100, length or start position is out of range for the string operation, when the company name was between 38 and 40 positions.
  • Host reports were not correctly displaying Chinese characters. Attributes of display files were changed to support DBCS.

The following enhancements were added to version R10M16:

  • Added the STRICT setting to Object Authority Checking Provides to provide an additional layer of security to restrict design and run-time access based on the entries in the SEQUEL Security Dictionary.
  • Work with Audit was enhanced to analyze strings up to 25,000 positions to avoid MCH3601 error on exit.

The following updates were included in SEQUEL version R10M15:

  • When a report has ORDER ONLY fields, the message RPT7011, Report summary levels are incompatible with query ordering, is now a Diagnostic, not an Escape message.
  • Report Designer was not handling 10-character ORDER BY field names when the view used a remote database.
  • The automatic Host Report conversion process, which happens only when there have been long lapses between updates, was changed to leave the report CCSID set to 0 during the conversion. This allows the report to be designed with the correct CCSID in non-English environments.
  • Changed the TOSTMF parameter of the EXECUTE command so a string beginning with // is not assumed to be a remote database connection.
  • The process to zip a *XLSX file when the job had a non-English CCSID gave error CPRF9898, ‘error in opening ¢Content_Types!.xml for reading’.
  • An EXECUTE with a view that used SERVER(*LOCALSYS) to override the view caused error QRY9995, SQL statement empty or blank.
  • When connecting to a remote database, if ADDENVVAR to specify JAVA_HOME was used, error MCH3601 in SQLQRYMJNI occurred.
  • Runtime SQL Conversion ( *LOCALSYS *SEQUEL) gave error QRY2232, Cannot translate SQL from *SEQUEL syntax to standard SQL, with *PARTOUT join on derived field.
  • The PRINT command did not include the SQL summary at the bottom even though SUMMARY(*YES) was specified.
  • EXECUTE using a host table (SQLTBLV) that uses a runtime prompted view (SQLVIEWP) created an output file with the same name as the table in the library of the table, not based on the OUTFILE parameter.
  • Creating an XLSX file to an unqualified directory caused the error, Excel cannot open the file myfile.xlsx because the file format or file extension is not valid, when opening the file.

The following enhancements were added to version R10M15:

  • The INSERT, UPDATE, and DELETE commands were enhanced to include the SERVER and SYNTAX parameters to allow data manipulation on remote databases.
  • Print Report Definition (PRTPRTD) was enhanced to include an SQL statement from view.
  • From DSNVIEW, the F9 screen to create a PC file now supports *XLSX, *XMLXLS, and *PDF formats.

The following updates were included in version R10M14:

  • When ORDER BY fields have been removed from the SELECT clause, running the report gave error MCH4405, Tried to deactivate program QRYO06 while it is running.
  • From the SEQUEL Web Interface, when SEQUEL User Defaults were set to Query Auditing Y, creating a remote database table created the table, but erroneously sent message MCH3401, Cannot resolve to object SQLEXEC.
  • An EXECUTE in *XLSX format when the view contains edit codes with a currency symbol ($) to an IFS stream file using the TOSTMF parameter caused an error when opening the file in Excel.
  • Execute of Host Table (SQLTBLV) over a prompted view (SQLVIEWP) to a stream file as PDF or RTF did not create the file.
  • RUNCMD *PGM now runs under *USER, not *OWNER.

The following enhancement was added to version R10M14:

  • The method for Java startup to make remote database connections was improved to connect using the new technology JVMs under V7R1.

The following updates were included in version R10M13:

  • Improved message handling on DSNVIEW when not using SERVER *SEQUEL or *LOCALSYS.
  • From the SEQUEL Web Interface, when Query Auditing in user defaults was set to Y, it gave error CPF2479 in SNDJRNE01.
  • Using SQL Runtime Conversion, SERVER(*LOCALSYS) and SYNTAX(*SEQUEL) with HREF gave error SQL0204.
  • From ViewPoint, a host table (SQLTBLV) that produces more than 34 columns would give error CPF2498 ‘Invalid length. MAXLEN for data queue is 2048’.
  • REPORT to a stream file ended in error if the file existed and REPLACE(*NO) was used on the command.
  • Submitting a runtime prompted report from the exit screen of DSNREPORT using F14 would give errors CPD0020 ‘Character ''' not valid following string 'SAME’ and CPD0014 ‘Matching apostrophe not found’.

The following enhancements were added to version R10M13:

  • In SQL Runtime Conversion, SERVER(*LOCALSYS) and SYNTAX(*SEQUEL) now handle System/36 file names that include periods.
  • Added support for Excel .xlsx and .xmlxsl formats.

The following updates were included in SEQUEL version R10M12:

  • From the SEQUEL Web Interface, Download View results to Excel showed numbers as negative, blank, or a box the first time it was downloaded (requires SEQUEL Web Interface R10M02).
  • From ViewPoint, ‘No records returned’ messages were returned properly in unique cases.
  • REPORT command to send an e-mail message (EMLMSG) that was less than four characters did not include the attachment.
  • EXECUTE a VIEW to e-mail as PDF sent two e-mails with attachments when no records were selected.
  • From the green screen designer (DSNVIEW), when changing a SQLVIEW to SQLVIEWP by adding a variable or prompting the SELECT clause of a view larger than 9800 characters, caused message QRY3004, String beginning is never ended.

The following enhancement was added to version R10M12:

  • Added a new function, VAL2WRD, which converts numeric values to words.

The following updates were included in SEQUEL version R10M11:

  • Saving a runtime prompted view with more than 9,800 characters from ViewPoint caused error CPD0014, A matching parenthesis note found.
  • Running a view from ViewPoint that returned no records and included a date expression converting a literal to a date data type caused error MCH1202, Decimal data error in VPTROUTER.
  • In the ViewPoint View Designer, the Join Type was not saving when Database was changed on the Properties tab.
  • Designing a Client Report in ViewPoint over a view where one variable has an integrity test that depends on another variable resulted in error MCH1202, Decimal data error, when trying to save the report.
  • When using PRINT or EXECUTE to e-mail PDF output when the user default value of ‘Send if no data’ was No, the associated spooled file was not deleted.

The following enhancements were added to version R10M11:

  • In the Administrator Set Defaults Host tab, *LOCALSYS was added as an value and the Server parameter was added.
  • Performance improvement to QRYO07 on V6R1 when creating files on the IFS.

The following updates were included in SEQUEL version R10M10:

  • TABLE command gave error message CPD0078 “Value ' 'for parameter JOB not a valid name” when using F14 to submit from a prompt variable.
  • EXECUTE with TOSTMF with *STDOUT and run-time prompted view did not create a file.
  • Runtime prompted views (SQLVIEWP) with many expressions caused MCH0603, ‘Array Index Error’ in GETTOK.

The following enhancement was added to version R10M10:

  • CVTQRY now supports a CROSS JOIN.

The following updates were included in SEQUEL version R10M09:

  • Table with an Embedded Category field longer than 40 positions gave error MCH0603, Unmonitored by TBLO01.
  • Using the batch commands (for example, BCHEXECUTE, BCHPRINT, and BCHREPORT) could cause error MCH1210, Unmonitored by SQLRQSC, when the message queue was full.
  • Script definitions from DSPSCPRIPTD showed wrong order of variables in a script.
  • View or script with a COMP Integrity test with a DATE variable gave MCH1202 Decimal Data error.
  • Green screen designer, DSNSCRIPT, removed comments from internal commands.
  • List dictionary commands had wrong names. LSTXCLOBJ was changed to LSTDCTOBJ; LSTXCLUSR was changed to LSTDCTUSR.
  • Sequel Field Level Authorization report had EXCLUSION in the title regardless of actual dictionary type.
  • Using *LIBL file designation on a FROM clause in conjunction with *SEQUEL Inclusion security resulted in error, “can’t find file *libl/”, when designing a view.

The following updates were included in SEQUEL version R10M08:

  • Improved message handling when host table gives MCH1210 unmonitored by TBLO01 and SQLTBLC when maximum number of column groups is reached.
  • From a script in ViewPoint, REPORT with RECIPIENT picked the wrong spooled file for e-mailing when the same host report was run multiple times in the same script.
  • PDF output without a PDF password gave the message “Adobe Reader could not open.”

The following updates were included in SEQUEL version R10M06:

  • SEQUEL functions were not created when using FNCRUN if the decimal format (DecFmt) was a comma.
  • Using EXECUTE to create a TOTABLE on a TOSERVER gave an error when the OUTFILE library and name were long. Various Java errors were issued that did not seem specific to the problem.
  • The time and date in the SEQUEL Host Report showed wrong values when an AnyDate override was active.
  • In rare instances, running a script from ViewPoint gave the error MCH1202 “Decimal Data” in VPTROUTER.

The following updates were included in SEQUEL version R10M05:

  • The SPLIT function gave error MCH3601, Pointer not set for location referenced, on V6R1 when null values are returned.
  • Using SQL Runtime Conversion, SERVER(*LOCALSYS) and SYNTAX(*SEQUEL), EXECUTE was creating variable-length (Unicode) fields two bytes shorter than they are supposed to be. This caused error SQL0332, Character conversion between CCSID 13488 and CCSID 65535.
  • SQLCONNECT gave error QRY9995, The driver could not establish a secure connection, on a V7R1 connection to an SQL Server 2005 database.
  • Using SQL Runtime Conversion, SERVER(*LOCALSYS) and SYNTAX(*SEQUEL), on a UNION view with more than one UNION gave error MCH0603, Range of subscript value or character string unmonitored by QRYP02.
  • Using SERVER *LOCAL or *LOCALSYS with SYNTAX(*SERVER) when the ORDER BY used an expression caused error MCH3601, Pointer not set for location referenced.
  • Using SERVER *LOCAL or *LOCALSYS with SYNTAX(*SERVER) with EXECUTE to create a keyed physical file when the ORDER BY used an expression caused error CPF3206, Key field x not found in record format VIEWFMT.
  • Using SQL Runtime Conversion, SERVER(*LOCALSYS) and SYNTAX(*SEQUEL), on view/SQL statement with IN or NOT IN using only one value gave QRY2232, Cannot translate SQL from *SEQUEL syntax to standard SQL.
  • Using SQL Runtime Conversion, SERVER(*LOCALSYS) and SYNTAX(*SEQUEL), didn’t translate CONTAINS predicate.
  • From ViewPoint, a submitted e-mail request to create an Excel file using SERVER(*LOCALSYS) and SYNTAX(*SEQUEL) and CVTDATE caused error SQL0104, Token.1 was not valid.
  • E-mailing a PDF created with a password from EXECUTE and PRINT did not require a password to open the PDF document.
  • Any process using multiples of the following parameters: OPTIMIZE, ALWCPY, IGNDECERR, UNIQUEKEY, MSG, JTYPE, JORDER, DTSTYLE, SERVER, SYNTAX, or TEXT could cause error CPF0013, A matching parenthesis not found.
  • On the AutoPrompt window for runtime prompts, lengthy extended help text was truncated in ViewPoint.

The following enhancement was added to SEQUEL version R10M05:

  • Using SQL Runtime Conversion, SERVER(*LOCALSYS) and SYNTAX(*SEQUEL), on a partial outer join on a derived field caused error SQL0199, Keyword AND not expected. Valid tokens: ON FULL LEFT CROSS INNER RIGHT USING EXCEPTION.

SEQUEL version R10M04 included changes that were internal to the product.

The following updates were included in SEQUEL version R10M03:

  • Saving a Client Table built on embedded SQL failed with an error about an invalid server name.
  • SEQUEL was unable to save results from a *LOCAL or *LOCALSYS view to a remote database.
  • Entering an empty string for a column heading caused incorrect column headings at runtime and various design problems on the Files/Fields tab.
  • Column headings for SERVER(*LOCAL/*LOCALSYS) used the field names rather than the column headings in the file.
  • Views using SYNTAX(*SEQUEL) that include WDATA fields used wrong column headings.
  • In the green screen designer, diagnostic messages didn’t appear to the user when using the SEQUEL Inclusion/Exclusion security dictionary.
  • In the green screen designer, using F9 to EXECUTE and ADD Records resulted in existing records being replaced.
  • Sending SEQUEL output to a PC file in text or pdf format in a CL program resulted in an unmonitored CPF3344 message even though the PC file results were created successfully.

The following enhancement was added to SEQUEL version R10M03:

  • Improved the conversion of *SEQUEL statements to *LOCAL//*LOCALSYS for grouping views to preserve correct file qualification on the Group By clause.

The following updates were included in SEQUEL version R10M02:

  • In the green screen Design View, the ORDER BY clause prompting was not working correctly.
  • In the green screen Design View, the WHERE F13 Subquery prompt returned a jumbled SQL statement.
  • PRINT with PCFMT(*TEXT) gave error QRY2218, Invalid PC Format specified
  • CHGVIEW gave errors QRY2305 or QRY2006 indicating an invalid SQL statement. This was most commonly seen when using CHGVIEW in a CL program.
  • EXECUTE with OUTFILE and REPLACE(*YES) did not delete the outfile first.
  • Saving a view from the CHGVIEW screen gave MCH3601, Pointer not set for location referenced.
  • EXECUTE to *xls gave MCH0603, Range of subscript value or character string error, in QRYO07 when intermediate storage for the XLS file was exceeded.

The following enhancements were added to SEQUEL version R10M02:

  • Added help text for the DSPDASHD command.
  • The Date Style (DTSTYLE) of a remote database view (SQLVIEWM) will always use *ISO for the date/time format.Databases other than DB2 do not have the concept of a run-time DTSTYLE so this allows for consistent date styles across databases.
  • Changed the format of excel files created through EXECUTE to be considered from a trusted site to avoid a warning message in Excel 2010.

The following updates were included in SEQUEL version R10M01:

  • IS NULL comparisons generated a CPD4325 selection error.
  • OVRPRTF FILE (*PRTF) caused the PRINT and REPORT commands to fail with MCH1210 ‘Receiver value too small to hold result’.
  • RUNCMD returned CPD0043 ‘SYNTAX keyword not valid’ when a runtime prompted view (SQLVIEWP) was used in the VIEW parameter.
  • SQLPARMS file was changed to support LEFT and RIGHT functions from the ViewPoint Expression Editor.
  • Batch commands (such as BCHEXECUTE) failed with message CPD00014, Matching apostrophe not found. This was a random occurrence based on the message key variable.
  • Removed obsolete object SWI815DA from the SEQUEL library.
  • In ViewPoint, selecting ‘Save Results As>Physical File’ with a prompted view (SQLVIEWP) set to run immediately generated RNP6999 ‘Variables must be set before this runtime view can be run’.
  • The initial size of CPIALL *FILE has been changed to *NOMAX.
  • The OUTFILE command generated error CPD0172, Parameters passed on call do not match.
  • Table views (SQLTBL) over remote database to create a PC document failed with QRY9995 and CPF4278.
  • F16 (User Defined Options) in the Work with SEQUEL Objects display (WRKSEQUEL) showed an incorrect option list based on file name.
  • Change added for remote database views (SQLVIEWM) with field names greater than 10 positions.
  • In a runtime prompted view (SQLVIEWP), the title or TEXT parameter was truncated at 40 positions if a variable was included as part of the value.

The following enhancements were added to SEQUEL version R10M01:

  • Output from REPORT TOSTMF(*STDOUT) has been enhanced to allow PCFMT(*PDF) and PCFMT(*TEXT) values.
  • Added SEQUEL 10 runtime conversion support for the following UDF functions: INDEX, VERIFY, and XLATE.
  • The CVTANSI size limit was increased from 9,000 to 20,000 positions.

Sequel Viewpoint 11 (top)

Currently Shipping Version: 11.16.294

The following enhancements are included in this version:

  • Text size on many objects (views, host table, client tables, Client Reports, Scripts, Script Views, and Applications) was increased from 50 to 128 characters.
  • View Builder and View Designer will support ‘Fetch First’ with a *LOCALSYS or *LOCAL connection and *SERVER syntax.
  • Allow library name to be specified when saving Viewpoint object to Repository.
  • In the Script Designer Variable tab, grid columns will match the view designer to make more readable.
  • Excel Add-in now supports 64 bit Excel.
  • Dashboards: 
    • The 2 dimensional chart options were added to menu dropdown.
    • Copy/Paste actions added for Gauges, text boxes, action button and graphics. 
    • New option for Web Preview to see an HTML preview.
    •  Snap to grid for easy alignment of text, action button, and result windows.

The following updates are included in this version:

  • In Administrator, the copy defaults option was using the default user—not the selected user.
  • From Administrator, Set Defaults option, copying a current user defaults to a new user profile causes a
  • View Builder and View Designer give error that file cannot be found when the datasource is another *ISERIES connection.
  • View Builder did not allow creation of multiple derived fields.
  • In Warehouse Builder from ViewPoint Explorer, caused error due to parameters not being passed.
  • Script View run in Viewpoint Explorer runs the body of the script twice.
  • Prompted Script that runs from a Viewpoint shortcut results in the following error MCH1202 unmonitored by VPTJMSG at Statement *N, instruction X'0011'.
  • Option to schedule an email as PDF failed when using the IBM Job Scheduler.
  • Email request from Viewpoint as PDF ends abnormally, error in print command, when host version is less than R11M04 (for Sequel) or R10M04 (for Showcase).
  • From View Designer, file in FROM clause specified with *LIBL does not send message when library is not on the library list of Viewpoint job.
  • From the View Designer Files & Fields tab, when designing a DATABASE(*LOCALSYS) SYNTAX(*SEQUEL) View, use of EDTCDE(L) on a numeric field will be dropped when moving to/from the Files and Fields tab.
  • View Designer should omit literals and constants from GROUP BY Clause.
  • View Designer not handling French à character in FILE names with SERVER(*SEQUEL)
  • From the View Designer, displaying view result after stepping in to a SELECT statement of a UNION view causes and unwanted ORDER BY to be added to the full SQL Statement.
  • Once a DISPLAY returns no records, the script ends without running the remaining steps.
  • When a user has assistance level set to 1 or 2 and View Builder is enabled, the setting renders the CRO (User based license) design window in a small frame and it cannot be resized.
  • When two DATE variables used a default value and the second variable was *NOPROMPT, the first variable used the wrong default value.
  • Unable to enter date of 12/31/9999 in date variable when run in ViewPoint.
  • Dynamic Drill Down (Regroup or Show Details) fails with a *LOCALSYS view with file qualified fields.
  • Creating a shortcut from a view display that also includes a chart produces a .vptchart file type instead of .vpt.
  • Expression Editor better handles field names with double quotes.
  • Subtotals in view results did not show if the ORDER BY fields used a field with an alias name.
  • Dashboards:
    • A dashboard with an Action Button set to Autorun fails to run a prompted object successfully when the variable is passed using /SETVAR.
    • Chart title should be consistent at design time and run time.
    • When the Dynamic Drill Down List file (SEQUEL/VPTDYNFLTR) contains a list of fields, only those fields are available for dynamic drilldown. If the file contains fields, but no fields that exist in the files that a grouping view references, then the option to view the complete list should appear in SWI, as it does in ViewPoint and SWS.
    • Reprompting from a dashboard with a graph for new choice and receiving less records, produces an Overflow error.
    • Digital gauge custom mask entries, like a $ sign, don’t display correctly.
    • Inserting a view that returned no records cause the Designer to hang.
    • Variable prompt windows often show behind the dashboard and cannot be seen.
    • After adding chart, right click for Properties caused Properties window to come up behind designer window.

The following updates are included in version 11.16.098:

General

  • From the ViewPoint Explorer, clicking on an object and cut, the paste action gives error CPD0043 ‘Keyword OBJTYPE not valid for this command’.
  • From Script Designer, unable to save a script if changes were made after saving it
  • If a Client Table is opened for design, but the only changes made are in the Group Footer Editor, the warning message "Do you want to save changes to this Client Table" was not issued.
  • Using *SERVER syntax with a Grouping view with expressions for columns, Drill-Down/Show Details creates invalid SQL syntax.
  • Runtime SQL conversion when using SERVER(*LOCALSYS) and SYNTAX(*SEQUEL) will convert inner join to WHERE condition with an additional pair of parentheses.
  • Runtime SQL conversion when using SERVER(*LOCALSYS) and SYNTAX(*SEQUEL) failed when a UDF name is schema qaulified (i.e. select sequel.valid_date(2150101,''*CYMD'')).
  • VALID_DATE function loops in rare circumstances.
  • ViewPoint option for Field Sorting will now default to position, not alphabetic, for new installs.
  • Import Query/400 option will now default to a view, not a report.
  • Creating a Host Table over a view using the ViewPoint Universal Driver (JDE or *ADS connection) caused an error.
  • From View Designer Files & Field tab, removing any files except the last file caused ViewPoint to hang.
  • Application Builder can now create drill to option for Client Reports.
  • Silent Install now supports the Excel Add-in install.
  • Dashboard Action Button to Email View Results was not sending view text for subject line for PDF attachments.
  • ViewPoint is unable to save view containing a WITH predicate.
  • From the Variables tab of View Builder or View Designer, in the Integrity Test for DBLIST, the ‘View List’ button di not return records when the view name was specified.
  • The Expression Editor of both View Builder and View Designer now has multiple entries for the DATE function.

Dashboards

  • Default background color changed to white.
  • Default font changed to Verdana size 11 for text and Verdana size 9 for Action Buttons.
  • Default chart colors changed to 128 Pastels.
  • After bringing a chart to the front or back, it will now be sizable.
  • Text in text boxes will now be centered.
  • Gauge using the COUNT function that returns a single record with now work correctly.
  • Gauges did not work correctly when PC region setting did not match IBM I setting.
  • Background image size changes on mouse click.
  • When closing a dashboard using the X, the save option will now give you option to save as pc object as well as IBM i object.
  • If a chart is built over a Client Table, the hide data option will work.

Excel Add-in

  • Able to add View columns to non-contiguous columns in Excel therefore allowing blank columns in the spreadsheet.
  • Spreadsheet containing a view with a name that contains a special character (such as @), did not have the add-in available.
  • Add-in would freeze if using a prompted view, choose Refresh, Click Cancel on prompt window, and close the spreadsheet.
  • Choosing View References and then columns causes error Cannot find column[viewname] Line 0 in some instances.
  • Using a view with hidden columns (WDATA) showed incorrect fields in Choosing Columns list.
  • View that returns one record will not refresh when the second requests has more than one record.
  • On the 22nd refresh, the add-in would hang.
  • Extendable area not automatically resizing when a prompted view is used.
  • When the view contained a grand total and a calculation was added to the extendable area that is a percent of total, when the refresh returned different amounts of data, the calculated field was wrong.
  • Improved control on Column Selection window.
  • The Add-in will now use brings data into the spreadsheet, columns should be formatted as specified in the view.
  • Add-in is now supported for Excel 2016 32-bit.
  • System Default will use Default Sever from ViewPoint Options.

View Builder

  • The Files tab will use the ViewPoint Options to include or exclude logical files in the list.
  • Creating a new view with SYNTAX(*SERVER) with a left outer join corrupts the SQL statements and causes ViewPoint to hang.
  • View Builder will now use the ViewPoint option for Field Sorting on the Field tab.
  • The File tab will now have *FAVORITES in the Group pull down to use the favorite list of files from ViewPoint Options.
  • View Builder hung on the Join tab when the same file was added more than once.
  • Sort tab will now show list of fields when SELECT * is used.
  • Sort tab now allows properties for Ascending or Descending and Absolute value sorting.
  • The Field tab will now use the ViewPoint option for Field Sorting.
  • On the File tab, resequencing the files did not actually change their order on the FROM clause.
  • On the Field tab * for all fields is now removed when fields are selected.
  • Expression Editor of Filter tab now has a third combo box for field comparisons.
  • File tab will provide Member list for multiple member files when using SYNTAX(*SEQUEL).
  • Filter tab will now support derived fields when using SERVER(*LOCALSYS).

The following enhancements are included in this version 11.16..098:

  • The Auto-join process has been updated to support views with SYNTAX(*SERVER) when the join criteria appears on the WHERE clause.
  • The Edit User Library list option and be restricted by setting Allow Command Line to No in the user defaults.
  • Dynamic Drill Down (details and regroup) is now supported with a datasource of *EXCEL or *ACCESS.

The following updates are included in version 11.15.317:

View Designer

  • View Designer grammar improved to allow double quoted identifiers in non *SEQUEL syntax sql. Also removed the quotes when checking against column names in a table.
  • View Designer should allow quotes around library names that contain special characters.
  • In ViewPoint Designer, if a DATABASE(*LOCALSYS) view is changed to DATABASE(*SEQUEL) when there was a left outer join with derived fields then, attempts to save the view results in Run-time error '0'
  • Script Views containing variables now retain the Description Text when they are saved instead of the default value of SEQUEL Script.
  • Script with commands like VPSHELL and SWIOPEN that can specify complicated strings containing multiple bits that begin with an ampersand (&) failed to do variable substitution.
  • A DBLIST variable that uses a description field to show in the dropdown list has a filter that is dependent on another non-dblist variable. If you run the view without actually clicking on a dblist value, the description value was used rather than the field value in the variable substitution.
  • When run from a shortcut, a prompted Script containing an EXECUTE to an existing file errors with ‘MCH1202 unmonitored by VPTJMSG’.
  • A script using a REPORT command to display a CRO report generates the error QRY2212 ‘PC Format of *TEXT requires Stream File or Recipient entry’.
  • During Save To Repository from Design Script, once the IFS location is chosen for the .vptscript, an erroneous additional dialog displays for the library location. This has changed so the script is always saved to the user's default repository location.

View Builder

  • Starting from View Designer, clicking View Builder from tool bar, followed by Cancel, and before saving, would not present an opportunity to save.
  • Files tab now displays message if file is not found.
  • Alias field names supported by the Files and Filter tabs.
  • Files tab now allows selection of file Member name when using *SEQUEL syntax.
  • View Builder Assistance Level *BASIC (1) and *INTERMEDIATE (2) now supports complex views with subqueries, very long CASE expressions, and JDE data with multiple derived join fields
  • View Builder Variables tab should always use single quotes when the view connection is *LOCALSYS.
  • On the Fields tab of the View Builder, there is a Pencil icon that can be clicked to edit a field, and an Up arrow to move the field up in the list.
  • If a derived field was highlighted, the last derived field on the list is acted on - not necessarily the field that was highlighted.
  • In View Builder, if you highlight any derived field in the list of fields, the Down arrow is no longer grayed out, as if the field is the last on the list.

The following enhancements are included in version 11.15.317:

  • Silent Install now supports modular switches to control installation of Client Report, Administrator, and Excel Plug-in.
  • In the email to download the Client Table Viewer, the link was updated.
  • New Excel Plug-in with the following:
    • Extendable area to allow Excel calculations based on dynamic data
    • Field/Column selection
    • Limit and modify number of row returned
    • Add multiple views to the same sheet
    • Add multiple views to different sheets
    • Selectively re-prompt or re-prompt all
    • Jump function to move easily through the spreadsheet to any extendible area or view

The following updates are included in version 11.15.167:

  • On a French language PC, from the results of a view or host table, the option for Format Layout gave an unstable error.
  • On PC with language settings that use the comma instead of the decimal point, opening ViewPoint gave an unstable warning message.
  • View Builder was removing the WHERE clause if it contained a NULL comparison.
  • In View Builder, creating a CVTDATE expression erroneously assigned an edit code M.
  • In View Builder, the File drop down list did not render a list based on the file name filter if you keyed in a library name first.
  • Editing the User Defaults using a drop list to the set one of the library values cause the user defaults to become corrupt and would cause errors about invalid parameter values.
  • View Builder Fields Tab, creating expressions without assigning a name results in the builder creating invalid names, such as 1 & 12.
  • View Builder Fields Tab, editing a field creating an expression, if you choose Cancel the original field is deleted. If you choose Done to finish, the field/expression is moved to the bottom of the field list.
  • From view or host table results, selecting Format\Layout on a French language PC caused a runtime error.
  • ViewPoint not handling French accent character in library names.
  • Decimal conversion error on product version when opening ViewPoint when PC setting used decimal instead of period like on a French language PC.
  • From the embedded Client Report designer, Display Results failed if report is built over a prompted Script View.
  • In View Builder, selecting a field and choosing the Edit (Pencil) button, then clicking on the Editor button, if you click Cancel at this point, the field is no longer being deleted from the list.
  • In View Builder when creating an expression, if you click on Done before entering in an alternate name, you now get a message that requires you to enter in a name before completing.
  • Improved message handling in View Designer when the SQL statement is not valid before re-entry into View Builder allowed.
  • Improved message handling in View Designer assistance level 3, when entering View Builder with a blank SQL statement.

The following updates are included in version 11.15.33:

  • From the Script Designer, choosing Tool Bar option to view Internal Variable Values causes runtime error and shuts down script designer.
  • View Designer is not accepting change to Database and Syntax setting through File>Properties.
  • View Designer should not allow an SQLVIEWM (remote database view) to change date style from *ISO.
  • Cannot save a CRO using Crystal Reports (2011) over a script view.
  • CRO Designer using Crystal Reports 2011, written over a view with a numeric or expression variable, will not save. Receive error that 'Value " " is not a valid number' message.
  • In the Script Designer, prompting CHGVAR VAR(&ABC) gives error 'Command Syntax is Incomplete’.
  • Script Designer allows an SCRETURN on Host Tables and should not.
  • ViewPoint Administrator gives error opening when SEQUEL installed into library not named SEQUEL.
  • In the Script Designer, scripts with hundreds of lines when the variable did not appear before line 226, the script would not save.

Sequel Viewpoint 10 (top)

The following updates are included in version 10.14.160:

  • In Client Table results, where a column is filtered down to show just records, and that field value is " " (Blank) , clicking Show Detail displays the following error ‘There were no records returned from drilling into the cell you chose. If this is unexpected, please contact SEQUEL Software support.’
  • For a prompted view, where the first display attempt returns ‘no records’, subsequent re-prompts return the message, ‘An error occurred while retrieving records: Value cannot be null.’
  • Views using Group and Sum functionality on field names containing special characters will display results properly when initially added, but once saved and run in ViewPoint, the fields with special characters will lose that functionality.
  • View results window is resized when data is refreshed.
  • When displaying a view, close and reprompt seems to remove all selected columns from the totaling function.
  • Client Table/Report windows appear behind Dashboard when run from an Action button.
  • Drag & Drop from the Explorer window to create a shortcut does not work.
  • Date Edit Codes Y and W, and an Edit Word using '/' or ':' creates corrupted values under SERVER(*LOCALSYS) SYNTAX(*SEQUEL) using runtime SQL conversion.
  • Designing a gauge over any group of cells that contain zero suppressed boxes does not work.
  • From the view results display, the option to Export to Excel produces an error: 'Application-defined or object-defined error' when the view has subtotaling turned on.
  • Import option is grayed out in some instances.
  • Quick Sum/subtotal performed on a zoned field does not show total in bottom.
  • In a view with two multi-select variables, the number of values chosen in first variable is duplicated in the second variable list.

The following enhancement is included in version 10.14.160:

  • Windows 8.1 support for the ViewPoint Administrator has been added.

The following updates are included in version 10.14.094:

  • Using the REPORT command to run a client report from a script causes ViewPoint to just hang.
  • Within the Application Designer, the option file maintenance dialog window has the wrong entry fields.
  • From a Client Table, ViewPoint ignores the series order saved in the shortcut when rendering line graphs and displays an error when runtime prompting results in fewer rows or columns.

The following updates are included in version 10.13.340:

  • Opening a dashboard with an autorun button for either a view or script displays the error, “An error occurred while retrieving records: Object reference not set to an instance of an object.”
  • Issue in the view designer where some very long expressions of around 2500 characters cause a Client Access API error (‘Client Access API cwbDQ_Write Failed in expression’) has been resolved.
  • Libraries can now be removed using the Viewpoint Edit Library List screen without error.
  • Crystal Reports 2011 can now open and resave objects with an underscore (_) in the name.
  • Selecting all cells in a Client Table with the totals turned off will graph results without error.
  • Custom PC formats created with WRKPCFMT now work with RUNRMTCMD and from Windows\Start\RUN.

The following enhancements are included in version 10.13.340:

  • Easily add grand and group totals to view results. Also, create quick totals and counts simply by highlighting cells. Requires SEQUEL version R10M29.
  • SERVER and SYNTAX parameters added to the import query feature. Requires SEQUEL version R10M29.

The following updates are included in version 10.13.304:

  • Client Reports and Host Report built over a Script View using Unique Key did not respect Unique Key.(R10M29 required)
  • Registry setting to use old CRO viewer doesn’t work from a command line switch.
  • Error when trying to save Crystal Reports 2011 report from the ViewPoint plugin when the system name contains a period, such as an ip address.
  • Gauges still retain a thin left border even when the Border option has been turned off.
  • The Restore Defaults button does not work in View Layout/Format Layout dialog

The following updates are included in version 10.13.260:

  • Data markers in Client Tables were adversely affected by non-visible fields due to assignment by column number instead of column name.
  • Hiding a derived column (expression using a date type field) with a test for null values generates a message that the expression is in error.
  • Hiding and unhiding a column on the Files and Fields tabs removes all remaining from the SQL.
  • A view with edit codes assigned are ignored if Format\Layout settings are defined.
  • Reprompting a host table generates an 'Invalid Column Index' error.
  • Show Details on a grouping view with a subquery containing a WHERE clause incorrectly rebuilds the SQL and generates a syntax error.
  • Show Detail on a ViewPoint graph generates a syntax error if the view is altered before the initial graph is created.
  • Error generated when saving Client Report if host is defined with an IP address.
  • Within the view designer a derived join does not issue expected warnings.
  • Reprompting single record stacked display renders new results in a very small window.
  • It appeared that a limit was being reached when adding multiple objects to a Dashboard resulting in some objects being deleted.
  • DBLIST was not retaining selected values when the drop-down menu was closed and reopend.
  • View names beginning with a ‘Z’ generate a /Z logging response warning.
  • ViewPoint Explorer freezes when a Windows setting changes after running a Script

The following enhancement is included in version 10.13.260:

  • VPSHELL enhanced with a new switch that creates .rpt files from Client Reports. This allows for drill-down (summary) reports to be distributed and used directly in the Client Report viewer.

The following updates are included in version 10.13.221:

  • Within the View Designer using a remote database, Expression Editor should not get type and length of field on derived field to improve performance.
  • Drilling down in an application from a graph, does not pass the value from the record that you clicked on. It passes the value from the field in the first record from the data display.
  • On a graph from a grouping view with hidden fields, if you right click on the graph and choose Show Details, that produces an odd Weighted Average graph.
  • From the Host Table Designer, Run-time error '2147418107 (80010005)', while editing a Step Category in a Table.
  • RUNRMTCMD running a Client Report to create a PC file from a script fails with error frmCrystal2_PCReportLoad after the 75th iterartion.
  • Script running another prompted script does not prompt for secondary variables when the variable had a Default Value.
  • Within the View Designer, expression editor did not allow the use of a date field with IS NULL.
  • Graph in Dashboard crashes intermittently when moving or resizing in certain conditions.
  • From the View Designer Run-Time error '0' received when typing field name in column on Files and Fields tab.
  • Hiding then unhiding a field, not an expression, in a view causes a Runtime error and you must close Viewpoint.
  • On Windows 7 Enterprise 64 bit, when trying to open a Sequel Application, receive “Run-time error 339. Component ‘SYSINFO.OCX’ or one of its dependencies not correctly registered: a file is missing or invalid”.
  • Error generated when emailing delimited files via a shortcut.
  • Delimited results from shortcut inconsistent with ViewPoint Explorer results.

The following enhancements are included in version 10.13.221:

  • Improve message handling in the OLE DB excel example.
  • Running the Administrator from ViewPoint will now pass /Z switch if logging is turned on in ViewPoint.
  • In the Client Table designer, an error occurred when adding data marker range values for one column that are the same as an existing data marker for a different column.
  • Dashboard Properties dialog in the dashboard designer has been enhanced to allow for changes to system and library values for SEQUEL objects and Action Buttons that reference SEQUEL objects. Access a single object with a double click or select multiple objects and easily change them all-at-once.

The following updates are included in version 10.13.155:

  • Dashboard locks when attempting to run a second script from an action button before prior script request completes.
  • In View Designer, a grouping view with an expression without a name erroneously placed the entire expression into the Group By clause.
  • XLSX output results in txt file extension when file name is longer than 8 positions.
  • Running a prompted view with a shortcut does not update the last used date on the view.
  • Within ViewPoint options, Edit Favorite List from ViewPoint options doesn't show values in correct column.
  • When the Sequel Defaults were set to use the *Favorite list of files in view design, the list was not being supplied properly, especially if there was just a single file in the list.
  • From the Expression Editor, when the same file is used in the view multiple times and the field is merely selected and not used in an expression, the field was always qualified with the first occurrence of the file.

The folowing enhancements are included in version 10.13.155:

  • A registry entry can be created to expose the Export to Excel option to the Client Report output using the Crystal 2011 Viewer.
  • ViewPoint now preserves format of the layout when the View is run if fields are added, removed or re-ordered in the Select clause.
  • In Dashboards, added “HideMenu/Toolbar” option to right click menu from SEQUEL Objects title bar.

The following updates are included in version 10.13.087:

  • On a PC with the Regional Language settings set to Turkey, ViewPoint will not start. You receive a whole series of Invalid Menu Item error messages.
  • ViewPoint ends in error when creating Client Report over prompted view using CR2011 version.
  • Not able to Regroup or Show Details when right clicking on a Graph section.
  • When a dashboard contains more than 10 Sequel views, each time the dashboard is saved, one of the views is deleted from the dashboard. This continues until there are less than 10 views, then nothing further gets deleted.
  • Unable to save CRO results as HTML with the embedded CRO designer.
  • From the ViewPoint Explorer Recent tab, nothing happened with a right click on a script and right-click on run.
  • Command line parameter to create PC file using IP address not IP name fails to pick up file type.

The following enhancements are included in version 10.13.087:

  • Script views combine the multi-step processing capabilities of standard scripts with the ability to direct results to multiple output options like a view. (requires SEQUEL R10M26)
  • The command line switch of /x was enhanced to reference the /f switch of file type to open a file based on the file type.
  • Performance of script processing from ViewPoint has been improved.
  • New ‘Log Script Commands’ option been added to the ViewPoint Explorer Tools\Logging menu that provides better command logging when scripts are run from ViewPoint.

The following updates are included in version 10.13.007:

  • Charts lose properties when in a dashboard or data refreshed.
  • If changes were made to Label and Legend text for a graph in a dashboard, saving and re-opening the dashboard would corrupt the text.
  • Pie Charts set to display percentages, revert back to numeric values when refreshed or saved and re-run.
  • Active refreshing of dashboard( inserting records, deleting records, or updating records values) caused the chart labels to corrupt, get blanked out, or not appear at all.
  • Charts fail to load if the minimum numbers of elements are not met when first designed.
  • Changing a graph’s Label or Legend text is not getting saved, or when the data is refreshed, the values go back to default values.
  • Hovering over a bar graph does not reflect the correct value.
  • ‘Reprompt All’ on a dashboard failed to perform variable substitution value on the blue data grid title bar.
  • View designer didn’t allow file names greater than 10 characters when created over remote database connection.
  • ViewPoint unstable error returned after cancelling prompt window when designing CRO with Named license.
  • ViewPoint process in memory doesn't end correctly after running a Script.

The following enhancements are included in version 10.13.007:

  • Allow multiple dashboards to open simultaneously—result or design window.
  • ViewPoint report results can be opened directly in Adobe Acrobat (Reader or Pro) as PDF without first running the report or creating a file. This feature is available both from the report designer and from the ViewPoint Explorer. It requires SEQUEL version R10M25.

The following update is included in version 10.12.306:

  • During Dashboard design, CRO doesn’t save with dashboard.

The following updates are included in version 10.12.289:

  • ViewPoint is not properly filling in the GROUP BY clause when using a WDATA (hidden) field in a derived field with another aggregate field.
  • In the View Designer with complex views, the SQL statement is corrupted when the word FROM is part of a column heading.
  • From an Application, a Drill to Option with RUNSCRIPT and unqualified script name does not work.
  • Closing ViewPoint with the results window of a report minimized caused subsequent requests to open with the report results out focus or minimized.
  • A dashboard (containing only action buttons) if first saved as a System I object and then as a PC object, causes the ViewPoint request bar not to close when run.
  • In a dashboard, the X axis values on a graph are being reset to incorrect values after saving.
  • When creating a pie chart, and choosing the option to display the pieces with percentages, the labels change back to values when the short cut or dashboard is saved.

The following updates were included in version 10.12.163:

  • OLESample.xls was updated to run with Excel 2007 and Excel 2010.
  • ViewPoint looped with ‘field was not found’ error when FROM clause had a variable and there was a UNION view with an ORDER BY clause and different field names on each SELECT clause. It became impossible to go back to the Variables tab.
  • ViewPoint install changed to not replace the hostlist.ini file which is used by the ViewPoint Server PC.
  • Install improved to provide a continue installation option when older Graphic Server files are found.
  • When the script variable value contains a single quote like Toys R'Us the following error occurs: CPD0014’A matching apostrophe not found’ and CPD0013’A matching parenthesis not found’.
  • A connection timeout issue during the report design when connected wirelessly. Also, when in a view using the Expression Editor, there are no plus signs to show a list of functions.

The following updates were included in version 10.12.135:

  • ViewPoint version 10.12.096 hangs while installing O2007PIA.msi file in rare instances.

The following updates were included in version 10.12.096:

  • The Header and Footer in format options was not displaying on Print preview or print-out.
  • Copying more than four objects to the same library in the ViewPoint Explorer caused an error when using the tab key on the Copy window.
  • From View Designer, clicking File/Properties resulted in a ViewPoint unstable message when the number of unique keys was greater than the number fields on the ORDER BY clause.
  • Removed the ‘Use this View as a Template’ menu option for remote database views (SQLVIEWM).
  • Dynamic drilldown returned too many records if there was an OR in the WHERE clause.
  • The View Designer, Files & Fields tab corrupted Field Descriptions that contain the | character.
  • Viewpoint F&F file window truncated/corrupted Field Descriptions that contain the | character.
  • View Point installed on a PC or server with no C drive mapped didn’t install merge modules.
  • The Google Map Wizard was added back as an available option.
  • Data Label Values on a graph in a dashboard, round to the tenth position

The following enhancements were added to ViewPoint version 10.12.096:

  • The Excel Add In to allow ‘Display Results in Excel’ option from the ViewPoint Explorer has been added for compatibility with Excel 2010.
  • ViewPoint now shows a message with the total number of records when saving to xlsx on a PC.
  • In ViewPoint Options, a new value of Keep Alive was added to prevent loss of connection to the host when using a wireless and VPN connections.
  • Improved space utilization of data queues, which are used when writing to PC files and Client Tables.
  • In the View Designer, added simple formatting when Disable Syntax Checking is enabled.

The following updates were included in ViewPoint version 10.12.030:

  • The Format Layout button was missing from the ViewPoint options window on Windows 7 with screen DPI set to 120.
  • The Save As dialog window did not appear on Windows 7 with screen DPI set to 120.
  • In a dashboard when the view returned no records, an empty grid was shown instead of the message “No Records”.
  • Received an Unstable error when doing dynamic drill down on a view with variables in the FROM clause.
  • Some host reports would word wrap.
  • Client tables showed a blank screen when the view had more than 32 columns and field names contained symbols (#, $, @, or _ ).
  • Column headings were lost when changed in a view that has formatting.
  • In Script Designer, the Save button was not enabled after a change was made to a line.
  • The Audit Data time was set to zero when the PC language setting was Icelandic.
  • Authority checking of *STRICT was erroneously sending MCH1210 error.

The following enhancements were added to ViewPoint version 10.12.030:

  • The print preview was enhanced to more closely match the actual printed output for view results.
  • From the View Designer, added a setting for Disable Syntax Checking to allow complex SQL statements and syntax on the SQL tab to be edited.

The following updates were included in ViewPoint version 10.11.280:

  • Fields with a Numeric edit code with a floating dollar sign (for example, EDTCDE(1$) ) gave error QRY2301, Identifier '$' preceding ') FROM seq' is used incorrectly. Requires SEQUEL R10M16.
  • Scheduling an e-mail request with Robot/SCHEDULE when the view contained an apostrophe in the description failed.
  • Host Report designer did not recognize column numbers used in the ORDER BY clause in lieu of field names.
  • Host report now uses the job’s CCSID to display the Euro symbol.
  • Fixed the ability to create a shortcut with Re-Directed Desktop.
  • Dashboard Designer did not allow Insert>SEQUEL Object from multiple systems.
  • Close & Reprompt View button was missing when SQLVIEWP was run from the DISPLAY command in a script.
  • Removed the option to build a Client Table over a Host Table.
  • Designing a host report over view with a remote database connection with a 10-character field name on the ORDER BY clause caused error RP7011, Report summary levels are incompatible with query ordering. Requires SEQUEL R10M16.
  • Global variable values were not passing between scripts in ViewPoint
  • The Client Table Wizard is no longer allowed from Host Table Designer.
  • Making a change to an existing PC Dashboard lost the PC authorities on the object.
  • The add database window displayed as full screen but nothing displayed in the window and it could not be resized in Windows 7.
  • Received error CPF2498, Invalid Length when saving a Client Report, with older versions of SEQUEL.

The following enhancements were added to ViewPoint version 10.11.280:

  • Added the command line switch /X to ‘Display results in Excel’.
  • Clarified and updated the message that displays when trying to create a host report over a client table.
  • Added the option for *STRICT to SEQUEL Defaults for Object Authority Checking.

The following updates were included in ViewPoint version 10.11.244:

  • A dashboard with an embedded web page shows errors from the web page.
  • ViewPoint was not properly filling in the GROUP BY clause when using a WDATA (hidden) field in a derived field with another aggregate field.
  • Printing a Host Report from the Designer didn’t show the printer dialog.
  • Opening Properties of a report or table changed the view library from *LIBL to the library of the view.
  • ViewPoint Report Designer no longer adds ORDER ONLY fields as a level break when designing an existing report.
  • View Designer gave parser error over valid statement when using complex MySQL syntax.
  • On 64-bit Windows 7, when the Display Zoom was set to 125%, the Format Layout options from the ViewPoint Options was not visible.
  • Removed PDF Overlay button from the Email and IFS document dialogues.
  • PDF Overlay assigned to an unsaved report was lost once report definition is saved.
  • PDF Overlay settings were lost when doing a Save As on a Host Report that contains PDF Overlay settings.
  • Within the Script Designer, the MONMSG command erroneously qualified the command with the library SEQUEL when the Product Library in the SEQUEL Defaults is set to sequel in lowercase.
  • Unable to add gauge to a new (not saved) dashboard.
  • Dashboard with changes to the Legend, Labels and Title, corrupted the changes, and with refresh went back to default values.
  • Graph did not retain Series Order when set to Column.

The following enhancements were added to ViewPoint version 10.11.244:

  • Added *XLSX to the Email dialogue window.
  • The loading time for the Host Report Designer was improved to handle views with multiple fields faster.
  • The re-position button within view results will be grayed out when the Query Processor has had to create a temporary result.
  • The ViewPoint Email dialogue increased the length of attachment name from 12.

The following updates were included in ViewPoint version 10.11.202:

  • Received Unhandled Exception Error when trying to run a dashboard immediately after closing another dashboard.
  • The Dashboard process would continue to load if you closed the dashboard while it was loading.
  • A dashboard, run from a script, with VPSHELL and variables passed to it (such as SETVAR) did not pass the values.
  • The Host report wizard gave Client Access error CWBNL0107 when the Euro currency symbol was used with a job CCSID of 37.
  • ViewPoint how allows a blank schema name when saving results as a remote database table.
  • A graph legend in a dashboard disappeared after a data refresh.
  • Graphs in a dashboard were not keeping the legend information.
  • Host reports displayed with too much white space and not centered correctly.
  • Exporting a Host report as RTF sometimes caused word wrapping or extra pages.
  • The View designer erroneously gave message QRY2020, File x is not referenced in the JOIN, when the view uses the same file more than once.

The following enhancement was added to SEQUEL ViewPoint version 10.11.202:

  • ViewPoint now always shows multi-record View results even if only one record is returned to allow grid control settings to display.

The following updates were included in version 10.11.179:

  • A dashboard with a runtime prompted view when no records were returned looped with message ‘no records selected’.
  • Command line switch with an object name beginning with U ended in error.
  • In a dashboard, clicking on overlapping data grids to bring to front didn’t work.
  • ViewPoint Administrator failed when running an Audit Query when a PC’s regional settings were set to Icelandic.
  • Running an application in a dashboard that drills to a report, gave an unstable error.
  • Graph showed large values in scientific notation when hovering over the value.

The following enhancement was added to version 10.11.179:

  • Added the ability to change objects defined inside a user space dashboard (SQLDASH) using the Properties windows.

The following updates were included in SEQUEL ViewPoint version 10.11.144:

  • Modified the VALUES list on an INTEGRITY TEST of a NAME type variable so it’s not case sensitive.
  • Host Report in a dashboard didn’t open in the correct location.
  • Having two RUNCMDs in the same script gave a syntax error when run from ViewPoint.
  • A script running other prompted scripts (SQLSCRIPTP) didn’t prompt for secondary script variables. It was incorrectly using the Variable Default.
  • In a dashboard with a gauge, Close and the Re-prompt option were not working correctly.
  • A View in a dashboard stopped refreshing after midnight.
  • Dynamic drill from graph to graph to another graph didn’t work.
  • A prompted view (SQLVIEWP) with DBLIST and Filter shortened the drop down, cutting off data.
  • Improved time to run a calculation when a view, etc. is run from ViewPoint.

The following updates were included in SEQUEL Viewpoint version 10.11.118:

  • Graphics, Text, and Buttons don't affect scrollbars when a dashboard is maximized.
  • The Save As window did not open when saving a CRO as a PC file from ViewPoint Explorer.
  • A variable with a default of SQL(current date) didn’t work for DMY PC regional settings.
  • From an application, Close and Reprompt on a runtime prompted view (SQLVIEWP) didn’t close and gave ‘ViewPoint error’.
  • Drilling from one view to another from a view .vpt shortcut that had a graph, changed the graph with the results of the new view.
  • The AutoPrompt window didn’t accurately show the variable length when a VALUES list was used.
  • A script running another script with variables looped in ViewPoint.
  • The View Template wizard was not handling DISTINCT or multiple files correctly.
  • From a Dashboard, when the same runtime prompted view was used multiple times with saved values, the same saved value was being used.
  • Running some Client Tables multiple times resulted in error ‘Invalid DataSource information.’

The following enhancements were added to version 10.11.118:

  • Added a message to the installer when the wrong version of the graphics server is detected.
  • To optimize performance, view properties are now set to OPTIMIZE(*TOTAL) and ALWCPY(*YES) when saved.

The following updates were included in ViewPoint version 10.11.070:

  • Improved message handling when no records are returned.
  • Dashboard window size did not adjust to current screen resolution and would cause scroll bars to disappear.
  • In a dashboard, when graphics, text, or buttons were located beyond the visible window, the scroll bars would disappear.
  • In a dashboard action button, couldn’t remove extra spaces in the text.
  • In a dashboard, the e-mail prompt window opened behind the main dashboard window.
  • When editing a dashboard, couldn’t resize buttons.
  • Pie charts with percentages for labels reverted to raw values when refreshed.

The following updates were included in ViewPoint version 10.11.046:

  • When a view used server *LOCALSYS and syntax *SEQUEL, a DBLIST Integrity Check using *LIBL for the file name returned no values.
  • Script designer showed error with every key press.
  • The save button was not always available from the Script Designer.
  • Creating a new script showed an hour glass when you moved the cursor over the menu.
  • Closing ViewPoint from the Script Designer left both in memory.
  • Help didn’t display from the Script Designer.
  • From ViewPoint Explorer, right-click on a script didn’t have correct options. “Display Results in Excel” has been removed.
  • Selecting Cancel from the Select SEQUEL Object Window of the Script Designer caused an unstable error.
  • View did not save when its size exceeds 9,800 positions.
  • In Script, variables declared in DCL and value set in CHGVAR did not substitute properly.
  • When a user defaulted “Allow Design” to N, menu choices were not valid.
  • The Dynamic Drill Down options are now tied to the existence of a grouping function on the SELECT clause, not fields on the GROUP BY clause.
  • In a view using server *LOCALSYS, syntax *SEQUEL, WDATA, and grouping functions, an unstable error occurred when using Dynamic Drill options.
  • From the ViewPoint Designer Files & Fields tab, double-byte characters in field description caused ViewPoint to hang.

The following updates were included in ViewPoint version 10.10.343:

  • An application to drill to a RUNSCRIPT command, either implied or explicit, did not work when the script contained a REPORT command with OUTQ(*NONE).
  • An implied link in an Application for drill down did not show an option when drilling to a script when a character variable with quotes was passed.
  • From an Application, implied links only appeared for views (SQLVIEW) and prompted views (SQLVIEWP).
  • Scripts with RUNCMD added an extra space to the variable value in the SETVAR parameter.

The following updates were included in ViewPoint version 10.10.323:

  • The PRINT command errored when using Robot/SCHEDULE from ViewPoint. The PCFMT and CPI parameters were not filled in correctly.
  • DISPLAY from a script called from another script did not show results.
  • The Font dialogue window from Report results was improved to reflect only available options.
  • The View Designer gave error “An error occurred while trying to load the view” when going to the Files & Fields tab on very fast PCs.
  • The View Designer truncated files longer than 10 positions with non-SEQUEL servers and SYNTAX(*SEQUEL).
  • Scripts erroneously produced error “SEQUEL Design has stopped working” when a script completed normally with Windows 7.
  • Using ViewPoint as an ADO provider failed with a VB error when running a script.
  • Script with RUNCMD gave error CPD0018, "String _&REGON contains a character.”
  • ‘”Display Result in Excel” option disappeared after running multiple times.
  • Script with DATE variable and *ALL was not correctly passing *ALL or *OMIT.
  • Using RUNRMTCMD with the /Z switch was no longer creating a log on the ViewPoint Server PC.
  • The "Processing" window stayed visible if a second instance of ViewPoint was open.

The following enhancements were added to ViewPoint version 10.10.323:

  • Improved error handling for jobs scheduled through the IBM Job Scheduler when the command string surpasses 512 characters.
  • Added a new ViewPoint option to disable the Excel plug-in.

The following updates were included in ViewPoint version 10.10.245:

  • When a ViewPoint request was scheduled to run from a .bat file, the user-based license was not released when the scheduled job completed.
  • Saving results as PC file didn’t always work if an extension wasn’t specified in the format description or file name.
  • Scripts running from ViewPoint were not properly substituting variables in RUNCMD, DOWHILE, and COND statements.
  • If a script used an ampersand (&) in the value of a SETVAR, it caused the script to hang.
  • Using the backspace key to blank out the default value of a QSTRING variable from the AutoPrompt window caused an unstable error.
  • Selecting File>New> Host table using SQLVIEWM with specific database and SYNTAX(*SERVER) gave error CEE9901 in TBLC05.

The following updates were included in ViewPoint version 10.10.230:

  • Opening Client Report (CRO), Host Report, Host Table, and Client Tables using Embedded SQL statements gave parser errors.
  • When a custom PC file format was created with WRKPCFMT and the text began with a pipe (|), the ViewPoint File>Save As>PC File option did not show any PC formats.

The following updates were included in ViewPoint version 10.10.211:

  • Dashboards with black backgrounds now are saved correctly.
  • A script running a DISPLAY command using SETVAR now returns to the AutoPrompt when no records are selected.
  • If user uses the delete key for a Variable value in a Prompt window, ViewPoint now passes a space character instead of passing the default value.
  • Spooled file output saved as RTF is no longer centered; the margins were too big and caused lines to wrap.
  • Eliminated the duplicated *OMIT value on the drop-down prompt list.
  • With Client Access V6R1, the host signon window sometimes hid behind other windows or flickered madly.
  • Fixed the incorrectly sized text entry box for long script lines (double-click to enable).
  • Script step mode was not working due to issues with blank lines, tags, or comments.
  • A tab character within a script command could cause all or part of the command to turn into hex notation.
  • Selecting drill-down option regroup or details caused the ViewPoint unstable error, System.NullReferenceException.
  • Couldn’t turn on logging from the Explorer menu after ViewPoint was running.
  • The new Client Report wizard failed to release a CRO license when cancelled.

The following updates were included in ViewPoint version 10.10.175:

  • The Auto Prompt window on a runtime prompted view with DBLIST Integrity Test did not show drop down arrows when there were many prompts.
  • ViewPoint Administrator host jobs would hang with job log pending when closing the Administrator.
  • Selecting Tools>Logging>Display system i job summary>File>Email generated a ViewPoint unstable message.
  • The Files & Fields tab in ViewPoint 10 View Designer wasn’t resolving unqualified files when using SERVER(*LOCALSYS) SYNTAX(*SEQUEL).
  • ViewPoint was only creating SQL with lowercase names when using a remote database and *SEQUEL syntax, like server(ablecorp2005) syntax(*sequel). Added code to test for remote databases where case matters.
  • ViewPoint gave error -2147213281, Invalid column key for views/tables, when two columns have the same heading.
  • A runtime prompted view (SQLVIEWP) with an Integrity Test of NOT VALUES gave Unstable error.
  • In a Dashboard, an Action button to run script returned view results twice.
  • The option to minimize the status bar in ViewPoint 10 was missing.
  • RUNAPP in a script produced no results when qualified with a library name.
  • Font settings were not consistent in the Script designer.

The following enhancements were added to ViewPoint version 10.10.175:

  • Temporary files created in c:\Documents and Settings\username\Local Settings\Temp folder when exporting a Client Report (CRO) will be deleted.
  • Allow printing of a dashboard definition from ViewPoint properties window.

The following updates were included in ViewPoint version 10.10.123:

  • Reconciled different ADO references related to a number of issues with the designer.
  • The shortcut to e-mail Client Report Option results with a bcc value resulted in the following message: “Delivery has failed to these recipients or distribution lists.”
  • The shortcut now supports semicolon and comma delimiters for e-mail addresses.
  • The e-mail option from a shortcut (.vpt) to display Client Report Option results failed with error.
  • The screen font in the script editor changed depending on object opened.
  • DBLIST with filter using a variable gave error ‘Value x is invalid’ was fixed, and support was added for a variable in a COMP Integrity Test.
  • In the Script Designer, the Save option didn’t work after a change on the Variables tab.
  • Upgraded the installer to install Client Report Option XIR2SP6 support files (this fixes a problem with chart labels/legends).
  • Excel: received an error in ViewPoint when running a prompted view from Excel.
  • Removed the MIN function from the Host Table Expression Editor as it is not supported.
  • In dashboards, Client Reports were overlapping.
  • Non-English PCs sometimes failed to use the proper signon method. A previous workaround was creating a new registry key.
  • Restored functionality to the Client Report Option (CRO) to print to the default printer of the PC.
  • CRO reports now observe the /i switch to control the printer name when run from a shortcut, RUNRMTCMD, or VPSHELL.

Sequel Web Interface (top)

Currently Shipping Version: R10M24

The following updates are included in this version:

  • From Repository a .vptreport shortcut doing Save Results> Repo File>RTF creates corrupt file.
  • The presence of a slash ( \ ) at the end of any object description text prevents a list of objects including that view from being displayed.
  • Client Reports (SQLRPTC) and Client Tables (SQLTBLC) with a variable using a DBLIST with check(multi) did not properly quote the string.
  • Script View with a DBLIST, multi-select prompt variable not passing variable string correctly.
  • When the Dynamic Drill Down List file (SEQUEL/VPTDYNFLTR) contains a list of fields, only those fields are available for dynamic drilldown. If the file contains fields, but no fields that exist in the files that a grouping view references, then the option to view the complete list should appear in SWI, as it does in ViewPoint and SWS.
  • Reprompt of variable with DBLIST gave error.

The following updates are included in this version R10M23:

  • I/O Error. Broken Pipe when using remote database connection from SWI in some instances.
  • From a SWI connection, Email sent to a Distribution list is only sent to the first 2 recipients in the list.
  • Using SWI, Right click a CRO report or Display and then Click Download > RTF will now work.
  • When running Dynamic Drill Down ( Regroup / Show Details) on a view with SERVER(*LOCALSYS) SYNTAX(*SEQUEL) in SWI you get CPD4306 ‘field is not unique’ if picking a field name that is found in multiple files.
  • When using Regroup with a SWI connection, the HAVING clause should be removed but should remain when using Show Details.
  • Running a prompted view/report/table in SWI fails if prompt value has an apostrophe in it.
  • Within the repository additional shortcut types were created to distinguish between a Host Report (.vptreporth) and a Client Report (.vptreport), and Host Tables (.vpttableh) and Client Tables (.vpttablec), and Script (.vptscript) and Script Views (.vptscriptv).
  • Using a SWS connection to run a Client Table built over a ViewPoint Universal Driver connection (JDE or *ADS) is now supported.
  • In a SWS and SWI connection, download and email of a Client Report (CRO) now supported.
  • JD Edwards World A9.2 users unable to log in to SEQUEL Web Server, received error ‘Your connection has been expired. Please retry your action.’
  • JD Edwards World A9.3 users unable to log in to SEQUEL Web Server if only 1 Environment assigned to user.
  • SWS will now require ADMIN credentials to change host configurations.
  • Basic users cannot connect with SWI due to authorization to running the CHGCURLIB command
  • Prompt Variables with default values that include decimal amounts are rounded, and do not display the actual value saved with the view.
  • Drill Down Application with a hash symbol (#) in title of object, did not run.
  • From the SWI Explorer displaying of all results, including unbuffered like script views, will honor date sorting when the date style is MDY or DMY or USA or EUR.
  • From a dashboard, Reprompt All button does not display if the last variable has prompt text of *NOPROMPT.
  • When a variable is used for a multi-select DBLIST, the length of the variable will be honored so an unlimited number of values cannot be entered.

Charting:

  • On a bar chart, x-axis labels are now supported to show values under the bar.
  • On a chart with many points, x axis lables can be set to show every nth value. When saved on a dashboard, this attribute is not retained.
  • Charts built over views with sub-totals in the results should not graph subtotals.
  • Bar Chart exported from display to PC file did not render correctly.
  • Right titles are now supported.

The following enhancements are included in version R10M23:

  • Using a SWS connection, a variable with a Database List will now be supported for remote database views.
  • The repository now supports dashboard objects as .vptdash objects.

The following updates are included in version R10M22:

  • View Subtotals are missing in SWS when Save to Repository is used.
  • SEQUEL Application from SWI or SWS, drill down causes a prompt screen to appear instead of automatically passing the required data to the "drill to" view with NAME or EXPR type variables.
  • When running an Application from SWI or SWS, the text above the Drill down results was coming from the description text defined in the View Definition.
  • Now the title uses the text defined on the Option File entry on the Drill down results.
  • Views with DB list prompt variables that display a value from one field, but pass a value from a different field to the view intermittently pass the description field instead of the value field to the view only on re-prompt.
  • When a dashboard is run from SWI or SWS, the order of the prompt variables appear in no particular order. This is most noticeable when the there are several sequential variables.
  • Using SWS, when a dashboard that has a DBList(s) is launched, the DBList(s) will only show the default value.
  • From SWS, running a Host Table (SQLTBLV) to Save Results/Download/PC file when no records were selected did not send message.
  • Variable with Values List with double quoted values does not pass integrity check when run in SWI.
  • For SWI and SWS, using Right click/Save Results/Download to a PC file on a Host Table that returned no records did not produce a PDF file with the No Records Returned message.
  • Emailing results from a SQLRPTC (CRO) file in SWS sends file with temporary name.
  • Running a view in SWI/SWS, and highlighting some values in a column to see the Total at the bottom right, if there are any negative values highlighted, they are not included in the Total, and they are treated as zero.
  • In a Client Table, a calculation that is based on other calculated columns could show incorrect results in SWS.
  • SWS shows no implied drill option based on options in file with like variable names.
  • When a Client Table with column totals suppressed via Format>Layout> Then Click each of the 'Row' fields and uncheck show footer, is displayed in SWS, the column totals were still visible and in fact are the only level to show initially.
  • From SWS, a Client Table that was designed to have fields with the " visible " box unchecked in Format>Layout>Fields tab so that the field isn't displayed in the results, but the field is available to be used in other calculated fields, was displayed.
  • Client Report should have option for xls when downloading to a pc file.
  • From SWS running a .vptview from the repository and using Dynamic Drill Down options of Regroup or Drill Down gives error ‘object in QRECOVERY not found’.

Dashboards

  • Single quotes in Action Button Text display as 2 single quotes.
  • A chart with an apostrophe in the Title will not display in SWI/SWS.
  • Embedded Excel spreadsheet did not open if using Excel 2013.
  • Made chart titles consistent between SWS and ViewPoint. For instance, in SWS the chart title is {‘Total A/R’ by ‘Sales Region’} but ViewPoint used {Total A/R by Sales Region}.
  • Added support to keep legend on the left side is that’s how it was created in ViewPoint.
  • Bottom legend customized to show every other or every third in VP does not translate to SWI/SWS - all legend info is shown.
  • Trends "Limit lines" and "mean/avg lines" are missing in Line charts
  • Edited – customer legend (labels) not visible.
  • Chart colors changed to match ViewPoint more closely.
  • Line graphs improved to:
    • Show line and not small circles
    • The range defined in the graph is not used - instead it uses a default range (0 - 100) and, depending on the data, can render the graph useless.
    • When a line is displayed, it is too pale, and should be more prominent as in ViewPoint.
  • The graph window title bar is missing in SWS
  • Gauges are showing different value ranges between VP and SWI; range steps are no longer in specified increments.

The following enhancements are included in version R10M22:

  • Properties of a view can be restricted by user.
  • Support for prompting of JDE Environment and Role when using the ViewPoint Universal Driver (JDE Driver) and running views and reports from SEQUEL Web Server.
  • SWIOPEN COLSET parameter length increased from 315 to 512 positons to accommodate longer URL strings being passed.
  • Apache version upgraded to 2.2.29.
  • Implement local variables for Skybot to avoid collision errors when we have several jobs that want to use a variable named &CUSTID for example. With private Skybot variables we could set the CUSTID variable for every job and avoid these collisions. This would also simplify our current prompting scheme, and allow for cleaner web service URLs and variable names.
  • In SWS, limitation of 800 for variables using a DBLIST was removed.
  • SWI/SWS increased email address book drop-down to more than 1500 entries.
  • A Drill Down application that uses an option file where some runtime variables are set to hard coded values fails to pass any values when run in SWI and SWS.
  • SWI/SWS fails to process command in Drill Down options when the command is qualified with a library name.

The following updates are included in version R10M21:

  • User defined title in graph from dashboard not used.
  • Dashboards run with zero values for the speedometer or thermometer values were not displayed.
  • From a dashboard, line graphs were rendered with the wrong series order.
  • Dynamic Drill Down (drill from a GROUP BY view) does not honor 'Dynamic Drill Down List' defined in the ViewPoint Administrator.
  • Dashboard overlaps when using Zooming in or out from Internet Explorer and Firefox.
  • From SWS a value with an apostrophe passed to a prompted view would cause the request to fail.
  • Action buttons from a dashboard did not work when DSPNETA had a different name than the system defined in in SWS.
  • Digital graph not rendering number represent time (HH:MM or HH:MM:SS) with an edit mask correctly.
  • SWI/SWS hangs when rending a gauge created with a blank custom mask.
  • On a dashboard, a text box that contains a single quotes displayed as two single quotes.
  • From a host tables the Download to a PC file in PDF option, both save and open, rendered message that the file could not be opened.
  • From SWS, a SQLIVEWM (with SERVER other than SEQUEL) did not show sub-totals if they were saved with the view.
  • In a dashboard, a radial gauge had the maximum value ignored and the actual gauged cell value became the maximum and the gauge displays maxed out.
  • In a dashboard, and Action Button running a command string for a prompted view with SETVAR should not prompt.
  • Client Tables from SWS with calculated fields without a specific derived field name will not longer end in a ‘Mondrian Error:Internal error’.
  • User based license was not released when view is reprompted and run again from Auto-Prompt window.
  • Multiple fixes for passing prompted values with quotes.
  • Dashboard bar chart not using column/series order the same way as ViewPoint when user changed graph defaults.
  • Skybot Integration:
    • When creating a Skybot job around a Client Report object, the drop down menu for the extension of the output file needs to allow for XLS files.
    • The output location of Skybot jobs in SWS should allow writing to UNC paths outside of the REPOSITORY.
    • Skybot settings button no longer visible when using unsecure URL.
  • Repository:
    • Expanding the repository and drilling into multiple levels of folders, then creating a job, returns you to the high level repository folder.

The following enhancements are included in this version:

  • File type xlsx added to the Save Results\Download to PC\Export to Excel option.
  • Creating a job from a view or a vptview the Output File parameter now has a type of HTML in the drop down.
  • Improved Navigation Pane that is completely collapsible.
  • Additional options added to ViewPoint Administrator for SWI Functions List control.

The following updates are included in version R10M20:

  • On a grouping view chart, if you right click on a chart element, you do not get the Regroup/Show Details options using Internet Explorer.
  • The display spooled file by output queue function fails when the list contains a spooled file in OPN status with no data yet written to the spool file.
  • Better message on the Delete option of an object.
  • Client Table with DATE variable when run from SWS ends in error.
  • Union view with a DBLIST run from SWI fails to build filter list.
  • Variable with a DBLIST and a Filter does not activate the OK button when a value is chosen when run from SWI.
  • Pie chart created over a single row of data produces incorrect Legend values.
  • Entering in multiple character values for a variable in an IN test only returns records for the first value when using *LOCALSYS.
  • Dashboard with a horizontal gauge will not display.
  • Right click on a summary level chart does not give the options to Regroup or Show Details.
  • Script view that processes more than 100 records will create a lock on the files and prevent scrolling past 100 records.
  • DBLIST multiselect with Default of *OMIT, cannot uncheck the default, which also prevents you from making selections.
  • In Right click/Properties, some character combinations are getting translated incorrectly. For instance, &regon is being translated to @ON.
  • *LOCALSYS view with an Edit Word for a trailing % causes JSON error in SWI.
  • SWS gives error running any view on a French (qccsid 297) or German (qccsid 1141).
  • When the first view in an application is a prompted view, SWI fails to use the drill down file associated with the application.
  • In both SWS and SWI, when ctrl + has enlarged font size, running some queries results in half empty page results.
  • Running a view with a number type variable cannot pass a zero value unless the default value is set to 0 in the variable definition.
  • SWS not using default option file member in Classic mode.
  • SWI and SWS jobs not pulling default variable value for *USER only when running CRO or Client Tables.
  • Dashboards not always rendering Excel spreadsheets in IE.
  • Blanks are stripped from variable when variable uses a multi-select.
  • Running a view in Classic mode (from a URL string) with a *NOPROMPT text value and databind=A, did not pass variables correctly.

The following updates are included in version R10M18:

  • In Classic mode, action buttons (in a dashboard) with long text strings that wrap to multiple lines, truncate the text.
  • The dynamic drill down Show Details option from a grouping view gave an error in rare instances dependent on the data.
  • Views using DBLIST with a multi-select and a Default Value of *ALL render the *ALL as grayed out and a blank is passed instead of *ALL.
  • Based on certain and rare PC Browser versions and network configurations, items are being cached and causing the process of serving SEQUEL objects as an empty window.
  • The host job and SEQUEL license remain active (with files open) for views that return more than 100 records, and a scenario where one does not scroll to the end of the data, and instead of closing the view display tab, the entire browser is closed completely.
  • CRO reports in SWI are rendered as HTML pages and not PDF documents as configured in SWIVPDFT.
  • A dashboard containing a SEQUEL Application (SQLAPP) with a related chart shows a blank chart when run in SWI.
  • Dashboard with prompted view designed to save the value and not prompt, still prompts in SWI.
  • Dashboard with single maximized graph will not display in SWI.
  • Dashboard containing an Application designed over host tables with gauges, cause the gauges to display as empty.

The following enhancements are included in version R10M18:

  • Type a value in a DBLIST prompt box positions you to a value in the list.
  • Email drop-down lists allows for multiple selections creates a semicolon-separated list with the selected values.
  • SEQUEL views and graph objects in dashboards designed to hide borders and menus are supported in SWI.

The following updates are included in version R10M17:

  • In some instances an initial request to use SERVER(*LOCALSYS), caused subsequent requests to result in a spinning loading screen or a completely white screen.
  • From SWI Explorer, running an Application that uses a summarized view (GROUP BY), the Dynamic Drill Down options caused syntax errors
  • Using a DBLIST with a filter corrupted the first *OMIT value from the list.

The following updates are included in version R10M16:

  • Right Click Regroup/Show Details is not working on some specific views when created over files with hundreds of fields. Received error 'f.drillDownFields.from.length' is null or not an object.
  • From the Explorer, a Dashboard with AutoRun button hangs waiting to display other view results.
  • Prompting Issues Fixed:
    1. From Classic with databind=A and a variable with a DBLIST with default value cause the re-prompt options to displays outside the window.
    2. Variables with a Default Value using VIEW or SQL were not working.
    3. From Classic with databind=A the drop down list failed to populate when the DBLIST field value contained a single quote.
    4. When running a prompted view from SWI, if the prompt field has an integrity test of CHECK(UC) , blanks cannot be entered (within other characters).
    5. Variable using DBLIST with a hard coded filter on a character field does not parse properly in SWI.
  • Choosing Properties on a Script View in SWI produces an error window
  • Numeric fields with leading negative signs also including the commas, when displayed any values starting in the 3rd or 6th position with a leading comma (-,543.21)
  • It appears that due to browser caching, running dashborads with gauges more than once causes the gauges to not load at all.
  • From a Dashboard a Horizontal Bar graph (in ViewPoint) displays Vertically when run in SWI.
  • Views in a Dashboard set to auto refresh, stop refreshing if no records are returned.
  • Changes to gauges and text boxes on Dashboards to bring them more in line with appearance from ViewPoint.

The following enhancement is included in version R10M16:

  • The view/report/table description will show when the cursor hovers over the tab.

The following updates are included in version R10M15:

  • Running host report, Client Report, host table, or Client Table over a runtime prompted views gives QRY2101 ‘VIEWNAME in library xyz is not a Sequel view object’.
  • Dynamic Drill Down options of Show Details or Regroup give error SCRIPT5007’ Unable to get value of the property 'length': object is null or undefined’ when the file(s) from the view contain many files with six hundred or more fields.

The following update is included in version R10M14:

  • *STRICT authority was not enforced for Reports, Client Reports, and Client Tables.

The following updates are included in version R10M13:

  • When the job’s decimal format (DECFMT) is I or J, a list of comma separated values on a SETVAR parameter requires a space after the comma.
  • A variable defined in a Script with the default value to *OMIT and *OMIT as a Special Value, prevented the prompt window of being input capable.
  • Re-prompting a graph from a dashboard when fewer records are returned from the initial request fails to load the graph.

The following enhancement is included in version R10M13:

  • Authorization code support added for Live Partition Mobility.

The following updates are included in version R10M12:

  • Integrity Test of variable of not equal (<>) to blank was not working.
  • Integrity Test of DBLIST should sort values based on the Description field if one is specified.
  • In the Classic interface, a DATE variable with a Default Value of *ALL shows as blank in the prompt window and caused an ‘unexpected error’.
  • Date Type variables do not support *ALL or *OMIT when run from Explorer interface.
  • Default value of a variable that is a hard coded value using DBLIST and Multi-Select does not show value when prompted.
  • Variables using a DBLIST with a filter based on another variable now produce the proper drop down list values.
  • When SWIVPDFT has Output Type set to PDF, the email option from the results of CRO report is not visible from IE.
  • Drill Down from an Option File record gives CPD0078 ‘Value “ “ for parameter OBJ name not valid’ from Explorer interface and shows a list of the SEQUEL objects when run from Classic interface.
  • Refresh All on Dashboard does not update variable value in data grid title.
  • Dynamic Drill Down from chart or graph must include drill as label.
  • From Explorer interface using IE and OUTPUT type SWIVPDFT is set to *PDF, switching tabs from the output of a Client Reports and Client Tables corrupts the display.
  • In an Application, if the initial object is a prompted object, you cannot email results from that tab. No error message is produced, and no email is received.
  • The Explorer interface when viewed from an iPad truncates object names.
  • Download option from the Explorer interface does not reveal secondary menu of options such has text or pdf.
  • From the display of a Client Report when the Output Type of SWIVPDFT is *PDF, the Download and Properties options did not work.

The following enhancements are included in this version:

  • Support for DBLIST Integrity Test on a variable with a filter dependent on another variable was added to the Explorer interface.
  • Support for bring to front functionality in dashboards was added.

The following fixes are included in version R10M11:

  • Dynamic Drill Down (Regroup and Show Details) returned the wrong records when the join type was something other than INNER.
  • SWI Explorer sets the Apache server job with the default library list if the list is specified in the User Preferences Library List. The library list returns to the original at the end of each call to the host.
  • From SWI with a job with an Italian CCSID, the email request ended in error EML0069 ‘Recipient is invalid’ because the @ sign was not translated correctly.

The following update was included in version R10M10:

  • The product defaults have been enhanced to include a new value, HTML Base Timeout, that controls the number of seconds the browser will wait for requests to complete in the Explorer interface.

The following updates were included in SWI version R10M09:

  • The RUNRMTCMD used to run Client Tables and Client Reports from SWI failed when VPSERVER name had a dash ( - ).
  • When sorting columns over large SQL statements, could receive error CPD0074 Value 'SELECT ....'for MSG exceeds 3000 characters.
  • When working in Classic SWI, bringing up a list of spooled files where there is a spooled file over 9999 pages, created an error on the screen: 'An Unexpected Error has Occurred'

The following enhancement was added to SWI version R10M09:

  • The ESEND Address Book has been integrated into the SWI Explorer so e-mail addresses can be selected from a drop down menu.

The following updates were included in SWI version R10M08:

  • Emailing from the SEQUEL Web Interface Explorer resulted in an error when SWIVPDFT specifies a path other than //server/tmp for the target path.
  • Added validation in SWIXSLBLD to signal missing information.

The following enhancement was added to SWI version R10M08:

  • Graphics used in dashboards can be stored and accessed in the same location whether running from SWI or ViewPoint.

The following updates were included in SWI version R10M07:

  • From the SWI Explorer, added a Print Results option to allow scripts to print multiple view results in one document. Requires SEQUEL R10M17.
  • From the Classic interface with databind=A, sorting view results lost some rows (in rare instances).
  • From the SWI Explorer, Re-prompt on a remote database date prompt view changed the date format so no data was returned. Date prompts on remote database views will always use ISO format. Requires SEQUEL R10M17.
  • Dynamic Drill Down failed when SELECT fields qualified.
  • Dynamic Drill Down returned no records when server is SQL Server.
  • A dashboard run from the Classic interface with databind=N opened blank.
  • Customized Footers were not displaying from the Classic interface.
  • A character field containing embedded double quote caused a decode error.

The following enhancement was added to SWI version R10M07:

  • The Classic interface now supports Dynamic Drill Down.

The following updates were included in SWI version R10M06:

  • An e-mail request with a recipient address with a hyphen caused error CPF0104, Expression not allowed for parameter RECIPIENT.
  • When SWISETDFT Directory Listing Access was set to SELECTIVE and a wildcard (such as SEQU*) was used for the library name, the objects from the library were listed on the left-hand pane as if they were libraries.
  • When SWISETDFT Directory Listing Access was set to STRICT, dynamic drill down gave error, View QTEMP/xxx Directory Access not allowed.
  • A user exit program run via SWISTART changed the server job library list based on the JOBD selected by the current user. If the resulting library list excluded QTEMP, the SWI request failed and gave errors CPF1023, Data area SWIINIT exists in QTEMP, and C2M1601, Signal SIGABRT raised (abnormal termination).
  • SWVER gave error RNX0100, length or start position is out of range for the string operation, when the company name was between 38 and 40 positions.
  • In some instances, Host Reports on a Dashboard from SWI failed to appear and gave error, Default object.run in seq.data.Object.

The following enhancement was added to version R10M06:

  • The configuration process run during install will not change the library list of the QZHBHTTP *JOBD if SEQUEL, SEQUEL Web Interface, and ESEND exist in the system library list.

The following updates were included in SWI version R10M05:

  • From Classic SWI, running a Client Table or Client Report displayed in HTTP even though the call was from HTTPS (secure http).
  • Re-sorting on a field with a 10-position field name caused an Unexpected error.
  • Changed the TOSTMF parameter of the EXECUTE command so a string beginning with // is not assumed to be a remote database connection.

The following enhancements were added to version R10M05:

  • SWI now always shows the job name/user/number when an error occurs.
  • Firebug logging is now available when the SWI Explorer runs from sequel/web/debug.html.

The following updates were included in SEQUEL Web Interface version R10M04:

  • Using Dynamic Drill Down from second-level to third-level gave QRY2303 error.
  • Reprompt option from View results of a runtime prompted view gave an unexpected error.
  • Prompt screen with numeric variable did not accept *ALL or *OMIT as a value.
  • A SEQUEL Web Interface permanent code was entered without error, but some users still received a product authorization error at the browser.
  • From a dashboard, selecting Refresh All caused an unexpected error.

The following enhancement was added to version R10M04:

  • Improved performance when compiling object lists in the SEQUEL Web Interface Explorer.

The following updates were included in SEQUEL Web Interface version R10M03:

  • A table (SQLTBLV) that produced more than 100 rows gave error TBL7112.
  • Column Sorting was not sorting with more than 100 records.
  • Variable with # in its name caused an unexpected error when saving to a PC file.
  • Email option should restrict message text to a maximum of 1000 characters.
  • Variable with a DBLIST Integrity Test using a filter did not show values in the drop down list.
  • When a runtime prompted view in a dashboard returned more than 100 records, the SWI Explorer would hang.
  • Files used in a view run within a dashboard were not released.

The following enhancement was added to version R10M03:

  • Added support for Excel .xlsx and .xmlxsl formats.

The following updates were included in SEQUEL Web Interface version R10M02:

  • *OMIT and *ALL were not showing as available options in a DBLIST drop down.
  • When the starting view of an application is a remote database view with a date prompt, the date prompt was not in *ISO format.
  • A remote database view with a DATE prompt used in a Dashboard prompted in *USA format, not *ISO, so no records are selected.
  • Returning a large number of rows, then closing the tab didn’t release a user-based license.
  • When the starting objects of an application was a host table (SQLTBLV) built over a runtime prompted view (SQLVIEWP or SQLVIEWMP), it did not prompt correctly.
  • From the SWI Explorer, using a runtime prompted view to create a physical file or a remote database table returned an error that the request failed even though the file was created.
  • From the SEQUEL Web Interface, Download View results to Excel showed numbers as negative, blank, or a box the first time it was downloaded (also requires SEQUEL R10M12).
  • When using the Dynamic Drill Down Show Detail, not all fields were included in the drill down result set.
  • About Window showed date, not RelMod for the SWI version
  • When a library or object name contained a # character, the name was truncated.
  • E-mailing a prompted report gave error CPD0043, Keyword TEXT not valid for this command.
  • Charts over views where the first column was numeric skipped columns and corrupted the legend.
  • Corrected an override problem with RPG III TIME opcode.

The following enhancements were added to version R10M02:

  • When displaying views outside the Explorer: from Classic, a direct link, or a dashboard, and when databind=A, the view name was not included in the results.
  • Added STRICT setting for directory browsing that restricts the list of available objects and running objects from a restricted library using a URL.
  • Increased the time offset processing accuracy to milliseconds to solve a problem working with and selecting spooled files.

The following updates were included in SEQUEL Web Interface version R10M01:

  • The Dynamic Drill Down Regrouping option over a view with a DBLIST multi-select Integrity Test caused error CPF4278, Query definition template 1 not valid.
  • Save Results to Download to an XML caused error, The MCL page cannot be displayed.
  • .vpt files that are shortcuts did not run from the previous interface.
  • Date prompts for Remote Database Views (SQLVIEWM) are now ISO.
  • Running a Client Table that used a runtime prompted view gave an error and redisplayed the prompt.
  • The e-mail option did not work when using databind=A from the previous interface.
  • From the previous SWI interface, Applications with Explicit drill downs didn’t work after a first-level run when the SWI defaults were not set to A.
  • When the variable in the view was defined as less than 5, *OMIT was not accepted.
  • Client Reports and Client Tables didn’t print when a SWI instance was running on a port other than 80.
  • A dashboard using a runtime prompted view (SQLVIEWP) did not show the default value of variable on the AutoPrompt window.

The following enhancements were added to SEQUEL Web Interface version R10M01:

  • Applications can run with a Host Table as the starting object.
  • Applications can run when the starting view has runtime variables.
  • When running CRO reports, the path in the VPSWIDFT defaults now allows a reference to \root. Thus, \\system\root\tmp works the same as \\system\tmp.
  • Added support for non-English PCs.

The following update was included in SEQUEL Web Interface version R05M13:

  • The scroll bar was missing when displaying Query/400 results.

The following updates were included in SEQUEL Web Interface version R05M12:

  • The drill-down option to run a script did not work from an application.
  • When an Action button from a dashboard referred to a path longer than 32 characters, the error CPF9801, Object not found in library, occurred.

The following updates were included in SEQUEL Web Interface version R05M11:

  • Running a Viewpoint request from the SEQUEL Web Interface with spaces in the path or object names caused the error, No ViewPoint object match request.
  • Improved message handling of CPF1023, Data area SWIINIT exists in QTEMP, when QTEMP is not on the library list of the Apache job.
  • On the AutoPrompt window for runtime prompts, lengthy extended help text was truncated from the browser.
  • A script with DBLIST, *ALL, and view for DBLIST did not correctly pass *ALL when run from the browser.

SEQUEL Web Interface version R05M10 included changes that were internal to the product.

The following updates were included in SEQUEL Web Interface version R05M09:

  • SEQUEL Dashboards were not showing data when the tag group has an embedded ending font tag but not a beginning tag.
  • In a Dashboard, a Chart failed to show when data was hidden and Databind=A.
  • When displaying a multi-page spooled file from the SEQUEL Web Interface, there was no scroll bar.

The following update was included in SEQUEL Web Interface version R05M08:

  • Remote database views using a local view for DBLIST failed. Error handling for DBLIST views has been improved.

Esend (top)

Currently Shipping Version: R03M52:

The following updates are included in this version:

  • Adjust email header to add appropriate white space like:
    To: "Recipient Name" <recipient email address>
  • Execute or ESNDFILE with recipient list longer than 1000 characters fails with EML0069 ‘Recipient is not valid’. Limit increased to 2000 positions.
  • The distribution rules (ERPTRULES) will ensure that when the email is the same address, just a different case, the email is sent only once.

The following updates are included in version R03M50:

  • WRKSPLFE should work like WRKSPLF with respect to running option 2 CHGSPLFA and prompting.
  • FTP Server entry now allows you to change the sub functions of EPASV and EPORT in FTP.
  • Using WRKSPLFE option K for CPYtoOUTQ has improved performance.
  • The process for handling reply list entries to messages has been changed to remove the use of RMVRPYLE and ADDRPYLE.

The following updates are included in version R03M49:

The following updates are included in version R03M48:

  • Spooled files sent to multiple recipients using a unique distribution rule are not legible.

The following updates are included in version R03M47:

  • EDISTRIB with a *EM test to use email address from a specific position is no longer sending PDF output.
  • An email sent as type *html by EDISTRIB does not have links and tags rendered as proper hyperlinks.

The following updates are included in version R03M45:

  • Changes have been made to improve the ESEND process to support users who override print file output so that ownership is set to the current job rather than QPRTJOB.
  • Resolved issue where emails were not being sent if a spooled file attachment was open elsewhere.
  • Issue resolved where ESEND was unable to send results via secure ftp from V7R1 machine.
  • Error MCH0603 generated when sending last spool file from a job with over 10000 spool files.
  • Added retry loop in PDFSPLFC for EML0023 erroe due to spool file not ready.

The following enhancement in version R03M45:

  • Change added that allows you to decide whether or not to send a message when invalid recipients are detected. Processing is controlled by the existence of a data area named ESNDNOML in any library in the jobs library list.

The following updates are included in version R03M43:

  • Distribution Rule (EDISTRIB) to create file on IFS created empty file when file name was more than 30 positions.

The following enhancements are included in version R03M43:

  • Email will be sent if at least one recipient is valid, even if others are not.
  • Allow a distribution rule to copy one spooled file to many output queues.

The following updates are included in version R03M42:

  • Accessing the Maintain Address Book option with more than 1,000 entries, produces the error CPF5021 - ‘Incorrect relative record number or field selection’ and RNX1255 - ‘Session or device error occurred in file ESNDDSTD’.
  • Unable to display QZMF journal entries after ESEND extracts them to a file. DSPESNDLOG on the extracted file gives CPF2962 - ‘FMTOPT(*MAP) or FMTOPT(*NOCHK) required for copy’ and CPF2817 - ‘Copy command ended because of error’.
  • RTF output created from a SEQUEL Host Report makes some report lines appear to be intended as format control input that should not be seen. This problem was introduced in R03M39.
  • Distribution rule (EDISTRIB) was not substituting for lower case variables names.

The following update is included in version R03M40:

  • Update of ESEND resulted in loss of EFTPSECP data used for secure FTP.

The following enhancement is included in version R03M40:

  • Authorization code support added for Live Partition Mobility.

The following update is included in version R03M39:

  • When emailing a SEQUEL host report emailed in RTF format, any fields that contains a slash (\) will truncate characters after the slash.

The following updates are included in version R03M38:

  • When a new user, who does not have the User Default Data area in either SEQUEL or ESEND and they run a SEQUEL command to send results in an email, they get CPF4102 ‘File ESNDPF in library *LIBL with member user name not found’.
  • EDISTRIB with a spooled file where every page meets the selection condition of a distribution rule is being skipped with ‘No pages were found matching the criteria to be sent to’.
  • Spooled files in a pending status (*PND) were either skipped or gave an MCH1210 ‘Receiver value too small to hold result’ error.
  • Work with Spooled Files for ESEND (WRKSPLFE) was not checking Group Profile for additional Special Authorities (*SPLCTL) as it should be.

The following fixes were included in version R03M37:

  • When utilizing the PDFSPLF, and specifying page size of *A4, the actual page size is not created consistently.
  • Email requests specifying only a spooled file name (SPLF) and no specific job information generate an MCH1210 ‘MCH1210 unmonitored by ESNDGSA’ message.
  • The process to obtain system IP address of the Using the Email Configuration Assistant for Esend was changed because in some instances, the previous method could fail.

The following fixes were included in version R03M36:

  • CPYSPLIFS was not using the same spool selection rules as ESNDMAIL. So when CPYSPLIFS was used without user or job number and the job name was not unique, the first spooled file was sent, not the one indicated by SPLNBR.
  • When a subject is passed to ESNDFILE that is longer than 60 positions, the command will now continue to process and truncate the subject. This will mimic the ESNDMAIL command.

The following enhancements are included in ESEND version R03M36:

  • A new value for PDF in the Esend user defaults (ESNDUSR) will provide better control of PDF output to prevent printing, editing, and copying the PDF file.
  • Option 20 from the Configuration menu now uses ESETUP for the Email Configuration Assistance for ESEND to take you step-by-step through the set-up or troubleshooting steps of emailing from the power i.

The following updates were included in ESEND version R03M35:

  • Added Authority Failure entries in the audit journal for ESN815US2.
  • In the ERPTRULES, e-mail addresses entered in lowercase were converted to uppercase in our processing before sending, but should be in the case required by the recipient’s server.
  • When processing the PDFSPLF command, using the *11X14 or *11X17 in the Pagesize parameter, received error CPD0104, Expression not allowed for parameter PAGESIZE.

The following updates were included in ESEND version R03M34:

  • When e-mailing a PC file from SEQUEL and the file extension is not specified, the ESNDUSR EXT PC key will not be used.
  • When prompting the DSPESNDJRN command, received an error when pressing F4 on a starting or ending value in the Journal Receiver Range parameter .
  • In rare instances of EDISTRIB, received MCH0603 Array Index error.
  • HTML font generated an incorrect font size name when using font size 1 or 7.

The following updates were included in ESEND version R03M33:

  • ESNDEXEC failed to return any spooled files when the special value *ALL was used for the Maximum Returned Spools setting on the command.
  • The ESNDFILE command with an FTP request didn’t automatically create subdirectories if they didn’t exist.

The following updates were included in ESEND version R03M32:

  • Reversed a change made in R03M31 after learning that V6R1 does not include the QTCP/QTMHCGI service program. All customers will be expected to have the QHTTPSVR library installed.
  • An additional change was made to ensure that e-mailing the *LAST spooled file would select the appropriate last spooled file in all cases.

The following updates were included in version R03M31:

  • Pressing F4 on EFTPLST when there are no server profiles ended with error RNQ1255, Session or device error.
  • An e-mail request gave error MCH3401,Cannot resolve to object QHTTPSVR. Not all customers have the QHTTPSVR library, which supplies a newer service program QZHBCGI that SEQUEL was using for writing to STDOUT. The earlier service program, QTCP/QTMHCGI provides the same STDOUT functionality and is expected to exist on all systems.
  • ESVER gave error RNX0100, length or start position is out of range for the string operation, when the company name was between 38 and 40 positions.
  • On systems with lots of spooling activity for a user when the e-mail request specifically named the job rather than using JOB(*), ESEND would randomly include spooled files that had been printed or deleted before the list was compiled, causing the sort order of the list to be inaccurate.

The following enhancements were added to version R03M31:

  • Forward Rules Maintenance (EFWDRULES) was further improved to provide control of the status of the spooled file after sending. A new value of *SAVE was added.
  • The ESEND Plug-in is now compatible with Client Access V6R1 and V7R1.

The following enhancement was added to ESEND version R03M30:

  • The status of a spooled file sent by a forwarding rule is now SAV instead of RDY.

Abstract (top)

Currently shipping version: R10M39

No updates for this version.

The following updates are included in version R10M38:

  • LOADXREF gives MCH0603 error in PARSESQL analyzing a complex *QMQRY.
  • FNDSTR limit of 9,999 members has been increased.
  • LOADXREF fails with MCH1210 and MCH3601 on SCANCLP

The following updates are included in version R10M37:

  • WRKFLDGU displays message, ‘MCH0601 unmonitored by DBF002’.
  • LOADXREF joblog lists erroneous DOC9010 message with blank file name. We are incorrectly logging EDS (External Data Structure) reference when the source has no Ext name.
  • Running the RCRTDBR over a file with a trigger program caused the program to be removed.

The following enhancements are included in version R10M37:

  • SEQUEL Script Views commands will now be analyzed.
  • Commands in the option file have been updated to work with all SEQUEL object types.

The following updates are included in version R10M36

  • New Version

The following updates are included in version R10M35:

  • Issue resolved where RCRTRPGPGM did not compile when GENLVL parameter is set to 21.
  • Issue resolved where ABSTRACT was recompiling programs that used "blank" file name when it should have been ignoring those programs.
  • When loading the Robot Job Descriptions in Abstract, the following error is received: ‘Robot error message RNQ0202 *INQ "The call to PARSESQL ended in error’.
  • When a program has been analyzed and recorded in our xref database and then the program object is deleted, RCRTPGMR compiles the missing program using the wrong source member.
  • RCRTDBR does not preserve journalling attribute.
  • During source analysis in XREF load, receiving the following error:’Processing source for LEVYSRC/QCLSRC SQLSETRU2C A character representation of a numeric value is in error Function check RNX0105 - unmonitored by SCANRSS at statement 000000233/.

The following enhancement is included in version R10M35:

  • Support for IBM Rational Development for i (RDI) 9.x

The following update is included in version R10M34:

  • During the cross reference load, LOADQRY, received error RNQ0103: 'Target for numeric operation too small to hold the result’ when the library had more than 9,999 Queries.

The following updates are included in version R10M33:

  • A program utilizes a particular file/field in Free Form SQL. Program to Field relationship is not reflected in Abstract.
  • Analyzing general free format RPG (not SQL) with a blank line in the code was not loaded correctly.

The following enhancement is included in version R10M32:

  • Authorization code support added for Live Partition Mobility.

The following fixes are included in version R10M31:

  • ANZFILE is fixed to show DECFLOAT and Vargraphic field lengths correctly.
  • The LOADXREF process to analyze SQL that included “WITH NC” on a DELETE command was ignored.
  • Running option 64 (String Scan) over *All libraries, results in the following error RPG0121 ‘The SCANNER 99999999 array index is not valid’. Limit increased to 9,999.
  • WRKPROCU on some procedures produces an error ABP0305 'Long Field Name Not Found or Invalid'.

The following fixes are included in version R10M29:

  • Doing LOADQRY of some queries gave RNQ0103 ‘The target for a numeric operation is too small to hold the result’.
  • Improved messages during LOADXREF when an SQL statement that exceeds our maximum length is encountered.

The following enhancements is included in version R10M29:

  • Add right-click support to the ‘Find String’ action in ABSTRACT RDP for *MSGF object types – previously it only worked with *SOURCE object types.

Anydate (top)

Currently shipping version: R02M16

No updates for this version.

The following enhancements are included in version R02M14:

  • Added support for RQSDTA(*JOBD) to the OVRSYSDATE command to allow the job description’s request data to be placed in the job’s message queue.
  • AnyDate will now check for the existence of the registry and bypass the registration step if already registered.

The following fix is included in version R02M114:

  • Memory leak that can affect jobs that submit many thousands of other jobs has been resolved.

The following fixes are included in AnyDate version R02M12:

  • Date overrides caused the SEQUEL BCHEXECUTE command to fail with error CPD0013, A matching parenthesis not found.
  • Corrected a problem counting quotes in the RQSDTA parameter on SBMJOB requests. Some requests also failed with error CPD0013, A matching parenthesis not found.

The following updates were included in AnyDate version R02M11:

  • Only minor internal changes were made.

The following update was included in AnyDate version R02M10:

  • Improved handling of the RQSDTA parameter on SBMJOB requests.

The following update was included in AnyDate version R02M09:

  • Corrected STD8002 message used for certain license authorization problems.

The following updates were included in AnyDate version R02M08:

  • Corrected RNX0113. A calculation involving a Date, Time, or Timestamp data type resulted in overflow or underflow when the license code is invalid.
  • Enhanced AnyDate so that catastrophic problems in jobs with a date override could not result in orphaned AnyDate registry processes. For example, a power outage at a critical moment can no longer result in Date Override problems when the system comes back.

The following updates were included in AnyDate versions R02M06 and M07:

  • Internal technical changes.
  • Added the RPGLETIME test program for %DATE and %TIME functions

The following update was included in AnyDate version R02M05:

  • Implemented exit point sharing through cross-product Globally Shared Components module. This allows, for example, both Robot/SCHEDULE and AnyDate to use the IBM exit Point QIBM_QCA_CHG_COMMAND.

The following updates were included in AnyDate version R02M04:

  • Added RPG and RPGLE programs to test the TIME opcode.
  • Corrected a processing problem with Time and Time Offset overrides. The %TIME function was not working in RPGLE.