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.

sp to get syscomments text

17 posts in Product Futures Discussion Last posting was on 2003-07-27 11:04:43.0Z
putnamr Posted on 2003-03-11 15:55:54.0Z
From: putnamr@river.it.gvsu.edu
Date: Tue, 11 Mar 2003 10:55:54 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: sp to get syscomments text
Message-ID: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums>
Lines: 116
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1004
Article PK: 95242

Hello,

Here is a stored procedure that orders syscomments text into its readable
or inputted format. Works with ASE 12.5. Let me know if anyone has any
issues. Thanks.

CREATE PROCEDURE sp_get_txt
@OWNER VARCHAR(32),
@OBJNAME VARCHAR(32)
AS
BEGIN

-- Author: Ryan Putnam
-- Intent: Generate Text FROM SYSCOMMENTS

SET NOCOUNT ON

DECLARE @ONECHAR CHAR(1)
DECLARE @TEXTVAL VARCHAR(255)
DECLARE @TEXTSTRING VARCHAR(16384)
DECLARE @LOOPCNT INT
DECLARE @COLID INT
DECLARE @MAXCOLID INT
DECLARE @OBJID INT
DECLARE @COLID2 INT

SELECT @COLID = 1
SELECT @ONECHAR = NULL
SELECT @TEXTVAL = NULL
SELECT @TEXTSTRING = NULL
SELECT @OBJID = NULL
SELECT @MAXCOLID = 0

SELECT @OBJID = C.id
FROM syscomments C
, sysobjects O
WHERE C.id=O.id
AND O.name = @OBJNAME
AND O.uid = USER_ID(@OWNER)

DECLARE process_colid2_cursor CURSOR
FOR
SELECT C.colid2, MAX(C.colid)
FROM syscomments C
WHERE C.id = @OBJID
GROUP
BY C.colid2
ORDER
BY C.colid2 ASC
FOR READ ONLY

OPEN process_colid2_cursor

FETCH process_colid2_cursor INTO @COLID2, @MAXCOLID

WHILE @@SQLSTATUS = 0
BEGIN
ROUTINE:
SELECT @ONECHAR = NULL
SELECT @TEXTVAL = NULL
SELECT @LOOPCNT = 1

SELECT @TEXTVAL = C.text
FROM syscomments C
WHERE C.id=@OBJID
AND C.colid = @COLID
AND C.colid2 = @COLID2

IF @COLID = 1 AND SUBSTRING(@TEXTVAL, 1, 1) = CHAR(10)
BEGIN
SELECT @TEXTVAL=SUBSTRING(@TEXTVAL, 2, CHAR_LENGTH(@TEXTVAL) - 1)
END

WHILE @LOOPCNT < 256 AND @COLID <= @MAXCOLID
BEGIN
SELECT @ONECHAR = SUBSTRING(@TEXTVAL, @LOOPCNT, 1)
SELECT @TEXTSTRING = @TEXTSTRING + SUBSTRING(@TEXTVAL, @LOOPCNT,
1)

IF @ONECHAR = CHAR(10) AND ASCII(@TEXTSTRING) > 0
BEGIN
PRINT "%1!", @TEXTSTRING
SELECT @TEXTSTRING = NULL
END

IF (@ONECHAR != CHAR(10)) AND @LOOPCNT >= 254 AND @COLID <
@MAXCOLID
BEGIN
SELECT @LOOPCNT = @LOOPCNT + 1
SELECT @ONECHAR = SUBSTRING(@TEXTVAL, @LOOPCNT, 1)
SELECT @TEXTSTRING = @TEXTSTRING + SUBSTRING(@TEXTVAL,
@LOOPCNT, 1)
SELECT @COLID = @COLID + 1
GOTO ROUTINE
END
ELSE IF @LOOPCNT >= 255 AND @COLID < @MAXCOLID
BEGIN
SELECT @COLID = @COLID + 1
GOTO ROUTINE
END
ELSE IF @LOOPCNT >= 16384 AND @COLID >= @MAXCOLID AND
ASCII(@TEXTSTRING) > 0
BEGIN
PRINT "%1!", @TEXTSTRING
SELECT @TEXTSTRING = NULL
END

SELECT @LOOPCNT = @LOOPCNT + 1
END

