StarSQL for Windows v6.37 Release Notes

July 2018

This document provides late-breaking information about the StarSQL for Windows ODBC software driver.

StarSQL Provides Fast, Reliable Access to DB2

StarSQL for Windows provides fast reliable access to IBM DB2 relational databases from any ODBC-enabled application. The powerful StarSQL driver enables Windows applications on a desktop computer to transparently access, send SQL queries to, and retrieve results from databases on remote IBM mainframe, midrange, or UNIX systems, including double-byte hosts. This allows you to open a database on the host as if the database were stored on your local computer.

The following topics are addressed in these Release Notes. Refer to the StarSQL for Windows Quick Start Guide for detailed information about installing StarSQL for the first time, and refer to the StarSQL for Windows Help (sqwizard.chm) and User's Guide (ssqlwin.pdf) for detailed information about using the StarSQL for Windows driver.

System Requirements

You can install and run the StarSQL for Windows driver on computers with the following Windows operating systems.

StarSQL (32-bit):

StarSQL (64-bit)

StarSQL requires Visual C++ 2015 runtimes. The StarSQL installer will install the Microsoft-supplied Microsoft Visual C++ 2015u3 Redistributable package if it is not already present on the system. The Microsoft Redistributable package will remain on the system if StarSQL is upgraded or uninstalled.

We recommend installing the latest Windows updates. For Windows Server 2012R2 and windows 8.1, the  April 2014 update rollup for Windows RT 8.1, Windows 8.1, and Windows Server 2012 R2 (2919355) is required.

StarSQL requires the Universal C Runtime (KB2999226), which is a Windows operating system component typically installed by Windows Update on systems earlier than Windows 10; it can also be downloaded from Update for Universal C Runtime in Windows. If not already present, this component is installed by the SQDR installer as part of the Visual Studio 2015 redistributables. The error api-ms-win-crt-convert-I1-1-0.dll is missing will result if KB2999226 has not been installed.

The following command will display whether KB2999226 has been installed:

C> wmic qfe list brief /format:texttablewsys | findstr KB2999226

Note that these system requirements supercedes any listed in the online documentation.

Host Connectivity

The StarSQL ODBC driver works within a TCP/IP network to connect a Windows client directly to a DB2 host. You can also use a SSL (Secure Socket Layer) connection when supported by the host database, or in conjunction with a StarPipes Gateway.

If you need SNA connectivity to your host, the StarQuest StarPipes software can serve as a gateway between clients on a TCP/IP network and DB2 hosts on an SNA network. StarPipes can also be used to provide a SSL (Secure Sockets Layer) connection over a public network.

Host Databases

You can use the StarSQL driver to connect to any of the following host databases:

If you will be accessing Unicode or ASCII LOB data on DB2 for z/OS v8.1, it is recommended that you have applied the PTFs described in the IBM APAR PQ85495. For details, refer to the expert setting UseSYSDUMMYAEU in the StarSQL Configuration Wizard help (sqwizard.chm).

What's New in StarSQL for Windows v6.3x

This release of StarSQL for Windows includes the following enhancements. .

Upgrade Considerations

This section describes issues of interest for users who are upgrading from a prior version of StarSQL.

StarSQL 6.34 & later supports (and properly describes) TIMESTAMP columns with a scale between 0 and 12. We have chosen to expose DB2's default timestamp precision of 6 as a separate data type name in SQLGetTypeInfo(), named "TIMESTAMP(6)", the type name "TIMESTAMP" is now described as having variable scale from 0 to 12. Setting the data source option HideTsScale=YES will instruct StarSQL to revert to pre-6.34 behavior and hide the variable scale version of TIMESTAMP in SQLGetTypeInfo().

This version of StarSQL requires Windows 7sp1 or 2008R2sp1 or later; older operating systems such as Windows XP, Windows Vista, Windows Server 2003 and Windows Srrver 2008 are no longer supported.

Detailed Upgrade Considerations

See the technical document Upgrade Considerations for StarSQL 6.1 & Later for detailed information including data source changes, installation hints and information about deprecated features.

Rebinding Packages

After installing StarSQL 6.2x, you should rebind StarSQL packages on the host system if you upgrading from a version of StarSQL prior to V6.27. We suggest that you use StarAdmin to do this; see the StarSQL technical document Binding StarSQL Packages Using StarAdmin for details. If you are using any version of StarSQL prior to v6.19, upgrade those clients to StarSQL v6.19 or later or use a different package collection. See the StarSQL User's Guide (SSQLWin.pdf) for details about package compatibility.

