On Mon, 2004-05-17 at 22:47, v79k wrote:
> Hi,
> I am using Perl on Linux to access stored procedure on
> SQL Server, using FreeTDS+DBD::Sybase
>
> My SP accepts a parameter in date format(mm/dd/yyyy)
> and returns the data(2 columns {string,rowcount}).
> Also
> I want to know if the number of rows is 0. So if we
> have 0 rows we still return 1 row with cloumn 1 as ""
> and
> column 2 as 0
That's most likely the "return status" of the stored proc, which is
returned last, and is a separate result set.
> +----------------------------------+-------------------------------+
> | ddddeeddd |
> 193| Row 193
> +----------------------------------+-------------------------------+
>
> For example 1 on certain occassions for column 1, I am
> getting only
> part of column 1 like dddde.
>
> Is there a limit of 256 bytes for FreeTDS?
You got an answer on this on the freetds mailing list - essentially it
depends on the TDS protocol version that is being used.
> Column 1 is
> basically tab limited data.
> Will breaking into individual columns help?
In general this would be a good idea, and not because the query would
(possibly) work better, but from a db design point of vue.
Michael
--
Michael Peppler Data Migrations, Inc.
[EMAIL PROTECTED] http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html