FETCH process_colid2_cursor INTO @COLID2, @MAXCOLID
END

CLOSE process_colid2_cursor
DEALLOCATE CURSOR process_colid2_cursor

END
go


putnamr Posted on 2003-03-11 16:57:48.0Z
From: putnamr@river.it.gvsu.edu
Date: Tue, 11 Mar 2003 11:57:48 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: sp to get syscomments text
Message-ID: <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums>
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums>
Lines: 116
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1006
Article PK: 95243

put in a fix at end of proc.

CREATE PROCEDURE sp_get_txt
@OWNER VARCHAR(32),
@OBJNAME VARCHAR(32)
AS
BEGIN

-- Author: Ryan Putnam
-- Intent: Generate Text FROM SYSCOMMENTS

SET NOCOUNT ON

DECLARE @ONECHAR CHAR(1)
DECLARE @TEXTVAL VARCHAR(255)
DECLARE @TEXTSTRING VARCHAR(16384)
DECLARE @LOOPCNT INT
DECLARE @COLID INT
DECLARE @MAXCOLID INT
DECLARE @OBJID INT
DECLARE @COLID2 INT

SELECT @COLID = 1
SELECT @ONECHAR = NULL
SELECT @TEXTVAL = NULL
SELECT @TEXTSTRING = NULL
SELECT @OBJID = NULL
SELECT @MAXCOLID = 0

SELECT @OBJID = C.id
FROM syscomments C
, sysobjects O
WHERE C.id=O.id
AND O.name = @OBJNAME
AND O.uid = USER_ID(@OWNER)

DECLARE process_colid2_cursor CURSOR
FOR
SELECT C.colid2, MAX(C.colid)
FROM syscomments C
WHERE C.id = @OBJID
GROUP
BY C.colid2
ORDER
BY C.colid2 ASC
FOR READ ONLY

OPEN process_colid2_cursor

FETCH process_colid2_cursor INTO @COLID2, @MAXCOLID

WHILE @@SQLSTATUS = 0
BEGIN
ROUTINE:
SELECT @ONECHAR = NULL
SELECT @TEXTVAL = NULL
SELECT @LOOPCNT = 1

SELECT @TEXTVAL = C.text
FROM syscomments C
WHERE C.id=@OBJID
AND C.colid = @COLID
AND C.colid2 = @COLID2

IF @COLID = 1 AND SUBSTRING(@TEXTVAL, 1, 1) = CHAR(10)
BEGIN
SELECT @TEXTVAL=SUBSTRING(@TEXTVAL, 2, CHAR_LENGTH(@TEXTVAL) - 1)
END

WHILE @LOOPCNT < 256 AND @COLID <= @MAXCOLID
BEGIN
SELECT @ONECHAR = SUBSTRING(@TEXTVAL, @LOOPCNT, 1)
SELECT @TEXTSTRING = @TEXTSTRING + SUBSTRING(@TEXTVAL, @LOOPCNT,
1)

IF @ONECHAR = CHAR(10) AND ASCII(@TEXTSTRING) > 0
BEGIN
PRINT "%1!", @TEXTSTRING
SELECT @TEXTSTRING = NULL
END

IF (@ONECHAR != CHAR(10)) AND @LOOPCNT >= 254 AND @COLID <
@MAXCOLID
BEGIN
SELECT @LOOPCNT = @LOOPCNT + 1
SELECT @ONECHAR = SUBSTRING(@TEXTVAL, @LOOPCNT, 1)
SELECT @TEXTSTRING = @TEXTSTRING + SUBSTRING(@TEXTVAL,
@LOOPCNT, 1)
SELECT @COLID = @COLID + 1
GOTO ROUTINE
END
ELSE IF @LOOPCNT >= 255 AND @COLID < @MAXCOLID
BEGIN
SELECT @COLID = @COLID + 1
GOTO ROUTINE
END
ELSE IF @LOOPCNT >= 16384 AND @COLID >= @MAXCOLID AND
ASCII(@TEXTSTRING) > 0
BEGIN
PRINT "%1!", @TEXTSTRING
SELECT @TEXTSTRING = NULL
END

SELECT @LOOPCNT = @LOOPCNT + 1
END

FETCH process_colid2_cursor INTO @COLID2, @MAXCOLID
END

