freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS

From: Michael Peppler <mpeppler AT peppler.org>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Subject: Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS
Date: Fri, 2 Jun 2000 14:50:26 -0700 (PDT)

camber AT ais.org writes:
>
>
> On Fri, 2 Jun 2000 tetherow AT nol.org wrote:
>
> > On 2 Jun, James Cameron wrote:
> > > Is it possible to read the stored procedure via FreeTDS?
> >
> > I would really like to hear the answer to this one.
> >
> Actually look in the syscomments system table. Under sybase you would run
> 'defncopy' but I haven't seen a good freeware version of it anywhere.

sp_helptext (or Ed Barlow's sp__helptext) work pretty well.

Also - see dbschema.pl on www.midsommer.org.

Michael
--
Michael Peppler -||- Data Migrations Inc.
mpeppler AT peppler.org -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: ase-linux-list AT isug.com

Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS, James Cameron, 06/02/2000
- <Possible follow-up(s)>
- Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS, camber, 06/02/2000
- Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS, tetherow, 06/02/2000
- Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS, camber, 06/02/2000
- Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS, Michael Peppler, 06/02/2000
- Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS, Sam Sam, 06/02/2000
- Re: Chop CHAR_P to 4096 bytes? PHP to MSSQL via FreeTDS, James Cameron, 06/04/2000