by Jason L Froebe on April 23, 2013, no comments
I needed to copy the permissions from one database to another but the sp__helprotect stored procedure in Ed Barlow’s Extended System Stored Procedure Library for Sybase and Sql Server wasn’t producing output with “GRANT” and “REVOKE”. It also had problems with DBCC privileges. Here you go: sp__helprotect.sql /* Procedure copyright(c) 1995 by Edward M Barlow [...]
by Jason L Froebe on March 10, 2013, 2 comments
You can run KVM on just about any modern Linux distribution provided that your host is capable of providing virtualization. The folks over at HowtoForge go through the steps for Ubuntu 12.10. What you will need for the KVM virtual machine: Ubuntu Server 6.06.2 for Intel x86 Sybase SQL Server 11.0.3.3 esd 6 for Linux [...]
by Jason L Froebe on February 21, 2013, no comments
Installing Sybase OpenClient 15.7 or higher on *nix with setup.bin and don’t have X-Windows available, you will need to start the setup.bin with: ./setup.bin -i console If you want to install just OpenClient or some other thing, the problem comes with the poorly worded “Choose Product Features”: ENTER A COMMA_SEPARATED LIST OF NUMBERS REPRESENTING THE [...]
by Jason L Froebe on February 17, 2013, 10 comments
Assuming that you installed Sybase SDK OpenClient 15.7. Sybase Openclient is included in the Sybase Developer’s Kit, and ASE PC Client. If you don’t have a license, you can download the ASE 15.7 Developer Edition for Windows which will include it. Install ActiveState Perl from http://www.activestate.com (free) and install DBI if it isn’t already installed. [...]
by Jason L Froebe on February 15, 2013, no comments
The most intuitive way to write a comparison of two tables and spit out the # of rows that are the same involves a left join: select ‘Investment’ as TableName, count(*) as RowCount from Investment_A a, Investment_B b where a.col1 = b.col1 AND a.col2 = b.col2 AND a.col3 = b.col3 AND a.col4 = b.col4 This [...]