IF @LOOPCNT < 16384 AND @ONECHAR != CHAR(10) AND ASCII(@TEXTSTRING) > 0
BEGIN
PRINT "%1!", @TEXTSTRING
END

CLOSE process_colid2_cursor
DEALLOCATE CURSOR process_colid2_cursor

END
go


putnamr Posted on 2003-03-11 18:14:30.0Z
From: putnamr@river.it.gvsu.edu
Date: Tue, 11 Mar 2003 13:14:30 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: sp to get syscomments text
Message-ID: <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums>
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums>
Lines: 2
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1019
Article PK: 95259

Actually I have found this to work better than defncopy because defncopy is
putting in extra spaces on long stored proecedures, views, and triggers.


Pablo Sanchez Posted on 2003-03-11 18:54:28.0Z
Subject: Re: sp to get syscomments text
From: Pablo Sanchez <pablo@dev.null>
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums>
Organization: High-Performance Database Engineering
Message-ID: <Xns933B75AD82854pingottpingottbah@199.93.177.77>
User-Agent: Xnews/06.01.10
Newsgroups: sybase.public.ase.product_futures_discussion
Date: Tue, 11 Mar 2003 13:54:28 -0500
Lines: 16
NNTP-Posting-Host: host-4-069.ionsky.com 66.35.44.69
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1018
Article PK: 95258

putnamr@river.it.gvsu.edu wrote in
news:45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums:

> Actually I have found this to work better than defncopy because
> defncopy is putting in extra spaces on long stored proecedures,
> views, and triggers.

Always exceedingly annoying.

I was wondering, not wanting to lose gems, do we want to create a
separate NG within Sybase for contributed software or are you okay
with submitting it to the Sybase FAQ? David Owen is The Man for the
FAQ.

Thoughts?
--
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com


putnamr Posted on 2003-03-11 19:34:27.0Z
From: putnamr@river.it.gvsu.edu
Date: Tue, 11 Mar 2003 14:34:27 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: sp to get syscomments text
Message-ID: <D7B3EFB4B2284C2D006B862485256CE6.006A4BCC85256CE6@webforums>
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums> <Xns933B75AD82854pingottpingottbah@199.93.177.77>
Lines: 6
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1017
Article PK: 95256

Hello,

I do have a lot of code that I would like to make available and I
definately do not want to tie up this NG if this the wrong place to put it.

I would like to just put it here if I may.


Pablo Sanchez Posted on 2003-03-11 19:52:58.0Z
Subject: Re: sp to get syscomments text
From: Pablo Sanchez <pablo@dev.null>
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums> <Xns933B75AD82854pingottpingottbah@199.93.177.77> <D7B3EFB4B2284C2D006B862485256CE6.006A4BCC85256CE6@webforums>
Organization: High-Performance Database Engineering
Message-ID: <Xns933B7F98AE5ACpingottpingottbah@199.93.177.77>
User-Agent: Xnews/06.01.10
Newsgroups: sybase.public.ase.product_futures_discussion
Date: Tue, 11 Mar 2003 14:52:58 -0500
Lines: 18
NNTP-Posting-Host: host-4-069.ionsky.com 66.35.44.69
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1016
Article PK: 95255

putnamr@river.it.gvsu.edu wrote in
news:D7B3EFB4B2284C2D006B862485256CE6.006A4BCC85256CE6@webforums:

> Hello,
>
> I do have a lot of code that I would like to make available and I
> definately do not want to tie up this NG if this the wrong place to put it.
>
> I would like to just put it here if I may.

I'm not sure if this is the right place to post the freeware ... it'd
be nice if there was a freeware group within the sybase.public set.

Perhaps posting to news.feedback for the creation of such a group?

And also sending them to David for the Sybase FAQ?

Thx a lot!
--
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com


David Owen Posted on 2003-03-12 00:15:59.0Z
From: David Owen <dowen@midsomer.org>
Subject: Re: sp to get syscomments text
Date: Tue, 11 Mar 2003 17:15:59 -0700
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums> <Xns933B75AD82854pingottpingottbah@199.93.177.77> <D7B3EFB4B2284C2D006B862485256CE6.006A4BCC85256CE6@webforums> <Xns933B7F98AE5ACpingottpingottbah@199.93.177.77>
Lines: 21
Organization: Midsomer Consultants Inc
User-Agent: KNode/0.7.1
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
Message-ID: <hDFnq9C6CHA.261@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: h68-145-239-254.cg.shawcable.net 68.145.239.254
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1011
Article PK: 95253


