Re[2]: how long is long?

[John Kellogg <johnk@SUN4.MITI.COM>]

     The current maximum for the LONGSPACE value in the new V4 manual is
     32K-2. The 64K limit in previous documentation was incorrect.

     John L. Kellogg
     MITI Technical Support Manager

______________________________ Reply Separator _________________________________
Subject: Re: how long is long?
Author:  SQR-USERS@usa.net at Internet
Date:    06/09/96 5:31 AM


> I'm using SQR V3.5 on a windows95 client w/Oracle on an SGI.
>
> I'm trying to retreive a long data type in a report that is
> truely long.  SQR seems to truncate the long field after about
> 13 pages text.  Is it possible to extend this?  Suggested
> tricks to get around it?
>
> Thanks in advance.
>
> Bob

Using the -M command line argument, you can specify a
different maximum for the LONGSPACE parameter.  For example,
you might create a file called my_prog.sqm with the line

LONGSPACE=65535

and use the command line

sqr my_prog usr/pwd -Mmy_prog.sqm

to invoke the program using the file.

The default value for LONGSPACE is 13515, which I would expect
to be about 3 pages of text, so you may already be using a larger
LONGSPACE value.  I don't know what happens if you try to use
a value greater than 64K.  I'm not sure if $ variables can handle
values that large.

Are you trying to print long text, up to 64K?  If so, you should
be OK.  If not, there are some things you can do using C and
ufuncs that I'd be happy to chat about.

Good luck.

Ray
----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  "Ask me about Forte Software"
rayo@ontko.com  |  Richmond, In    |  See us at http://www.ontko.com/