Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

What is SQL's max length ?

3 posts in PB Infomaker Report Writer Last posting was on 1999-07-12 19:33:13.0Z
Robert Posted on 1999-06-29 19:56:27.0Z
Newsgroups: sybase.public.infomaker.general
From: "Robert" <computer.design.company@wxs.nl>
Subject: What is SQL's max length ?
Date: Tue, 29 Jun 1999 21:56:27 +0200
Lines: 45
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0071_01BEC27A.3CA07560"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <348_aGRa1imw#GA.267@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6146
Article PK: 240083

Can anyone tell me what the maximum length is for an SQL coupled to a Infomaker 5.0 report.
(I keep on getting Memory error messages when exceeding the 1300 lines)
or is there a simpler way to build an even longer SQL routine (I need +/- 2500 lines to get a INtools Junction Box report working)
 
Thanks in advance,
 


Terry Dykstra Posted on 1999-06-29 20:25:30.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: What is SQL's max length ?
Date: Tue, 29 Jun 1999 14:25:30 -0600
Lines: 78
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_000D_01BEC23B.3DB0AB80"
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <348_77GeR0mw#GA.75@forums.sybase.com>
References: <348_aGRa1imw#GA.267@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6145
Article PK: 240081

Yikes!  I don't know what the limit is, but it sure doesn't sound healthy to have a SQL statement that long.  Your DBMS may choke on that one too.
Try using stored procedures or use nested reports.  Or try using views to break down the SQL in manageable chunks.

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Robert wrote in message ...
Can anyone tell me what the maximum length is for an SQL coupled to a Infomaker 5.0 report.
(I keep on getting Memory error messages when exceeding the 1300 lines)
or is there a simpler way to build an even longer SQL routine (I need +/- 2500 lines to get a INtools Junction Box report working)
 
Thanks in advance,
 


Terry Dykstra Posted on 1999-07-12 19:33:13.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: What is SQL's max length ?
Date: Mon, 12 Jul 1999 13:33:13 -0600
Lines: 97
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0013_01BECC6B.173886A0"
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <348_iv9n$yJz#GA.83@forums.sybase.com>
References: <348_aGRa1imw#GA.267@forums.sybase.com> <348_77GeR0mw#GA.75@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6109
Article PK: 240046

I just found out that in IM7 you can supposedly have scripts over 64K in length.

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Terry Dykstra wrote in message <77GeR0mw#GA.75@forums.sybase.com>...
Yikes!  I don't know what the limit is, but it sure doesn't sound healthy to have a SQL statement that long.  Your DBMS may choke on that one too.
Try using stored procedures or use nested reports.  Or try using views to break down the SQL in manageable chunks.

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Robert wrote in message ...
Can anyone tell me what the maximum length is for an SQL coupled to a Infomaker 5.0 report.
(I keep on getting Memory error messages when exceeding the 1300 lines)
or is there a simpler way to build an even longer SQL routine (I need +/- 2500 lines to get a INtools Junction Box report working)
 
Thanks in advance,