StarSQL Technical Documents

Quick Start Guides | FAQs | StarSQL for Java | StarSQL Usage | Installation | Troubleshooting | Using StarSQL with Third Party Applications | Programming with StarSQL | Host Configuration Issues | Internationalization


Quick Start Guides

StarSQL Quick Start Guide
Article # SQV00SQ008
This document is a guide for installing and configuring the StarSQL for Windows ODBC driver.
StarSQL for Java Quick Start Guide
Article # SQV00SJ007
This document is a guide for installing and configuring the StarSQL for Java JDBC driver.
StarSQL for UNIX Quick Start Guide 
Article # SQV00SU001
This document is a guide for installing and configuring StarSQL for UNIX.

Frequently Asked Questions (FAQs)

How to Troubleshoot and Report a StarSQL ODBC Driver for Windows Problem
Article # SQV00SQ016
This document describes how to collect the information needed to help StarQuest Customer Support troubleshoot a problem that you are encountering with the use of the StarSQL ODBC Driver for Windows.
How to Troubleshoot and Report a StarSQL for UNIX Problem
Article # SQV00SU002
This document describes how to collect the information needed to help StarQuest Customer Support troubleshoot a problem that you are encountering with the use of the StarSQL for UNIX driver.
StarSQL Product FAQs
Article # SQV00SQ033
The following FAQs are designed to answer common questions regarding StarSQL.
StarSQL Technical FAQs
Article # SQV00SQ061
The following technical FAQs are designed to answer common questions regarding StarSQL.
StarSQL Login FAQs
Article # SQV00SQ032
This article answers frequently asked questions (FAQs) about using StarSQL logins. 
Common StarSQL Error Messages
Article # SQV00SQ030
This document lists the most common error messages encountered while using StarSQL.
 

StarSQL for Java Technical Documents

Logging StarSQL for Java Activity
Article # SQV00SJ001
The StarSQL for Java driver provides a facility for tracing API activity and logging DRDA communications between the driver and the DB2 host.
Sending Client Information to DB2 using StarSQL for Java
Article # SQV00SJ002
This document details how to use the native API in StarSQL for Java to pass client information with every DB2 connection request from an application server.
Using StarSQL for Java to Access DB2 from an Oracle Stored Procedure
Article # SQV00SJ003
This document describes how to use StarSQL for Java to access a DB2 database from an Oracle database.
How to Troubleshoot and Report a StarSQL for Java Problem
Article # SQV00SJ004
This document describes how to collect the information needed to help StarQuest Customer Support troubleshoot a problem that you are encountering with the use of the StarSQL for Java driver.
Using StarSQL for Java with IBM Websphere Application Server
Article # SQV00SJ005
The StarSQL for Java JDBC driver can be used with IBM's Websphere Application Server (WAS) to access DB2 data. This document explains how to configure WAS versions 5 and 6 to use StarSQL for Java and how to create a JDBC data source.
Using StarSQL for Java with IBM Websphere Application Server Community Edition
Article # SQV00SJ010
The StarSQL for Java JDBC driver can be used with IBM's Websphere Application Server Community Edition (WASCE), based on Apache Geronimo, to access DB2 data. This document explains how to configure WASCE version 2.1 to use StarSQL for Java.
Using StarSQL for Java with Oracle WebLogic
Article # SQV00SJ013
The StarSQL for Java JDBC driver can be used with the Oracle WebLogic application server to access DB2 data. This document explains how to configure Oracle WebLogic to use StarSQL for Java.
Using StarSQL for Java with ColdFusion
Article # SQV00SJ006
StarSQL for Java can be used with ColdFusion applications to access DB2 data. This document explains how to configure a data source in ColdFusion to use StarSQL for Java and provides sample code.
Using StarSQL for Java with IBM Data Studio
Article # SQV00SJ008
StarSQL for Java can be used with IBM Data Studio, an Eclipse-based application for DB2 administration and development. This document explains how to configure a database connection in Data Studio to use StarSQL for Java.
Using StarSQL for Java with DbVis DbVisualizer
Article # SQV00SJ014
StarSQL for Java can be used with DbVis DbVisualizer, a Java-based universal database tool. This document explains how to configure a database connection in DbVisualizer to use StarSQL for Java.
Using StarSQL for Java with DBeaver
Article # SQV00SJ015
StarSQL for Java can be used with DBeaver, a Java-based universal database tool. This document explains how to configure a database connection in DBeaver to use StarSQL for Java.
Silent Installation of StarSQL for Java
Article # SQV00SJ009
This technical note explains how to install StarSQL for Java silently without user interaction; this is useful for automating the processing of deployment on large numbers of client computers.
StarSQL for Java Licensing
Article # SQV00SJ011
This technical note offers troubleshooting advice for StarSQL for Java licensing issues.
StarSQL for Java Troubleshooting
Article # SQV00SJ012
This technical note offers troubleshooting advice for StarSQL for Java issues.
 