Pablo Sanchez wrote:

> putnamr@river.it.gvsu.edu wrote in
> news:D7B3EFB4B2284C2D006B862485256CE6.006A4BCC85256CE6@webforums:
>
>> Hello,
>>
>> I do have a lot of code that I would like to make available and I
>> definately do not want to tie up this NG if this the wrong place to put
>> it.
>>
>> I would like to just put it here if I may.

> And also sending them to David for the Sybase FAQ?

Caught and filed. Will be on the FAQ sometime this week.

dowen
--
David Owen Midsomer Consultants Inc. dowen@midsomer.org
Maintainer of the Sybase FAQ: http://www.isug.com/Sybase_FAQ


Pablo Sanchez Posted on 2003-03-12 03:23:02.0Z
Subject: Re: sp to get syscomments text
From: Pablo Sanchez <pablo@dev.null>
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums> <Xns933B75AD82854pingottpingottbah@199.93.177.77> <D7B3EFB4B2284C2D006B862485256CE6.006A4BCC85256CE6@webforums> <Xns933B7F98AE5ACpingottpingottbah@199.93.177.77> <hDFnq9C6CHA.261@forums.sybase.com>
Organization: High-Performance Database Engineering
Message-ID: <Xns933BCBE65387Dpingottpingottbah@199.93.177.77>
User-Agent: Xnews/06.01.10
Newsgroups: sybase.public.ase.product_futures_discussion
Date: Tue, 11 Mar 2003 22:23:02 -0500
Lines: 8
NNTP-Posting-Host: host-4-069.ionsky.com 66.35.44.69
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1008
Article PK: 95246

David Owen <dowen@midsomer.org> wrote in news:hDFnq9C6CHA.261
@forums.sybase.com:

>> And also sending them to David for the Sybase FAQ?
>
> Caught and filed. Will be on the FAQ sometime this week.

Thank you David!
--
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com


Carl Kayser Posted on 2003-03-21 13:04:12.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums>
Subject: Re: sp to get syscomments text
Date: Fri, 21 Mar 2003 08:04:12 -0500
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <O9ze1q67CHA.183@forums-1-dub>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 146.142.35.25
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1029
Article PK: 95272

I have "issues" as you mentioned above. With PC clients (Win95 and NT) the
text (basically) becomes left justified. The same with sp__helptext by
Andrew Zanevsky. (It seemed to work with older ASE versions.) I'm guessing
that this may be a reflection on UNIX vs. PC (vs. other?) clients (e.g., LF
versus LF/CR). Another possibility is that the behavior of "print" changed.

Perhaps the real way to come up with a solution is for Sybase to make
available their storage algorithm: how is the source file stream converted
into 255 byte strings? I'm not aware of it being available.

<putnamr@river.it.gvsu.edu> wrote in message
news:45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums...
> Actually I have found this to work better than defncopy because defncopy
is
> putting in extra spaces on long stored proecedures, views, and triggers.


Michael Peppler Posted on 2003-03-21 16:14:40.0Z
From: Michael Peppler <mpeppler@peppler.org>
Subject: Re: sp to get syscomments text
Date: Fri, 21 Mar 2003 08:14:40 -0800
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums> <O9ze1q67CHA.183@forums-1-dub>
User-Agent: Pan/0.11.3 (Unix)
Mime-Version: 1.0
Content-Type: text/plain; charset=iso885915
Content-Transfer-Encoding: 8bit
X-Comment-To: "Carl Kayser" <kayser_c@bls.gov>
Message-ID: <uq0uPW87CHA.207@forums-2-dub>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: oreilly14.oreilly.mbaynet.com 206.55.242.14
Lines: 29
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1030
Article PK: 95270

javax.mail.util.SharedByteArrayInputStream@783de08f


