StarSQL Technical Documents
Quick Start Guides | FAQs | StarSQL for Java | StarSQL General
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 FAQs
- Article # SQV00SQ033
The following 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.
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's 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 ColdFusion
- Article # SQV00SJ006
StarSQL for Java 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 for Java and provides sample code.
General StarSQL Technical Documents
- 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. - StarSQL User Requirements for Dynamic SQL Catalog Queries
- Article # SQV00SQ051
To improve performance when connected to DB2/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. - 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". - Sending Client Information to DB2 for z/OS & DB2 UDB 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. - Considerations for using StarSQL (64-bit) with SQL Server 2005/2008
- Article # SQV00SQ048
This document addresses considerations when using StarSQL (64-bit) with SQL Server 2005/2008. - 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. - 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. - Creating a Custom StarSQL Installable Image
- Article # SQV00SQ006
This document describes how to create and execute a silent installation that can help rapidly deploy the StarSQL driver on a large number of Windows-based client computers. - 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 Pro, over TCP/IP. - 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. - 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. - 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.
- How To Use a StarSQL Data Source in a SQL Server 2005/2008 SSIS Package
- Article # SQV00SQ011
This document describes how to create a SQL Server 2005 or 2008 Integration Services (SSIS) package to import or export DB2 data using a StarSQL data source.
- 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. - 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. - 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. - Calling an AS/400 Program with QCMDEXC
- Article # SQV00SQ040
You can execute a program on the AS/400 using the program QCMDEXC. - 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. - 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. - 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. - 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. - Error: CCSID 500 is invalid or not supported
- Article # SQV00SQ025
StarSQL users connecting to DB2 for OS/390 (DB2/MVS) may get error messages indicating that CCSID 500 is not valid. - 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. - 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. - Sample Visual Basic Code For a DSN-less Connection with StarSQL
- Article # SQV00SQ036
You can connect to your database using a DSN-less connection with VB 5.0 (RDO) and the sample code in this document. - 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 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. - 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 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. - 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. - 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. - Creating Restricted Views in DB2/MVS
- Article # SQV00SQ022
This document explains the requirements and steps necessary to create restricted views manually on DB2/MVS. - 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. - 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. - 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. - 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. - 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 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. - 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). - Common StarSQL Error Messages
- Article # SQV00SQ030
This document lists the most common error messages encountered while using StarSQL.