From: tpoindex@nyx.cs.du.edu (Tom Poindexter)
Subject: New release of Sybtcl: Sybase interface commands for TCL
Summary: barkley.berkeley.edu:/tcl/extensions/sybtcl-1.1.tar.Z
Keywords: Sybase ISQL TCL 
Organization: Nyx, Public Access Unix @ U. of Denver Math/CS dept.
Date: Mon, 31 Aug 92 15:46:12 GMT



I've just uploaded an update to my Sybtcl package to barkley.berkeley.edu.
It should appear as /tcl/extensions/sybtcl-1.1.tar.Z shortly.

Major additions to the code include the ability to read/write to 
Sybase TEXT and IMAGE datatypes.  I've also fiddled with the 
Windowing ISQL program - it does a few more tricks.  

Has anyone used Sybtcl yet?  I haven't received any mail regarding Sybtcl
since I released the first version.  Please drop me a note if you're 
using Sybtcl, and any comments.  (Craig - I lost your email address;
how's your package coming?)

Here's the README from the distribution:

Enjoy!

Tom Poindexter
tpoindex@nyx.cs.du.edu

-----------------------------------------------------------------------------

Sybtcl -  Tcl interface to Sybase database server


 *
 * Copyright 1992 Tom Poindexter and U S WEST Enhanced Services, Inc.
 *
 * Permission to use, copy, modify, and distribute this software and its
 * documentation for any purpose and without fee is hereby granted, provided
 * that the above copyright notice appear in all copies.  
 * Tom Poindexter and U S WEST make no representations about the suitability 
 * of this software for any purpose.  It is provided "as is" without express or
 * implied warranty.  By use of this software the user agrees to 
 * indemnify and hold harmless Tom Poindexter and U S WEST from any 
 * claims or liability for loss arising out of such use.
 *
 *-----------------------------------------------------------------------
 * Version 1.1 August, 1992
 * Tom Poindexter, Denver Colorado
 * tpoindex@nyx.cs.du.edu   
 *


WHAT IS SYBTCL?

Sybtcl is an extension to Tool Command Language (Tcl) that provides access
to a Sybase Database server.  Sybtcl adds additional Tcl commands that 
login to a SQL Server, pass SQL code, read results, etc.  Sybtcl was inspired
by similar tools written for Perl (sybperl, oraperl) but was written from
scratch instead of borrowing on the work of either Perl extension.

Sybtcl features:
  -supports multiple connections to the same or different SQL Servers
  -provides "nextrow" processing for regular and compute return rows
  -converts results to strings and returns rows as Tcl lists
  -allows user defined null values to be returned
  -stored procedures can be executed and return values accessed
  -accesses column names, lengths, and datatypes of rows & return values
  -provides feedback of SQL Server and DB-Lib messages
  -reads/writes text or image datatypes to files


Sybtcl does not:
  -perform row buffering or browse mode
  -bulk copies
  -support two phase commit on multiple servers
  


ACKNOWLEDGEMENTS

	John Ousterhout (ouster@sprite.berkeley.edu) for Tcl and Tk -
	    wonderful software in my opinion.

	Karl Lehenbauer (karl@NeoSoft.com) and 
	    Mark Diekhans (markd@Grizzly.com) for Extended Tcl -
	    more good stuff.

	Michael Peppler (mpeppler@itf0.itf.ch) for sybperl, which gave me
	    the inspiration to write sybtcl.  

	    ("I tried Perl, but never inhaled." - Tom Poindexter)


REQUIREMENTS

Since sybtcl is an extension to Tcl, you should already have Tcl, or be
prepared to get it via Ftp [sites listed below].

Of course, you must also have access to a Sybase Databaser Server.  
Additionally, you must have the Sybase Open Client (aka "DB-Library") package 
that provides header files and object libraries;  sybtcl must be linked 
with libsybdb.a.

I normally build sybtcl with Tcl, Extended Tcl, and the X11 Tk widget set
yielding tcl and wish interpreters.  Sybtcl is written with no dependencies
other than Tcl, so it should be possible to link it with the the minimal Tcl
library.  (Although sybtcl uses "handles", I didn't rely on the handle 
functions provided by Extended Tcl.)
In practice, I have only built sybtcl with Extended Tcl and Tk.


The specific software versions I used:

	Tcl - 6.4              available on sprite.berkeley.edu
	Tk  - 2.2                  "     "    "       "      "
	Extended Tcl - 6.2b        "     "  barkley.berkeley.edu
	  (with patches for Tk 2.0)
	Sybase Open Client - 4.6    $$$    from Sybase 
	Sybase SQL Server - 4.8 SMP $$$$$$ from Sybase 

>>>>>>>	I've put sybtcl-1.1.tar.Z on barkley.berkeley.edu as well.

	see the newsgroup comp.lang.tcl for general Tcl discussion and
	the Tcl Frequently Asked Questions.

I've built sybtcl in a System V 3.2 environment (Sequent PTX 1.3); I 
don't think that there are any SysV vs BSD dependencies in the code.


SAMPLES

Some samples are included using the Extended Tcl tcl(1) and wish(1)
interpreters.    In particular, the "wisql" (Windowing ISQL) program 
is a handy replacement for Sybase's Isql in an X11 environment.

See ./samples/README.samples plus each file's comments and code.


MAN PAGE

You're in luck! I've written one.


BUG REPORTS

Comments, suggestions, et.al., should be mailed to me at the above email
address, or posted to comp.lang.tcl if general enough nature.  
Hell, you can even mail to me if you like sybtcl!
(If you mailed a bug report to me and I didn't reply, I didn't get your
email or your return address didn't make sense to my mailer - I always
reply to non-flames.)


INSTALLATION

See the file INSTALL.


OTHER

See the file CHANGES for changes in versions of sybtcl

-finis-

--
--
set signature {{Tom Poindexter} {tpoindex@nyx.cs.du.edu} {pithy quote}}