putnamr Posted on 2003-03-22 00:45:06.0Z
From: putnamr@river.it.gvsu.edu
Date: Fri, 21 Mar 2003 19:45:06 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: sp to get syscomments text
Message-ID: <5770544429B06E0A0004214185256CF1.004CFB8285256CF0@webforums>
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums> <O9ze1q67CHA.183@forums-1-dub>
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1034
Article PK: 95273

Hello,

Are you using some sort of frontend like DbArtisan or are using isql?

Thanks.


Carl Kayser Posted on 2003-03-22 12:35:57.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums> <O9ze1q67CHA.183@forums-1-dub> <5770544429B06E0A0004214185256CF1.004CFB8285256CF0@webforums>
Subject: Re: sp to get syscomments text
Date: Sat, 22 Mar 2003 07:35:57 -0500
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <#EQfh$G8CHA.259@forums-1-dub>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 146.142.35.25
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1035
Article PK: 95274

I use isql (with -w 255).

Per Michael's comments: sp_helptext does not insert any CRs or LFs.
Eventually it just does "select text from syscomments where ... order by
...". So I think that the issue is with how the data is stored "into" the
table. Yes, sp__helptext used to be fine. I can't help but wonder if
Sybase changed the behavior of "print" at some time. Or if they tweaked the
storage in syscomments.text. Or MS changed something.

<putnamr@river.it.gvsu.edu> wrote in message
news:5770544429B06E0A0004214185256CF1.004CFB8285256CF0@webforums...
> Hello,
>
> Are you using some sort of frontend like DbArtisan or are using isql?
>
> Thanks.


Carl Kayser Posted on 2003-03-22 14:55:02.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums> <O9ze1q67CHA.183@forums-1-dub> <5770544429B06E0A0004214185256CF1.004CFB8285256CF0@webforums> <#EQfh$G8CHA.259@forums-1-dub>
Subject: Re: sp to get syscomments text
Date: Sat, 22 Mar 2003 09:55:02 -0500
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <eBQQPNI8CHA.259@forums-1-dub>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 146.142.35.25
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1036
Article PK: 95275

I did a Chameleon telnet session to Solaris and used isql from there. No
difference.

"Carl Kayser" <kayser_c@bls.gov> wrote in message
news:#EQfh$G8CHA.259@forums-1-dub...
> I use isql (with -w 255).
>
> Per Michael's comments: sp_helptext does not insert any CRs or LFs.
> Eventually it just does "select text from syscomments where ... order by
> ...". So I think that the issue is with how the data is stored "into" the
> table. Yes, sp__helptext used to be fine. I can't help but wonder if
> Sybase changed the behavior of "print" at some time. Or if they tweaked
the
> storage in syscomments.text. Or MS changed something.
>
> <putnamr@river.it.gvsu.edu> wrote in message
> news:5770544429B06E0A0004214185256CF1.004CFB8285256CF0@webforums...
> > Hello,
> >
> > Are you using some sort of frontend like DbArtisan or are using isql?
> >
> > Thanks.
>
>


Michael Peppler Posted on 2003-03-24 16:33:11.0Z
From: Michael Peppler <mpeppler@peppler.org>
Subject: Re: sp to get syscomments text
Date: Mon, 24 Mar 2003 08:33:11 -0800
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums> <O9ze1q67CHA.183@forums-1-dub> <5770544429B06E0A0004214185256CF1.004CFB8285256CF0@webforums> <#EQfh$G8CHA.259@forums-1-dub> <eBQQPNI8CHA.259@forums-1-dub>
User-Agent: Pan/0.11.3 (Unix)
Mime-Version: 1.0
Content-Type: text/plain; charset=iso885915
Content-Transfer-Encoding: 8bit
X-Comment-To: "Carl Kayser" <kayser_c@bls.gov>
Message-ID: <#y$ZhNi8CHA.52@forums-1-dub>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 206-55-242-14.cvv-wl.mbay.net 206.55.242.14
Lines: 15
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1055
Article PK: 95294

javax.mail.util.SharedByteArrayInputStream@32c0115c


