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.

functions

4 posts in Objects Last posting was on 2003-08-14 20:30:59.0Z
Mike Roper Posted on 2003-04-02 17:30:45.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "Mike Roper" <mroper@rowancompanies.com>
Subject: functions
Date: Wed, 2 Apr 2003 11:30:45 -0600
Lines: 4
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
NNTP-Posting-Host: adsl-216-62-130-188.rowancompanies.com 216.62.130.188
Message-ID: <364_#S1RH3T#CHA.52@forums-1-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:7305
Article PK: 734598

Is there a size limit to a function in PB. Or a limit on comments lines or
amount.


Tyler Posted on 2003-04-02 17:38:15.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "Tyler" <NoSpamPlease_tcraft@gnb.ca>
Subject: Re: functions
Date: Wed, 2 Apr 2003 13:38:15 -0400
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 182.27.gnb.ca 142.139.182.27
Message-ID: <364_O2DnJ9T#CHA.333@forums-2-dub>
References: <364_#S1RH3T#CHA.52@forums-1-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:7306
Article PK: 734595

The limit is based on the size of the compiled PCode, not the size of the
sourcecode. Some code converts larger, some converts smaller. While most
standard system functions will convert down to a token, embedded SQL is
stored byte-for-byte (which is why you can read it in a PBD, but not much
else). So if you are reaching this limit try and put your embedded SQL into
a UserObject Function. It is really best if you try and ckeep each function
down to a page or two though just for readablity.

Tyler

"Mike Roper" <mroper@rowancompanies.com> wrote in message
news:#S1RH3T#CHA.52@forums-1-dub...
> Is there a size limit to a function in PB. Or a limit on comments lines
or
> amount.
>
>


Christine Posted on 2003-04-22 05:42:59.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: Christine
Date: Tue, 22 Apr 2003 01:42:59 -0400
Subject: Re: window functions
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <364_FDDF3C9A859A2838001F66BA85256D10.0036BDF485256D0C@webforums>
References: <364_#S1RH3T#CHA.52@forums-1-dub> <364_O2DnJ9T#CHA.333@forums-2-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.powerbuilder.objects:7345
Article PK: 734635

Does anyone know if there is a limit as to how many window functions I can
place in one object? This is in PB 7.0.3 with no embedded sql.

Thanks-
Chris


Michael Skinner Posted on 2003-08-14 20:30:59.0Z
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: window functions
Reply-To: michael_b_skinner@yahoo.com
References: <364_#S1RH3T#CHA.52@forums-1-dub> <364_O2DnJ9T#CHA.333@forums-2-dub> <364_FDDF3C9A859A2838001F66BA85256D10.0036BDF485256D0C@webforums>
Message-ID: <oprtwwksy3i8hoxe@localhost>
Content-Type: text/plain; charset=iso-8859-15; format=flowed
From: Michael Skinner <michael_b_skinner@yahoo.com>
MIME-Version: 1.0
User-Agent: Opera7.11/Win32 M2 build 2887
NNTP-Posting-Host: pool-151-199-23-174.bos.east.verizon.net
X-Original-NNTP-Posting-Host: pool-151-199-23-174.bos.east.verizon.net
Date: 14 Aug 2003 13:30:59 -0700
X-Trace: forums-1-dub 1060893059 151.199.23.174 (14 Aug 2003 13:30:59 -0700)
X-Original-Trace: 14 Aug 2003 13:30:59 -0700, pool-151-199-23-174.bos.east.verizon.net
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7550
Article PK: 734837

If you have a function that big, it most likely needs to be broken down
into smaller bit size pieces.

On Tue, 22 Apr 2003 01:42:59 -0400, <Christine> wrote:

> Does anyone know if there is a limit as to how many window functions I
> can place in one object? This is in PB 7.0.3 with no embedded sql.
>
> Thanks-
> Chris
>