ASQL Reference

General Information

Using This Document

CHM Files

A-Shell Doc Overview

Available Docs

Organization

File Types

Updates

Locations

Feedback

Introduction

Getting Started

SQL.SBR

Typical database session

Listing of Opcodes and Operations

Opcodes

SQLOP_INIT_LIB

SQLOP_CLOSE_LIB

SQLOP_GET_ERRMSG

SQLOP_INIT_CONN

SQLOP_CONNECT

SQLOP_DISCONNECT

SQLOP_GET_INFO

SQLOP_QUERY

SQLOP_GET_COLDEFS

SQLOP_SET_COLDEFS

SQLOP_FETCH_ROW

SQLOP_FREE_RESULT

SQLOP_GET_CONNATR

SQLOP_SET_CONNATR

SQLOP_GET_STMATR

SQLOP_SET_STMATR

SQLOP_DATA_SOURCES

Appendices

Installing A-Shell/SQL

Installing MySQL

Installing SQL Server

Installing ODBC

Defining ODBC Data Sources

Sample Programs, Headers, Utilities

Selected Database Topics

Cursors and Cursor Types

Cursor Concurrency

DBMS Connector ID

Error codes

SQL Field Types and Flags

MySQL Protocol Types

MySQL Connection Flags

SQL Project Overview

Troubleshooting

Release Notes

Version 1.2 - 12 April 2009

Version 1.1 - 5 April 2009

Version 1.0 - 11 March 2009