Ilya Zvyagin Posted on 2003-04-18 17:09:41.0Z
Reply-To: "Ilya Zvyagin" <masterziv@mail.ru>
From: "Ilya Zvyagin" <masterziv@mail.ru>
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums> <O9ze1q67CHA.183@forums-1-dub> <5770544429B06E0A0004214185256CF1.004CFB8285256CF0@webforums> <#EQfh$G8CHA.259@forums-1-dub> <eBQQPNI8CHA.259@forums-1-dub> <#y$ZhNi8CHA.52@forums-1-dub>
Subject: Re: sp to get syscomments text
Date: Fri, 18 Apr 2003 21:09:41 +0400
Lines: 13
Organization: FCT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
FL-Build: Fidolook Express 2001 UIExt. BuildID: 3BC00FAD (7/10/2001 12:17:49).
X-Comment-To: Michael Peppler
Message-ID: <1050685781.329886@gatekeeper.fct.ru>
Cache-Post-Path: gatekeeper.fct.ru!unknown@dream.int.fct.ru
X-Cache: nntpcache 2.4.0b2 (see http://www.nntpcache.org/)
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: gatekeeper.fct.ru 212.113.103.2
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1154
Article PK: 95396

Hello, Michael!
You wrote to "Carl Kayser" <kayser_c@bls.gov> on Mon, 24 Mar 2003 08:33:11 -0800:

MP> I just use sp__helptext on linux and isql (12.5.0.3) and it worked just fine.

Not very fine. It sometimes suddenly duplicates long rows of the objects.

--------------------
Ilya Zvyagin, First Container Terminal of SPb Sea Port
E-mail: masterziv@*KILLSPAM*mail.ru - include HP in subject
ICQ UID: 29427861(MasterZIV)


Arun Posted on 2003-07-24 23:33:19.0Z
From: "Arun" <arun.patnaik@sybase.com>
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums>
Subject: Re: sp to get syscomments text
Date: Thu, 24 Jul 2003 16:33:19 -0700
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4922.1500
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800
Message-ID: <enFJw0jUDHA.280@forums-2-dub>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: arupatw2k.sybase.com 10.22.90.203
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1318
Article PK: 95557

There again I would really like to recommend the use of the DDLGen utility
that gives you
schema generation capability for all schema objects including stored
procedures.

I see that many users are not aware of this tool. As far as schema
generation you should use this since this is guranteed to be maintained to
stay in sync with internal changes and release specific changes.

--
Thanks
- Arun

<putnamr@river.it.gvsu.edu> wrote in message
news:45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums...
> Actually I have found this to work better than defncopy because defncopy
is
> putting in extra spaces on long stored proecedures, views, and triggers.


Rob Verschoor Posted on 2003-07-27 11:04:43.0Z
Reply-To: "Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <B0CF2588AAE9E7A2005783C485256CE6.005783EA85256CE6@webforums> <72B0B4FAF71B8418005D2ED885256CE6.005AFD6085256CE6@webforums> <45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums> <enFJw0jUDHA.280@forums-2-dub>
Subject: Re: sp to get syscomments text
Lines: 31
Organization: Sypron B.V.
MIME-Version: 1.0
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: 7bit
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: a66085.upc-a.chello.nl
X-Original-NNTP-Posting-Host: a66085.upc-a.chello.nl
Message-ID: <3f23b1cb$1@forums-1-dub>
Date: 27 Jul 2003 04:04:43 -0700
X-Trace: forums-1-dub 1059303883 62.163.66.85 (27 Jul 2003 04:04:43 -0700)
X-Original-Trace: 27 Jul 2003 04:04:43 -0700, a66085.upc-a.chello.nl
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1322
Article PK: 95562

For some ddlgen details, see http://www.sypron.nl/ddlgen.html .

Rob V.

"Arun" <arun.patnaik@sybase.com> wrote in message
news:enFJw0jUDHA.280@forums-2-dub...
> There again I would really like to recommend the use of the DDLGen
utility
> that gives you
> schema generation capability for all schema objects including stored
> procedures.
>
> I see that many users are not aware of this tool. As far as schema
> generation you should use this since this is guranteed to be
maintained to
> stay in sync with internal changes and release specific changes.
>
> --
> Thanks
> - Arun
> <putnamr@river.it.gvsu.edu> wrote in message
> news:45A02564A9E1BE380064345C85256CE6.0060AA8585256CE6@webforums...
> > Actually I have found this to work better than defncopy because
defncopy
> is
> > putting in extra spaces on long stored proecedures, views, and
triggers.
>
>