Welcome to the ACS Sybase Archive!
For Files, Tools, Frequently Asked Questions and a mirror of the Sybase FTP site, please visit our anonymous FTP server. NCSU Sybase Licensees can also find EBF's there as well. For information on obtaining EBF's for your department, please contact Lou Williams
A HyperText version of the FAQ for comp.databases.sybase is A plaintext version is also available here. The FAQ maintainer is David Pledger (davidp@meaddata.com). We also have the latest version of the Web.SQL Frequently Asked Questions.
sqlredirect is a Sybase Open Server RPC that executes an SQL query on a given dataserver and stores the resulting table on another dataserver. It behaves as sort of a "select into" where the target table exists on a remote dataserver. It does not allow for anything fancy like joins across multiple dataservers.
SQL-ftpd is a SQL ftp server daemon allowing ftp access into a Sybase SQL server. By using a simple ftp client and the ftp protocol, users can connect to a Sybase SQL server, list databases, "cd" (use) to a database, and retrieve data with short SQL statements, storing the data into a file on their local system.
Using the openserver libraries we have implemented a sort of poor-man's NIS for coordinating userids and passwords on our SQL servers. When changing your password you use sp_acs_password instead of sp_password, and your password will be changed on all of the ACS servers accessable by you.
There are a few stored procedures available to make operations a little easier on the ACS SQL Servers. Most of these are very simple allowing you to do things like look a little closer at processes on the server, get sorted listings of procedures, views, tables, triggers, etc, showing space used by a given segment and all of the objects on that segment.
ACS built and maintains an automated update system which is used to transfer data from our mainframe and build Sybase tables used for Query and Reporting tools such as Q+E. Jobs written on the mainframe extract the data and build files which are then sent to our update system, where they are automatically loaded. For more information on using the update system or to check the status of existing extract loads, select the link above.
Guidelines and examples which define the style and prerequisites for stored procedures to be accepted into the ACS production environment.
Sybperl is a set of user-defined subroutines letting you access a Sybase dataserver using Perl. It was written by Michael Peppler (mpeppler@itf.ch) and is available from ftp.acs.ncsu.edu .
Dsql is a reimplementation of Sybase's isql. It uses the GNU readline library for tcsh-like query editing. See the dsql README for more information.
Dsql was written by David Joyner (nsysdbj@acs.ncsu.edu). Click here to download the latest version. The GNU readline library is available from Project GNU.
Xsybmon is an X/Motif based Sybase dataserver monitoring tool. It works with both X11R4 and X11R5, but you must have both Motif and Athena widget libraries on-hand before you can build this tool. For more information, see the xsybmon README. You may want to check out this screen capture of xsybmon before you download the package.
Xsybmon was written by David Joyner (nsysdbj@acs.ncsu.edu). Lou Williams (nsyslaw@acs.ncsu.edu) also made modifications to add data logging capabilities. Click here to download the latest version.
Sybstat is a dataserver monitoring tool based on xsybmon. Unlike xsybmon, it does not require X11 or Motif. Its output is reminiscent of the UNIX utilities vmstat and iostat. Sybstat was written by Dean Bennett (deanb@sa-cgy.valmet.com). Click here to download the latest version.
Back to the NCSU Home Page