There is no need to bind SQL packages for Derby databases.

64-bit Considerations

StarSQL (64-bit) and StarSQL (32-bit) can be installed on the same system and are independent of each other.

StarSQL (64-bit) can use the same StarSQL packages as StarSQL (32-bit).

ODBC data sources for 32-bit and 64-bit environments are configured independently using the appropriate version of the Windows ODBC Administrator. The 32-bit version of ODBC Administrator is located in the Windows\SysWOW64 directory, and the 64-bit version is located in the Windows\System32 directory. Selecting the ODBC Administrator shortcut from the StarSQL (32-bit) program group invokes the 32-bit version of ODBC Administrator, and selecting the ODBC Administrator shortcut from the StarSQL (64-bit) program group invokes the 64-bit version.

The 64-bit ODBC driver appears with the name StarSQL (64-bit). The 32-bit version of the StarSQL ODBC driver is named StarSQL 32. Note that it is important to specify the correct driver name in File data sources or in DSN-less connection strings.

On a Windows x64 system, both 32-bit and 64-bit User Data Sources ("User DSNs") are visible to both 32-bit and 64-bit ODBC applications and both versions of ODBC Administrator, but are only usable by the matching type of application (i.e. 64-bit applications only can use 64-bit User DSNs, 32-bit applications can only use 32-bit User DSNs). If your ODBC application attempts to use the incorrect type of data source, a "Data source name not found and no default driver specified" error is returned. Attempting to open a User DSN with the incorrect version of ODBC Administrator will display the error "The setup routines for the StarSQL ODBC driver could not be found.  Please reinstall the driver".

To help identify the type of a User DSN, you may want to add "_32" or "_64" to the data source name.

For additional information, see the Microsoft Knowledge Base article http://support.microsoft.com/kb/942976: "The 32-bit version of the ODBC Administrator tool and the 64-bit version of the ODBC Administrator tool display both the 32-bit user DSNs and the 64-bit user DSNs in a 64-bit version of the Windows operating system."

Two-Phase Commit Considerations

When using two-phase commit on a 64-bit computer, install only the 64-bit version of the Resource Manager Administration Tool. Only one version of the Resource Manager and MMC Plug-in can be installed at one time, and the 64-bit version of the Resource Manager can be used by both 32-bit and 64-bit ODBC applications. If you must use a version of the 32-bit StarSQL that is earlier than v5.5 for two-phase commit, do not install the Resource Manager component of StarSQL (64-bit).

 

64-bit Application Notes

To import and export data with the SQL Server 2005 and later using SQL Server Integration Services (SSIS), you will be using Business Intelligence Development Studio, which is a 32-bit application and displays only 32-bit providers. Consequently you will need to install both the 32-bit and 64-bit versions of StarSQL, and configure both 32-bit and 64-bit data sources with identical names. The SSIS runtime will select the appropriate version of the provider to use.

You also can use the older Data Transformation Services (DTS) for import/export. Be sure to use the 64-bit version of the DTS wizard DTSWizard.exe.

For OLEDB applications such SQL Server linked server function, use the 64-bit OLEDB Provider for ODBC (MSDASQL).

Refer to the following technical documents for additional information:

FixPak and PTF Notes

This section describes specific IBM issues and the FixPak and PTFs that may be necessary for StarSQL to function properly.

IBM i (OS/400) PTFs

In general, it is a good idea to stay current with the PTF CUM and HIPER packages and the DB2 Group PTF, and to use the latest version of StarSQL. The following sections describe more specific issues for different versions of IBM i (OS/400); check to see that the PTFs listed below are either installed or superceded.

i 7.3

Install the following PTF's:

5770SS1-SI60775 for APAR SE64851

i 7.1

Install the following PTF's:

5770SS1-SI47677
5770SS1-SI47695
5770SS1-SI47401
5770SS1-SI47379

If you are using Java stored procedures, install PTF 5770SS1-SI39711.
If you are using LOB, install PTF 5770SS1-SI39331.

If you are at cum level ptf level C10229710 and experience unusual behavior, such as "SQLSTATE 22001, native error -404, [StarSQL][StarSQL ODBC Driver][DB2/400]Value for column COL1 too long.", install PTF 5770SS1-SI46072 for APAR SE51079.

