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.

owner of trigger after unload db version from 6 to 9

3 posts in General Discussion Last posting was on 2003-12-09 08:12:39.0Z
Dorien Posted on 2003-12-08 14:13:08.0Z
Sender: 223f.3fd486b7.1804289383@sybase.com
From: Dorien
Newsgroups: ianywhere.public.general
Subject: owner of trigger after unload db version from 6 to 9
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fd48898.2256.846930886@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 8 Dec 2003 06:20:08 -0800, 10.22.241.42
Lines: 9
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 8 Dec 2003 06:01:34 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 8 Dec 2003 06:13:08 -0800
X-Trace: forums-1-dub 1070892788 10.22.108.75 (8 Dec 2003 06:13:08 -0800)
X-Original-Trace: 8 Dec 2003 06:13:08 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2189
Article PK: 4396

Hello,

After upgrading a version 6 database to a version 9 database
using the dbunload utility, our triggerheaders are altered
from dba.triggername to "triggername".triggername.
Does anybody know how to avoid this?
Upgrade for example the asademo database from 6 to 9 using:
"C:\Program Files\Sybase\SQL Anywhere 9\win32\dbunload.exe"
-ar -jr -c "uid=dba;pwd=sql;dbf=c:\umm9\asademo6.db"


Stephen Rice Posted on 2003-12-08 16:22:16.0Z
Newsgroups: ianywhere.public.general
Subject: Re: owner of trigger after unload db version from 6 to 9
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <3fd48898.2256.846930886@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns944B71B8EBCAEsricenospamianywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: srice-pc.sybase.com
X-Original-NNTP-Posting-Host: srice-pc.sybase.com
Date: 8 Dec 2003 08:22:16 -0800
X-Trace: forums-1-dub 1070900536 172.31.141.106 (8 Dec 2003 08:22:16 -0800)
X-Original-Trace: 8 Dec 2003 08:22:16 -0800, srice-pc.sybase.com
Lines: 31
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2190
Article PK: 4397


Dorien wrote in news:3fd48898.2256.846930886@sybase.com:

> Hello,
>
> After upgrading a version 6 database to a version 9 database
> using the dbunload utility, our triggerheaders are altered
> from dba.triggername to "triggername".triggername.
> Does anybody know how to avoid this?
> Upgrade for example the asademo database from 6 to 9 using:
> "C:\Program Files\Sybase\SQL Anywhere 9\win32\dbunload.exe"
> -ar -jr -c "uid=dba;pwd=sql;dbf=c:\umm9\asademo6.db"
>

This was a deliberate change introduced in Version 8. It allows the
same trigger name to be used on multiple tables.

Why do you want to avoid this? Triggers cannot be referenced in DML and
therefore the owner is meaningless from a practical point of view.

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

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


Dorien Posted on 2003-12-09 08:12:39.0Z
Sender: 15f.3fd5828e.1804289383@sybase.com
From: Dorien
Newsgroups: ianywhere.public.general
Subject: Re: owner of trigger after unload db version from 6 to 9
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fd583f7.166.846930886@sybase.com>
References: <3fd48898.2256.846930886@sybase.com><Xns944B71B8EBCAEsricenospamianywhere@10.22.241.106>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Dec 2003 00:12:39 -0800
X-Trace: forums-1-dub 1070957559 10.22.241.41 (9 Dec 2003 00:12:39 -0800)
X-Original-Trace: 9 Dec 2003 00:12:39 -0800, 10.22.241.41
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2192
Article PK: 4399


> Dorien wrote in news:3fd48898.2256.846930886@sybase.com:
>
> > Hello,
> >
> > After upgrading a version 6 database to a version 9
> > database using the dbunload utility, our triggerheaders
> > are altered from dba.triggername to
> > "triggername".triggername. Does anybody know how to
> > avoid this? Upgrade for example the asademo database
> > from 6 to 9 using: "C:\Program Files\Sybase\SQL Anywhere
> > 9\win32\dbunload.exe" -ar -jr -c "uid=dba;pwd=sql
> > ;dbf=c:\umm9\asademo6.db"
>
> This was a deliberate change introduced in Version 8. It
> allows the same trigger name to be used on multiple
> tables.
>
> Why do you want to avoid this? Triggers cannot be
> referenced in DML and therefore the owner is meaningless
> from a practical point of view.
>
> /steve
>
> --
> Stephen Rice
> Technical Services Manager
> iAnywhere Solutions
>
> - Please Post-
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere
> Developer Community at www.ianywhere.com/developer
>

Hello Steve,

Thanks for your reply.
We used the owner since we handle multiple different
databases from C++ code. All of them use the dba.triggername
style so our own parser didn't have to make any differences
when manipulating the databases using stored procedures with
the same names for all the databases. Seems we have to
exclude ASA from this.