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.

dbprdbg don't retrieve all my stored procedures

2 posts in General Discussion Last posting was on 2003-05-21 18:14:11.0Z
Eddy Gervinet Posted on 2003-05-20 07:54:26.0Z
From: "Eddy Gervinet" <eddy.gervinet@utac.com>
Subject: dbprdbg don't retrieve all my stored procedures
Date: Tue, 20 May 2003 09:54:26 +0200
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <enHlPXqHDHA.331@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: mail.utac.com 213.39.1.222
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1039
Article PK: 3004

Hi,

I have a problem with asa 8 debugger dbprdbg.exe :
I don't see all the stored procedure created with another owner that dba or
rs_systabgroup.
Has anyone got a solution for this problem ?

thanks in advance


Robert Waywell Posted on 2003-05-21 18:14:11.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <enHlPXqHDHA.331@forums-2-dub>
Subject: Re: dbprdbg don't retrieve all my stored procedures
Date: Wed, 21 May 2003 14:14:11 -0400
Lines: 41
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: <#M$atW8HDHA.218@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1053
Article PK: 3009

What is the user id of the owner of the 'missing' procedures? If it happens
to be DBO, then the procedures are being filtered out as system procedures.
This is not configurable in 8.x or below. I haven't had a chance yet to see
if the behaviour is changed in the Banff Beta.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Eddy Gervinet" <eddy.gervinet@utac.com> wrote in message
news:enHlPXqHDHA.331@forums-2-dub...
> Hi,
>
> I have a problem with asa 8 debugger dbprdbg.exe :
> I don't see all the stored procedure created with another owner that dba
or
> rs_systabgroup.
> Has anyone got a solution for this problem ?
>
> thanks in advance
>
>