General StarSQL Usage

Calling an AS/400 Program with QCMDEXC
Article # SQV00SQ040
You can execute a program on the AS/400 using the program QCMDEXC.
Using StarSQL to Access Multi-Member Files
Article # SQV00SQ035
This document explains how to use StarSQL to access members in multi-member files on the AS/400 system.
How to Automate StarSQL Logins
Article # SQV00SQ037
This document shows you how to automate StarSQL logins by including the DB2 userid and password for the data source in your registry or your file DSN.
Using the DYNAMICRULES Bind Option With StarSQL
Article # SQV00SQ034
The DYNAMICRULES Bind option can be used in situations where dynamic SQL is being used from the client application but enhanced security is required on the DB2 host.
How to Change the Read-Only Attribute of StarSQL
Article # SQV00SQ031
StarSQL data sources can be configured to be “read-only” which prevents the user from updating the database.
SSL/TLS Hints for StarSQL and StarPipes on Windows
Article # SQV00SQ064
This technical document provides details and hints regarding the SSL (Secure Sockets Layer) implementation used by StarSQL for Windows and StarPipes for Windows.
SSL/TLS Hints for StarSQL/UNIX
Article # SQV00SQ066
This technical document provides details and hints regarding the SSL (Secure Sockets Layer) implementation used by StarSQL for UNIX in conjunction with OpenSSL
 

Installation

Upgrade Considerations for StarSQL 6.1 & Later
Article # SQV00SQ058
This document describes in detail some of the differences between StarSQL 6.1 and earlier versions of StarSQL.
Binding StarSQL Packages Using StarAdmin
Article # SQV00SQ052
StarAdmin can be used to bind the host SQL packages needed to support StarSQL for Windows/Linux/UNIX and StarSQL for Java.
Binding StarSQL Packages Using StarAdmin Classic
Article # SQV00SQ007
StarAdmin Classic can be used to bind the host SQL packages needed to support StarSQL for Windows/Linux/UNIX and StarSQL for Java. In some cases, StarQuest support may recommend using StarAdmin Classic rather than StarAdmin.
StarSQL Jumbo Packages
Article # SQV00SQ068
This document describes the use of jumbo host SQL packages. These are created by StarAdmin and allow StarSQL to set the maximum active statement handle limit to 1,314 rather than the default of 64.
How to Distribute StarSQL Data Source(s) to Your Users
Article # SQV00SQ003
StarSQL ships with an administrative tool (DSIMPORT) that allows you to distribute your datasources to your users. This technical document explains how to use DSIMPORT.
Silent Installation of StarSQL
Article # SQV00SQ057
This technical note explains how to install, uninstall, and upgrade StarSQL silently without user interaction; this is useful for automating the processing of deployment on large numbers of client computers.
Creating a Custom StarSQL v5.x Installable Image
Article # SQV00SQ006
This document describes how to create and execute a silent installation that can help rapidly deploy the StarSQL v5.x driver on a large number of Windows-based client computers.
Deploying a Silent Installation of StarSQL using Microsoft Systems Management Server (SMS)
Article # SQV00SQ046
This document describes how to deploy StarSQL to a large number of desktops using Microsoft Systems Management Server (SMS) and a StarSQL silent installation package.
Linux Prerequisites for StarSQL and StarLicense
Article # SQV00SQ065
This technical document describes how to identify and install Linux prerequisites for StarSQL and StarLicense.
How to Resolve InstallShield Error 1607: Unable to Install InstallShield Scripting Run Time
Article # SQV00SQ012
This document attempts to detail all of the possible solutions that are known to resolve this error. Depending on your system, you may need to try some or all of the listed suggestions.

Troubleshooting

Error: Connection refused by remote host or Connect Host <hostname> not found
Article # SQV00SQ029
The host name specified in the StarSQL data source setup does not match the hostname of the system you are trying to connect to or TCP/IP is not started on the host.
Common StarSQL Error Messages
Article # SQV00SQ030
This document lists the most common error messages encountered while using StarSQL.
How to Generate an ODBC Trace With the ODBC Administrator
Article # SQV00SQ018
This document explains how to generate an ODBC API Trace from the ODBC Administrator.
How to Generate a DRDA Trace with the StarSQL DRDA Trace Recorder
Article # SQV00SQ017
This document explains how to generate a DRDA Trace with the StarSQL DRDA Trace Recorder.
How to Resolve StarSQL Error: "Invalid section number"
Article # SQV00SQ050
This document describes solutions for resolving the error "[StarSQL][StarSQL ODBC Driver][<DB2 Host>]Invalid section number".
Troubleshooting Tips for StarSQL for UNIX
Article # SQV00SU003
This article provides troubleshooting and configuration hints for StarSQL for UNIX, including how to use UNIX system tools to discover information about ODBC applications.

