Viewpoint

June 2017

Version: 11.17.163

Fixes

• The Excel Add-in in version 11.17.104 of Viewpoint did not work with spreadsheets created with earlier versions of Viewpoint.
• View Designer could end in error when editing some GROUP BY views.
• View Designer was not correctly omitting literals and constants from GROUP BY Clause.

April 2017

Version: 11.17.104

The following Enhancements are included in this version:

• Dashboards now have a setting for Default Font.
• The Viewpoint log now includes the date and time in the filename like so: VPlog_02242017_113011.txt. Files older than 7 days will automatically be deleted.
• New command line switch added to allow logging to be turned on without the warning message to the user /z:q

The following Updates are included in this version:

• View Designer (with server connection of remote—not *LOCALSYS or *SEQUEL) displays error ‘SQ9999 Error occurred in SQL Call Level Interface’ when switching to the Files & Fields and there is an alias field used mixed as “SumLval70”.
• View Designer (using SERVER(*LOCALSYS) SYNTAX(*SEQUEL)) removed the GROUP BY clause when switching to the Files & Field tab and view contained a WDATA on the SELECT clause.
• In View Designer Files & Fields tab (for *LOCALSYS views only) derived fields that result in a DATE data type will now apply a type of DATE in the TYPE field.
• In View Designer (using SERVER(*LOCALSYS) SYNTAX(*SEQUEL)) the Expression Editor to build the WHERE clause should use the AltName of an expression, not the expression itself.
• In a *LOCALSYS view, when building conditions in the WHERE clause Expression Editor, file identifiers are included when you select fields from files and not variable names.
• Opening a view in View Builder when files are not library qualified on FROM clause displays error 'A library is required for selection'.
• Application open in design will now detect any changes made to the view.
• Temporary files created by the Viewpoint OLE DB Provider will now be deleted.
• Emailing IBM i joblog from Viewpoint when there is a single apostrophe in the message text, failed to deliver email.
• When saving a client report over a view with either a numeric or an expression type variable (with no default value), will return an error that the value is not a valid numeric value for the numeric variable, or a syntax error for the expression type variable.
• Running a dashboard from a Viewpoint shortcut (.vpt) multiple times could produce a ‘runtime automation’ error message. Problem introduced in VP 11.16.294.
• Viewpoint is buffering data from a view when run in a dashboard, even though charts are designed beyond the initial records.
• The ability to provide custom edit masks on 7 segment digital gauges has been restored and improved by extending the supported mask from 6 characters to 20 characters.
• In Dashboard designer, resizing gauges very often causes the gauge to shrink or disappear.
• Running a client report from a script using the REPORT command to email displays the error MCH1210 ‘Receiver value too small to hold result’.
• Saving a client report when the view had an Expression (EXPR) variable, without a Default Value, would fail.
• In the Script Designer on Windows 10, prompting a second command did not show the command prompter, but the log showed the error ‘there was a problem with DLL: cwbunapi.dll’.
• From the Excel Add-in, Refresh All was not working with two views from two different hosts.
• From the Excel Add-in, when refreshing data if a prompted view returns no records, the current data is not blanked out.
• From the Excel Add-in, when refreshing all variables, even if from different views, will combine into one prompt.
• Dynamic Drill Down and Show Details option display syntax errors when the view used WDATA.
• Viewpoint Administrator will now all you to delete a remote server entry.
• A .vpt shortcut to create PC file without /D switch should prompt for path information.
• The Import > Query option will now use the SERVER and SYNTAX settings from the User’s defaults.

October 2016

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.

• 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.

• 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.

April 2016

Version: 11.16.098

The following updates are included in this version:

• 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.

• 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.

• 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.

• 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:

• 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.

November 2015

Version: 11.15.317

The following updates are included in this version:

• 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.

• 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 this version:

• 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

May 2015

Version: 11.15.167

The following updates are included in this version:

• 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 this version:

• 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.

Back to Product Index

Viewpoint 10

June 2014

Version: 10.14.160

The following updates are included in this version:

• 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 this version:

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

April 2014

Version: 10.14.094

The following updates are included in this version:

• 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.

December 2013

Version: 10.13.340

The following updates are included in this version:

• 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 this version:

• 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.

October 2013

Version: 10.13.304

The following updates are included in this version:

• 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

September 2013

Version: 10.13.260

The following updates are included in this version:

• 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 this version:

• 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.

August 2013

Version: 10.13.221

The following updates are included in this version:

• 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 this version:

• 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.

May 2013

Version: 10.13.155

The following updates are included in this version:

• 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 this version:

• 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.

February 2013

Version: 10.13.087

The following updates are included in this version:

• 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 this version:

• 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.

January 2013

Version: 10.13.007

The following updates are included in this version:

• 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 this version:

• 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.

October 2012

Version: 10.12.304

The following update is included in this version:

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

September 2012

Version: 10.12.289

The following updates are included in this version:

• 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.

May 2012

Version: 10.12.163

The following updates are included in this version:

• 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.

April 2012

Version: 10.12.135

The following updates are included in this version:

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

March 2012

Version: 10.12.096

The following updates are included in this version:

• 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 are included in this version:

• 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.

January 2012

Version: 10.12.030

The following updates are included in this version:

• 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 are included in this version:

• 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.

September 201

Version: 10.11.280

The following updates are included in this version:

• 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 are included in this version:

• 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.

August 2011

Version: 10.11.244

The following updates are included in this version:

• 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 are included in this version:

• 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.

July 2011

Version: 10.11.202

The following updates are included in this version:

• 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 this version:

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

June 2011

Version: 10.11.179

The following updates are included in this version:

• 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 this version:

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

April 2011

Version: 10.11.144

The following updates are included in this version:

• 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.

March 2011

Version: 10.11.118

The following updates are included in this version:

• 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 are included in this version:

• 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.

March 2011

Version: 10.11.070

The following updates are included in this version:

• 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.

February 2011

Version: 10.11.046

The following updates are included in this version:

• 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.

November 2010

Version: 10.10.343

The following updates are included in this version:

• 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.

November 2010

Version: 10.10.323

The following updates are included in this version:

• 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 are included in this version:

• 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.

August 2010

Version: 10.10.245

The following updates are included in this version:

• 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.

July 2010

Version: 10.10.230

The following updates are included in this version:

• 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.

July 2010

Version: 10.10.211

The following updates are included in this version:

• 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.

June 2010

Version: 10.10.175

The following updates are included in this version:

• 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 are included in this version:

• 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.

April 2010

Version: 10.10. 123

The following updates are included in this version:

• 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.

 

Back to Product Index

 

Copyright © HelpSystems, LLC.
All trademarks and registered trademarks are the property of their respective owners.
Last Published: 201709261131