If you are uploading XML data to the iSeries, install PTF 5770SS1-SI52427.

If you are using 2PC, install PTF 5770SS1-SI51103.

i 6.1

cum C8064610 or later
PTF 5761SS1-SI30581
If you are using LOB, install PTF 5761SS1-SI39331

If you are using stored procedures, install PTF's 5761SS1-SI36405 and 5761SS1-SI36136.

If you are uploading XML data to the iSeries, install PTF 5761SS1-SI52430.

f you are using 2PC, install PTF 5761SS1-SI51095.

v5r4

PTF 5722SS1-SI23461
PTF 5722SS1-SI24317

If you are using stored procedures, install PTF's 5722SS1-SI22551, 5722SS1-SI36406, and 5722SS1-SI36059.

If you are working with BLOB data, install PTFs 5722SS1-SI22324 and 5722SS1-SI22335.

DB2 for LUW

Binding catalog package to DB2 UDB v8 FP8 or FP9 fails: If you have installed FixPak 8 or FixPak 9 on DB2 UDB v8 (Windows and UNIX), you will not be able to bind catalog packages. This is an IBM problem (APAR JR21670). The fix is included in FixPak 10.

Documentation Errata


Binding Packages on the host system

For hosts running Derby, there is no need to bind SQL packages on the host system.

Suppress Warnings from stored procedures

After upgrading from an older version of StarSQL or an older version of DB2, you may encounter new warning messages when invoking stored procedures; for example:

[DB2]PROCEDURE JPPNODOP RETURNED 1 QUERY RESULTS SETS

If you have an existing application that expects the older behavior, you can suppress warnings from stored procedures by adding the following to the [Default] section of swoodbc.ini (or swodbc64.ini) in the StarSQL Programs directory:

SuppressSpWarnings=Y

Using StarSQL with MSDASQL OLEDB provider or OpenOffice

To take advantage of StarSQL's Unicode support when using Open Office, or when using SQL Server linked server or other applications that use the MSDASQL OLEDB provider, set the AlwaysWide setting (available as either a connect string or a data source expert setting) to YES to instruct StarSQL to report SQL_CHAR and SQL_VARCHAR as SQL_WVARCHAR etc. This will cause the MSDASQL OLEDB provider to expose these columns as WString instead instead of String.

Known Limitations

File DSNs and Microsoft Access

File DSNs that contain more than 255 characters may cause Microsoft Access to produce an error that the maximum length of the connection string has been reached.  To avoid this, review the File DSN and remove any parameters that are not required for the connection.  The only required parameters are Driver, HostName, Netlib, and Server.  Any parameter that is set to the driver's default value may be safely removed.  The default values can be found in the StarSQL online help (sqwizard.chm).

Change History

This section provides information about problems or enhancements that are made available as "point releases" between major releases of the StarSQL for Windows software.

