| |
 |
Initial Release of the Viaserv TCP/IP Secure Tunnel Processor. This new component supports use of SSL/TLS protocols to secure inbound and outbound TCP/IP connections by z/OS applications that were developed using unsecured socket APIs. |
| |
|
Changes have been made to Access Server components in this release to support the use of the Viaserv TCP/IP Secure Tunnel Processor for securing TCP/IP connections using SSL/TLS protocols and supporting multiple Access Server TCP/IP resource managers running in the same CICS region. |
| |
|
Support for DB2 9.1 BIGINT, BINARY, VARBINARY, and DECFLOAT columns. Limited support for DB2 9.1 BLOB and CLOB columns. |
| |
|
Support for new datatypes in SQL Server 2008 and Sybase ASE 15. Bigint, date, time, and datetime2 are among the new datatypes that are supported in bulk and template transfers. |
| |
|
Initial release of the ViaSQL Preprocessor and associated run-time component for z/OS and VSE systems. CICS and batch programs can use the DB2 API to access lan-based RDBMS systems like SQL Server, Oracle, Sybase, and others. Additionally these programs can access all data sources supported by the Legacy Data Server, like VSAM, IMS, Datacom, and others. |
| |
|
Production release of the ViaSQL Redirector. The ViaSQL Redirector enables VSE applications to access existing remote DBMS data and services using the VSAM API. VSAM applications can access data in SQl Server, Oracle, Sybase, DB2/UDB, and others. |
| |
|
Enhanced support in the Legacy Data Server for left outer joins. |
| |
|
The Access Server now supports long userid and passwords for Client Servicies Applications. Userids and passwords can now be up to 30 bytes in length. |
| |
|
The CSA Server for Java and the ViaSQL Transfer Engine now support parameter arrays. |
| |
|
An "allowed client list" capability has been implemented to minimize resource consumption due to inappropriate applications connecting to the CSA Servers or the ViaSQL Transfer Engine.This feature prevents deliberate denial of service attacks, and improves security in general. |
| |
|
The Beta version of the ViaSQL Redirector was released. The ViaSQL Redirector feature enables VSE applications to access existing remote DBMS data and services using the VSAM API. |
| |
|
A new component, the Viaserv OLE DB Provider, is included in this release. This component is a replacement for the Microsoft OLE DB Provider for ODBC, which is no longer supported in certain environments. |
| |
|
x64 versions of the ViaSQL Gateway and related components (Gateway Manager, Gateway Manager Server, CSA Server, Viaserv ODBC Driver, and Viaserv OLE DB Provider), as well as of the Transfer Server are available in this release. |
| |
|
Performance improvements for small (in-memory) sorts, and enhanced join optimization in the Legacy Data Server. |
| |
|
This release adds support for multiple CSA ATTACH connections from a single CSA program instance. |
| |
|
The previous release of ViaSQL allowed access to VSAM, IMS, DL/I, and DB2 without the requirement for CICS. This release allows ViaSQL, deployed in a batch address space, to access CICS-controlled files. |
| |
|
CICS and Batch CSAs can now connect directly to a CICS or EIP Mode Access Server on the same or different machine, without having to pass through the CSA Server. This would allow, for example, a batch CSA to use SQL to access VSAM data that resides in another LPAR. |
| |
|
Additional scalar functions are now supported in Legacy Data Server. The new functions are YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, MICROSECOND, and CAST. These functions are most useful in the select list of a SELECT statement, but they can also be used in the where clause of a SELECT, UPDATE, or DELETE statement. |
| |
|
The ViaSQL Direct ODBC Driver and ViaSQL Gateway now support read-only access to ODBC Datasorces. A "read-only" configuration parameter is now available to limit access through an ODBC Datasource (DSN) to SQL statements that do not alter data in the target database. |
| |
|
Miscellaneous performance and usability enhancements. |
| |
|
This release adds the ViaSQL Exec Interface Platform to the ViaSQL Direct and ViaSQL Integrator products. With this feature, desktop and web applications are able to access VSAM, IMS, and DB2 data without the requirement for CICS. |
| |
|
ViaSQL now supports eXternal Stored Procedures (XSPs). XSPs are user-written programs, that can be executed by desktop and web-based applications. They are roughly equivalent to cics-based Remote Stored Procedures (RSPs), but run in a batch region or partition instead. |
| |
|
Access Server configuration and management can now be performed using a new windows-based configuration tool that provides configuration services for both the CICS and EIP Access Server environments. |
| |
|
This release adds a new set of functions that provide Client Services Applications (CSAs) with an easier method for handling result sets. |
| |
|
This release adds support for Web Client Applications. A Web Client Application is a customer-written, mainframe-based, batch or CICS program, which serves as the client in a web environment. A Web Client Application can be written in COBOL, PL/I, Assembler, or C. more . . |
| |
|
The ViaSQL Access Server now supports COMMAREA RSPs. Desktop and web applications can execute existing CICS programs that communicate through the CICS commarea. |
| |
|
ViaSQL now supports GRAPHIC, VARGRAPHIC, and LONG VARGRAPHIC columns in DB2. |
| |
|
Support for multiple access plans with Datacom SQL Option. |
| |
|
Miscellaneous enhancements to the Legacy Data Server and Legacy Data Manager. Support has been added for column exits, PL/I copybooks, and arithmetic expressions in the SELECT list. |
| |
|
This release adds support for Web Services and SOAP (Simple Object Access Protocol). With this feature, S/390 mainframes function as a SOAP server, allowing any standard SOAP client to access data, applications, and procedures residing on the mainframe. |
| |
|
Multiple TCP/IP groups can now be defined in ViaSQL Access Server. Installations can segregate their ViaSQL TCP/IP usage into groups which can be managed separately. Maximum number of sockets, terminal IDs permitted, and listener timeout values can be configured for each group. |
| |
|
The Legacy Data Server and Legacy Data Manager now support unsigned decimal (UDECIMAL) and unsigned numeric (UNUMERIC) data types. |
| |
|
This release adds enhanced support for DBCS translation. Fields in VSAM files, IMS, and DL/I segments that contain "pure" DBCS data (without leading SO and trailing SI characters) can be mapped in LDM with a datatype of GRAPHIC. |
| |
|
The Legacy Data Server now supports the PREPARE and EXECUTE of SQL INSERT, UPDATE, and DELETE statements. Client applications may prepare such an SQL statement, bind the parameters, and then and execute the statement repeatedly. With this enhancement, significant performance improvements can be achieved. |
| |
|
The ViaSQL Gateway provides a connection pooling mechanism that can result in performance improvements, and at the same time, reduces the usage of certain CICS resources. |
| |
|
Miscellaneous performance and usability enhancements. |
| |
|
The Java CSA Server is a new component, and is now included with both the ViaSQL Blue Direct and Integrator products. The Java CSA Server can be deployed on any Java-enabled platform, and provides functionality equivalent to the Windows CSA Server, which has always been a part of the ViaSQL Integrator product. |
| |
|
The Access Server can now run in a batch address space/partition for both the ViaSQL Blue Direct and Integrator products. This allows Client Services Applications (CSAs) to run in a batch region on OS/390 or VSE. Previously, CSAs could only run in a CICS region. |
| |
|
The Viaserv Common Services and Legacy Data Server regions now support registration with OS/390 Automatic Restart Management (ARM) to enhance restart capability for these components. |
| |
|
Support was added to the Legacy Data Server for the automatic caching of LDS control blocks. For tables with a large number of columns, caching significantly improves the performance of SQL queries and updates. |
| |
|
Performance has been improved for SQL queries that require the sorting of a relatively small number of records. Previously, the Legacy Data Server always called the mainframe system's sort package to perform sorts, which entailed a significant overhead. Now, for small result sets, the Legacy Data Server will perform its own in-memory sort. |
| |
|
Miscellaneous improvements to the SQL support in the Legacy Data Server include support for the TOP clause, support for expressions in the SET clause of an UPDATE statement, and support for ordinal numbers on the GROUP BY clause. |
| |
|
Miscellaneous usability improvements were made to the Legacy Data Manager. |
| |
|
XML-format result data from ANY ViaSQL-enabled datasource! Result sets can be returned in XML format to ODBC and JDBC clients or can be directed into MQSeries queues, CICS temporary storage queues, and transient data queues. More . . . |
| |
|
Data in a LAN file can now be transferred to an OS/390 or VSE database. Previously, transfers to the mainframe required source data from a LAN database. Transfers in the other direction can write data to a LAN database or to a file. |
| |
|
Blocking protocol used to return data from Legacy Data Server CICS VSAM or DL/I datasource to CICS. Initial tests show up to 50% performance improvement when retrieving large result sets. |
| |
|
New TCP/IP Listener management tool allows the starting and stopping of individual TCP/IP Listeners. |
| |
|
TCP/IP connections from client now use either TCT-based sessions or “background sessions.” Background sessions don't require TCT definitions, resulting in easier setup and administration. Support for TCT-based sessions has been enhanced to provide more flexible CICS resource management. |
| |
|
Expanded support for multiple record types in data files. |
| |
|
Keyed (RBA) Access to VSAM ESDS files |
| |
|
Support for scalar functions and left outer joins in SQL SELECT statements. |
| |
|
Expanded support for arrays. ViaSQL is now able to present an array as either additional columns in a table or as an “occurrence table.” In an occurrence table, each occurrence of the array is presented as a separate row. |
| |
|
Support for century codes in date fields. |
| |
|
Support for Date and Time expressions in SQL WHERE clause. |
| |
|
Improvements to file mapping in the Legacy Data Manager. |
| |
|
This version of ViaSQL for VSE adds support for TCP/IP-TOOLS for VSE from Barnard Software. TCP/IP for VSE from Connectivity Systems is also supported. |
| |
|
Support for SQL access to CA-Datacom/DB Release 9.0 and later, via the CA-Datacom/DB SQL Option |
| |
|
Support for GROUP BY and HAVING clauses through the Legacy Data Server |
| |
|
Support for additional packed date formats in the Legacy Data Server and Legacy Data Manager. DATE templates can now be built using the MM, YY, YYYY, DD, and DDD symbols, etc. |
| |
|
The Legacy Data Manager now displays existing table and column privileges, enhancing security management on virtual tables |
| |
|
Support for tracing of specific event types by the ViaSQL Access Server: informational and error messages, client I/O, server activity, ViaSQL API, and session tracing (TCP/IP connectivity only) |
| |
|
Support for double-byte character sets |
| |
|
Enhanced ability to optimize VSAM file access when the index contains a NUMERIC column |
| |
|
Added capability to join on non-identical columns: in certain circumstances it is possible to join NUMERIC, INTEGER, and DECIMAL columns |
| |
|
Modified LDS optimization procedures to support queries generated by Microsoft SQL Server v7 distributed query function |
| |
|
Added support for packed date fields via a new DATE template in the virtual table definition. Supports packed dates that are represented by a base year and the number of days before or after January 1 of that year |
| |
|
In virtual table definitions, columns named FILLERxx are not stored in the Legacy Data Server catalogs. This improves performance during catalog access, improves presentation of the tables containing these columns, and enables masking of fields during virtual table definition |
| |
|
Multi-column keys in IMS segments can now be mapped into multiple columns in the virtual table definition |
| |
|
New Gateway Manager functionality that allows listing of all active ViaSQL Gateway services on the current platform, and testing of all configured ViaSQL Gateway services on the current platform |
| |
|
Added transfer connectivity test, verifying ViaSQL Gateway access to secondary connection (LAN database) |
| |
|
Support for native client access to MS SQL Server and Oracle databases during CSA processing, and for ODBC access to other databases. Native client access to Sybase databases was already supported. This replaces the requirement for the Viaserv ODBC Server in CSA architectures |
