Switch to standard view 
  Sybase logo
 
 
 



Summary

The following sample programs demonstrate features of Client-Library and can be used as models for your own programs.

Contents

This document contains the following sections:

Open Client and Open Server Program Disclaimer

The Open Client and Open Server applications contained in this download are intended to provide help and ideas for working with Sybase connectivity libraries.

Please read this disclaimer before using the code:

THIS CODE IS BEING DISTRIBUTED FREE OF CHARGE. IT IS NOT A SYBASE PRODUCT, IS NOT SUPPORTED BY SYBASE AND IS PROVIDED “AS-IS” WITHOUT WARRANTY OF ANY KIND. SYBASE DISCLAIMS ALL WARRANTIES OR CONDITIONS, EITHER EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION ANY IMPLIED WARRANTIES OF MERCHANTABILITY, MERCHANTABLE QUALITY, NONINFRINGEMENT AND FITNESS FOR A PARTICULAR PURPOSE (WHETHER ARISING BY STATUTE OR IN LAW OR AS A RESULT OF A COURSE OF DEALING OR USAGE OF TRADE). IN NO EVENT SHALL SYBASE BE LIABLE FOR LOSS OF PROFITS OR LOSS OF DATA OR ANY DAMAGES WHATSOEVER INCLUDING WITHOUT LIMITATION DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL OR SPECIAL DAMAGES, EVEN IF SYBASE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

Download the Samples

The download contains all the program, header, and datafiles, as well as a sample makefile for Unix platforms. Create a directory for the samples and associated files, and download the compressed file for your platform:

Expand the download using the WinZip or tar utility.

List of Programs

The following general information applies to the sample programs listed below:

This table contains a list of all the Client-Library programs in this download and a brief description of what each program does. A Unix makefile and a header file for these programs are included in the download:

Program name

Description

Other files

t-handlers.c

Error handling code for these sample programs. Contains the error callback routines.

array_bind.c

Uses Bulk-Library to copy in multiple rows at a time. This method has been proven to improve performance.

array_bind.sql

bulkcopy.c

Uses Bulk-Library calls to insert rows into a table one at a time.

bulkcopy.sql

cursor_sel.c

Uses client side cursors to retrieve data from a table. Also shows how to use input parameters with cursors.

cursor_upd.c

An enhancement of the previous program. This program retrieves rows and updates them one at a time.

cursor_upd.sql

cursor_proc.c

Uses cursors to execute a stored procedure with parameters.

cursor_proc.sql

debug_sample.c

Shows how to make calls to ct_debug and set various flags for debugging. You have to modify the makefile to link in the required devlibs.

diag_example.c

Illustrates the use of inline error handling using ct_diag.

dynamic_cur.c

Uses Dynamic SQL with cursors to retrieve data with varying input values.

dynamic_ins.c

Uses Dynamic SQL to accept input values for an insert multiple times.

dynamic_ins.sql

params.c

Shows how to use ct_command with variable substitution using ct_param.

rpc.c

Uses RPC calls to execute a stored procedure with input and output parameters.

rpc.sql

time_out.c

Shows how to handle timeout situations.

time_out.readme

timeout_handler.c

Contains standard error handling routines as well as specific code to handle timeout errors.

mult_text.c

Updates multiple text columns in a table.

mult_text.sql

locales.c

Uses the CS_LOCALE structure to specify a date format to use for data retrieval.

example.h

Required header file for these sample programs.

makefile

Unix makefile for these sample programs.



Back to Top
© Copyright 2010, Sybase Inc.