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.

ctlib & syscomments

5 posts in Unix Last posting was on 2001-04-25 08:09:08.0Z
gin Posted on 2001-03-29 16:33:00.0Z
From: "gin" <gin@wanadoo.fr>
Subject: ctlib & syscomments
Date: Thu, 29 Mar 2001 18:33:00 +0200
Lines: 57
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: <jMr9xBHuAHA.169@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.unix
NNTP-Posting-Host: Mix-Toulon-103-1-86.abo.wanadoo.fr 193.249.10.86
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:677
Article PK: 1092768

I want to retrieve stored procs text with c program using ctlib.

My problem is text's column of syscoments table has 255 length.
And when i get this column if the last char is a space, I don't have it so
when I want to recompile stored proc I have an error !!!

I join a little c program to explain more.
Try it under your server tou get a specified stored proc with truncate line
ex : line 1.....declare @erreur<space>\n
line 2 int .....\n

I used .so lib under linux & sybase 11.9.2. I try it under Sun & Dg with
same results.

This program rewritten in dblib runs very well ....


ALPER ONEY Posted on 2001-04-25 08:09:08.0Z
Reply-To: "ALPER ONEY" <aoney@takasbank.com.tr>
From: "ALPER ONEY" <aoney@takasbank.com.tr>
References: <jMr9xBHuAHA.169@forums.sybase.com>
Subject: Re: ctlib & syscomments
Date: Wed, 25 Apr 2001 11:09:08 +0300
Lines: 32
Organization: I.S.E SETTLEMENT AND CUSTODY BANK INC
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <5$#5vEWzAHA.274@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.unix
NNTP-Posting-Host: 212.15.15.65
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:556
Article PK: 1092646

why don't you use sybase utilities(ie defncopy) in your C code to retrieve
stored procs text?

Best wishes from istanbul.

"gin" <gin@wanadoo.fr> wrote in message
news:jMr9xBHuAHA.169@forums.sybase.com...
> I want to retrieve stored procs text with c program using ctlib.
>
> My problem is text's column of syscoments table has 255 length.
> And when i get this column if the last char is a space, I don't have it so
> when I want to recompile stored proc I have an error !!!
>
> I join a little c program to explain more.
> Try it under your server tou get a specified stored proc with truncate
line
> ex : line 1.....declare @erreur<space>\n
> line 2 int .....\n
>
> I used .so lib under linux & sybase 11.9.2. I try it under Sun & Dg with
> same results.
>
> This program rewritten in dblib runs very well ....
>
>
>
>
>


Michael Peppler Posted on 2001-03-30 00:06:25.0Z
From: "Michael Peppler" <mpeppler@peppler.org>
Subject: Re: ctlib & syscomments
Date: Thu, 29 Mar 2001 16:06:25 -0800
Organization: Data Migrations, Inc.
References: <jMr9xBHuAHA.169@forums.sybase.com>
User-Agent: Pan/0.9.3_cvs (Unix)
Mime-Version: 1.0
Content-Type: text/plain charset=ISO-8859-1
Content-Tranfer-Encoding: 8bit
X-No-Productlinks: Yes
Message-ID: <m586m$KuAHA.209@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.unix
Lines: 17
NNTP-Posting-Host: gw.peppler.org 206.55.243.57
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.sqlserver.unix:674
Article PK: 1092764


gin Posted on 2001-03-30 16:25:37.0Z
From: "gin" <gin@wanadoo.fr>
References: <jMr9xBHuAHA.169@forums.sybase.com> <m586m$KuAHA.209@forums.sybase.com>
Subject: Re: ctlib & syscomments
Date: Fri, 30 Mar 2001 18:25:37 +0200
Lines: 23
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: <5KguSiTuAHA.169@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.unix
NNTP-Posting-Host: Mix-Toulon-104-1-99.abo.wanadoo.fr 193.249.73.99
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:671
Article PK: 1092761

I try these two values without results and any change...

Michael Peppler <mpeppler@peppler.org> a écrit dans le message :
m586m$KuAHA.209@forums.sybase.com...

> In article <jMr9xBHuAHA.169@forums.sybase.com>, "gin" <gin@wanadoo.fr>
> wrote:
>
> > I want to retrieve stored procs text with c program using ctlib.
> >
> > My problem is text's column of syscoments table has 255 length. And when
> > i get this column if the last char is a space, I don't have it so when I
> > want to recompile stored proc I have an error !!!
>
> Are you use CS_FMT_NULLTERM or CS_FMT_IGNORE in the ct_bind() call?
>
> Michael
> --
> Michael Peppler - Data Migrations Inc. - mpeppler@peppler.org
> http://www.mbay.net/~mpeppler - mpeppler@mbay.net
> International Sybase User Group - http://www.isug.com
> Sybase on Linux mailing list: ase-linux-list@isug.com


Michael Peppler Posted on 2001-03-30 19:41:27.0Z
From: "Michael Peppler" <mpeppler@peppler.org>
Subject: Re: ctlib & syscomments
Date: Fri, 30 Mar 2001 11:41:27 -0800
Organization: Data Migrations, Inc.
References: <jMr9xBHuAHA.169@forums.sybase.com> <m586m$KuAHA.209@forums.sybase.com> <5KguSiTuAHA.169@forums.sybase.com>
User-Agent: Pan/0.9.3_cvs (Unix)
Mime-Version: 1.0
Content-Type: text/plain charset=ISO-8859-1
Content-Tranfer-Encoding: 8bit
X-No-Productlinks: Yes
Message-ID: <KlFoOQVuAHA.208@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.unix
Lines: 30
NNTP-Posting-Host: gw.peppler.org 206.55.243.57
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.sqlserver.unix:670
Article PK: 1092758