Version Number Release Date Significant Changes
v6.37.0719 Jul 2018 14329 - parser issue in SQDR snapshot scenario
v6.36.0608 Jun 2018 14308 - use dynamic SQL rather than packages for all catalog calls (DB2 z/OS)
v6.35.0430 Apr 2018 14260 - connection to DRDA A/S servers that don't send SRVNAM and EXTNAM in the EXCSATRD
14288 - improve handling of DLL unload
v6.34.0116 Jan 2018 14119 - improvements in reporting TIMESTAMP scale
14175 - improved support for TIMESTAMP(s) s>6
14183 - Config option HideTsScale to hide Variable scale TIMESTAMP
v6.33.1002 Oct 2017 13988 - Cursor Identified is not open (WITH clause)
14007 - Expose Hidden Columns in SQLColumns
14068 - Improvements in SSL support
v6.32.0208 Feb 2017 13778 - StarSQL installer: update to InstallShield 2016
13870 - Implement conditional passing of RSTREF for DB2 Z/OS XML processing
v6.31.1025 Oct 2016 13788 - rename libiconv-2.dll
v6.30.0830 Aug 2016 13718 - Build StarSQL & libiconv with VS2015
v6.28.0817 Aug 2016 13698 - Communications link failure retrieving XML column data
13715 - SQL Server 2016 Linked Server problems
13724 - insert of binary BLOB data
v6.27.0603 Jun 2016 13663 - UDB BigInt overflow condition in catalog calls
13678 - Column name containing em-dash incorrectly translated by SQLDescribeCol
v6.26.0513 May 2016 13653 - SQLStatistics Fails w/error -413 SQLCODE when CARDF column in SYSTABLES is > max(integer)
v6.25.0115 Jan 2016 13579 - custom 1252 to Unicode conversion
v6.24.1223 Dec 2015 13562 - Error in caching logic may cause conversion error for SQL_C_CHAR
v6.23.1110 Nov 2015 13475 - Installer: update to IS2015 and use new SHA-256 code-signing certificate
13520 - Support additional cp1252 conversions
v6.22.1029 Oct 2015 13392 - support IBM IDAA accelerator
v6.21.0507 May 2015 13317 - DB2 LUW SQL Column maximum column name length should be reported as 128
v6.20.1007 Aug 2014 12620 - Expose alternate "character" data types (DB2 for z/OS)
12651 - DB2 for z/OS 11: add new error messages
12675 - Update host error messages for DB2 LUW 10.5
12714 - Return SQLSTATE=42S02 rather than 42704 for table not found error
12765 - Support Apache Derby
12768 - z/OS Identity Propagation
12789 - MSI Installer: add Derby; update to IS2013
12790 - Derby: add host messages
12803 - Update host messages for IBM i 7.2
12817 - Improve handling of certain dynamic values (DBMS version etc)
12884 - handle LOB output parameters from a stored procedure that returns result sets
v6.19.1307 Jan 2014 12604 - Support SQL_C_BIT Conversions to integer and decimal data types.
12619 - Expose alternate "character" data types explicitly to provide Apps with better data type granularity at create table time.
12630 - Return "wide" SQL types for GRAPHIC etc
v6.18.1016 Oct 2013 10302 Trace Viewer when SQLAM>6 and SQLDARD present in trace
12521 Abandon 2PC connection after AGNPRMRM SYNCCTL failure
12522 password key generation
v6.17.0912 Sept 2013 12504 Hang when passing short string to stored procedure fixed length CHAR parameter
v6.16.0814 Aug 2013 12487 Problems passing string parameter larger than 8k using ADO
v6.15.0620 May 2013 12408 - Disable roundtrip conversion check
12428 - libiconv updates
v6.14.0508 May 2013 12387 DescribeColumnAll only returns first 30 characters of column name in result set
v6.13.0201 Feb 2013 12272 StarSQL returning incorrect data for some decimal datatypes
v6.12.1226 Jan 2013 12089 SSL connection from Win7 or Server2008 to UDB fails
12212 CLOB data type not returned properly on SP by SQLDescribeColumn
12226 Unable to create datasource on Windows Server 2012
v6.11.0720 Jul 2012 12050 Fixes for columns-wise binding for result sets and parameters (64-bit)
12052 SQL_DESC_OCTET_LENGTH does not correctly reflect column byte count when alwaysWide is turned on.
v6.10.0319 Mar 2012 Initial release of v6.10

If You Need Help

Contacting StarQuest

If you need to contact technical support, please provide the following information to help the support engineers address your issue. You can contact StarQuest via phone, email, or facsimile as indicated at the bottom of this page.

Company Information Address
Phone
Fax
Contact Information First and Last Name of individual contact
Email Address
Host Type Hardware and Operating System (i.e., AS/400 V5R4)
Network Protocol/Gateways Protocol and/or Gateways used (i.e., TCP/IP, HIS 2000)
Client Type Client Type and Operating System (i.e., Windows 2008 SP2)
StarQuest Product,
Version, and Source
Which StarQuest product and what version is installed (i.e., StarSQL for Windows v6.11.07.20)
Where you obtained the software (i.e., direct from StarQuest, name of specific reseller)
Problem Information Provide as much detail as possible, including information about any application that is using the StarQuest product when the problem occurs and the exact error message that appears.

© 2018 StarQuest Ventures, Inc. All rights reserved.

StarQuest Ventures logoStarQuest Ventures, Inc.
PO Box 1076
Point Reyes Station, CA 94956
Telephone: +1 415.669.9619
FAX: +1 415.669.9639
Sales information: https://www.starquest.com/contact
URL: https://www.starquest.com
Support: https://support.starquest.com
Info Center: https://www.starquest.com/docs