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.

Missing references in sysdepends table

2 posts in General Discussion Last posting was on 2012-10-12 04:05:08.0Z
Michael Cross Posted on 2012-10-04 10:29:29.0Z
Sender: 32b9.506d6422.1804289383@sybase.com
From: Michael Cross
Newsgroups: sybase.public.ase.general
Subject: Missing references in sysdepends table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <506d6509.32f0.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 4 Oct 2012 03:29:29 -0700
X-Trace: forums-1-dub 1349346569 172.20.134.41 (4 Oct 2012 03:29:29 -0700)
X-Original-Trace: 4 Oct 2012 03:29:29 -0700, 172.20.134.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31412
Article PK: 74300

Hi,

Using Sybase 15.5

I understand the sysdepends table may not hold all the
references to objects depending on the order of creation. Is
there a method to insert the references into the sysdepends
table without recreating all the objects?

Regards,
Michael


Cory Sane [TeamSybase] Posted on 2012-10-12 04:05:08.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <506d6509.32f0.1681692777@sybase.com>
In-Reply-To: <506d6509.32f0.1681692777@sybase.com>
Subject: Re: Missing references in sysdepends table
Lines: 23
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <507796f4$1@forums-1-dub>
Date: 11 Oct 2012 21:05:08 -0700
X-Trace: forums-1-dub 1350014708 172.20.134.152 (11 Oct 2012 21:05:08 -0700)
X-Original-Trace: 11 Oct 2012 21:05:08 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31427
Article PK: 74320

Michael,

I have never relied on the information in sysdepends because of the problem you mention.
If I'm looking for tables/views used by stored procs,triggers, or views then I query the syscomments text column.


--
Cory Sane
[TeamSybase]
Certified Sybase ASE 15.0 Administrator Associate
Certified Sybase ASE 15.0 SQL Developer Professional

"Michael Cross" wrote in message news:506d6509.32f0.1681692777@sybase.com...
> Hi,
>
> Using Sybase 15.5
>
> I understand the sysdepends table may not hold all the
> references to objects depending on the order of creation. Is
> there a method to insert the references into the sysdepends
> table without recreating all the objects?
>
> Regards,
> Michael