Using StarSQL with Third Party Applications

How to Use a Microsoft SQL Server Linked Server to Access DB2 with StarSQL
Article # SQV00SQ004
SQL Server linked servers can be used to access DB2 through a StarSQL ODBC data source. This document demonstrates how to add and use a linked server.
How To Use a StarSQL Data Source in a SQL Server 2005/2008/2012 SSIS Package
Article # SQV00SQ011
This document describes how to create a SQL Server 2005, 2008 or 2012 Integration Services (SSIS) package to import or export DB2 data using a StarSQL data source.
Considerations for using StarSQL (64-bit) with SQL Server 2005/2008/2012
Article # SQV00SQ048
This document addresses considerations when using StarSQL (64-bit) with SQL Server 2005/2008/2012.
Using StarSQL with ColdFusion
Article # SQV00SQ047
StarSQL can be used with ColdFusion MX 7 and ColdFusion 8 applications to access DB2 data. This document explains how to configure a data source in ColdFusion to use StarSQL and provides sample code.
Using StarSQL with the Oracle Database Gateway for ODBC
Article # SQV00SQ059
This document demonstrates how to configure and use StarSQL with the Oracle Database Gateway for ODBC (DG4ODBC) to integrate DB2 data with Oracle applications.
Using StarSQL with Informatica PowerCenter
Article # SQV00SQ060
This document describes issues that may occur when using StarSQL with Informatica PowerCenter and their solution.
Using StarSQL with IBM DataStage
Article # SQV00SQ062
This document demonstrates how to configure and use StarSQL with IBM DataStage.
Using StarSQL with Tableau
Article # SQV00SQ063
This document demonstrates how to configure and use StarSQL with Tableau
Using StarSQL with Microsoft Access FAQs
Article # SQV00SQ041
This technical document presents solutions for common problems encountered with StarSQL and Microsoft Access 2.0, 7.0 and 8.0.
How to Create a SQL Pass Through Query in Microsoft Access
Article # SQV00SQ028
This technical note explains how to create a SQL pass through query in Access 95 or Access 97.
How to Join a DB2 table and a Local Microsoft Access Table
Article # SQV00SQ039
This article describes how to join a DB2 table and a local Microsoft Access table for optimal performance.
Sample ADO Code using RecordCount property
Article # SQV00SQ038
This documents contains sample code written in Visual Basic 6.0 that demonstrates how to successfully use the RecordCount property for an ADO Resultset.
Sample ADO Code to Query DB2 Table and Return Data
Article # SQV00SQ042
This documents contains sample code written in Visual Basic 6.0 that demonstrates how to connect to your DB2 host via StarSQL using ADO and issue a SELECT against a table.
Using Visual Basic for Applications (VBA) and ADO with StarSQL
Article # SQV00SQ056
This document describes how to use the StarSQL software, Microsoft Visual Basic for Applications (VBA), and ADO to automatically populate an Excel spreadsheet with DB2 data. Similar VBA applications can be used with the other members of the Microsoft Office Suite such as Word and Access, as well as other applications that support VBA.
Sample ADO Code to Access Static SQL
Article # SQV00SQ045
This document provides sample code written in Visual Basic 6.0 that demonstrates how to access a static SQL statement embedded in a static package bound on the host.
Sample ASP Script for use with Microsoft IIS
Article # SQV00SQ043
This documents contains an ASP script that shows you how to connect to your DB2 with StarSQL.
StarSQL and IIS FAQ
Article # SQV00SQ026
This document describes solutions to the most common problems using StarSQL with Microsoft's Internet Information Server versions 3.0 and 4.0.
How to Enable ODBC Connection Pooling
Article # SQV00SQ019
This document explains how to enable and configure ODBC connection pooling for use with Microsoft Transaction Server and Internet Information Server.
StarSQL Workaround For Updating DB2 Tables with Timestamps in Microsoft Access and Visual Basic
Article # SQV00SQ027
This document discusses an update problem using StarSQL and the Microsoft’s JET database engine for DB2 timestamp data. Applications that use JET include Microsoft Access and Visual Basic (DAO).
Cognos Imprompt Returns Error when Connecting to an iSeries
Article # SQV00SQ001
The following error may occur when Cognos Imprompu attempts to connect to an AS/400 using StarSQL: [Microsoft][ODBC Driver Manager] Invalid argument value.
Using StarSQL for UNIX with unixODBC
Article # SQV00SU005
This technical document contains instructions on how to use StarSQL with the unixODBC Driver Manager.
 
Using StarSQL for UNIX with the DataDirect ODBC Driver Manager
Article # SQV00SU004
This technical document contains instructions on how to use StarSQL with the DataDirect Driver Manager.

Programming with StarSQL

Using a DSN-less Connection String with StarSQL
Article # SQV00SQ036
This technical document describes how to create a StarSQL connection to DB2 that does not use an ODBC data source name (DSN). This type of connection is known as a DSN-less connection. The use of DSN-less connections eliminates the need to create ODBC DSNs with ODBC Administrator in order to access the database server. 
Executing DB2 SQL Parameterized Stored Procedures from a Visual Basic .NET Application Using StarSQL
Article # SQV00SQ009
This document describes how to execute DB2 SQL parameterized stored procedures from a Visual Basic .NET application using the StarSQL software and the Microsoft ODBC.NET Data Provider.
Executing a DB2 Query from a Visual Basic .NET Application Using StarSQL
Article # SQV00SQ010
This document describes how to execute a DB2 query from a Visual Basic .NET application using the StarSQL software and the Microsoft ODBC.NET Data Provider.
Executing a DB2 Query from a C# .NET Application Using StarSQL
Article # SQV00SQ054
This document describes how to execute a DB2 query from a C# .NET application using the StarSQL software and the Microsoft ODBC.NET Data Provider.
Using VBScript and OLEDB with StarSQL
Article # SQV00SQ055
This document describes how to execute a DB2 query and call stored procedures from a VBScript application using the StarSQL software and the Microsoft OLEDB Provider for ODBC (MSDASQL).
Using PowerShell with StarSQL
Article # SQV00SQ067
This document describes how to execute a DB2 query and call stored procedures using PowreShell and the StarSQL software.
Using StarSQL with the Perl DBI Module
Article # SQV00SQ013
This document explains how to set up and use StarSQL and unixODBC with Perl on UNIX platforms.
Using StarSQL with PHP and php-odbc
Article # SQV00SQ014
This document explains how to set up and use StarSQL and unixODBC with Apache and PHP on UNIX.
Using StarSQL with PHP and PDO to Execute Stored Procedures
Article # SQV00SQ053
This document provides sample PHP code that illustrates how to call a stored procedure using PDO and a StarSQL data source.
Sample ADO Code to Call a Stored Procedure and Return Output Data
Article # SQV00SQ044
This document provides sample Active Server Page (ASP) code that uses ADO with StarSQL to call a stored procedure and return output parameter data.
Sending Client Information to DB2 for z/OS & DB2 LUW Using the StarSQL ODBC Driver
Article # SQV00SQ049
In 3-tier applications that access a DB2 server, client information is not automatically sent to DB2. This can pose a problem for DB2 administrators who want to monitor particular applications or to troubleshoot issues with specific DB2 threads. To solve this problem, the StarSQL ODBC driver allows an application to send additional information about the client connections.

Host Configuration Issues

How to Enable DRDA over TCP/IP for OS/400 V4R2 and later
Article # SQV00SQ020
This technical document explains how to configure your AS/400 to accept DRDA requesters, such as StarSQL, over TCP/IP.
Sample SQL for Registering a Stored Procedure on an iSeries
Article # SQV00SQ021
This document provides sample SQL used to register a stored procedure on an iSeries.
AS/400 iSeries Tuning Tips to Improve Performance when using StarSQL
Article # SQV00SQ005
This technical article offers AS/400 iSeries tuning tips to improve performance when using StarSQL.
Preventing Users from Creating Packages in DB2/400
Article # SQV00SQ023
AS/400 database administrators can control a user's ability to create packages by changing the authority on the CRTSQLPKG (Create SQL Package) object.
Creating Restricted Views in DB2 for z/OS
Article # SQV00SQ022
This document explains the requirements and steps necessary to create restricted views manually on DB2 for z/OS.
How to Return Result Set Column Names from a DB2 Stored Procedure
Article # SQV00SQ002
When calling a DB2 for OS/390 stored procedure the result set column names may not be returned to the application.
StarSQL User Requirements for Dynamic SQL Catalog Queries
Article # SQV00SQ051
To improve performance when connected to DB2 for zOS servers, StarSQL 5.36 and later executes dynamic SQL statements for catalog queries.  This behavior is different than in older versions of StarSQL (pre 5.36 versions), where static SQL located in the driver's host packages was used to perform all catalog queries. In order for StarSQL to use dynamic SQL for catalog queries, users must be granted SELECT privileges to certain catalog tables.

Internationalization

StarSQL Character Conversion and National Language Support
Article # SQV00SQ015
The document describes the format of the file that StarSQL uses to look up CCSID values and determine which character conversion routine to use for converting character data between disparate systems, and lists the CCSIDs that are currently supported by StarSQL.
Error: CCSID 500 is invalid or not supported
Article # SQV00SQ025
StarSQL users connecting to DB2 for z/OS may get error messages indicating that CCSID 500 is not valid.