Reference a Sequences Without the Schema Owner

Reference a Sequences Without the Schema Owner

 

  

Hi,

I am wondering if there is a way to access sequences without specifying
the schema owner. I tried creating an alias (synonym) but they are used
for tables and views so a warning was returned indicating that the
sequence was currently undefined. Any ideas?

Allison MacIntyre
SPIELO, A GTECH Company
tel: 506.867.7586
fax: 506.853.9324
Allison.[Email address protected] <mailto:Andy.[Email address protected]
www.gtech.com
www.spielo.com



-----------------------------------------
This email may contain confidential and privileged material for the
sole use of the intended recipient(s). Any review, use, retention,
distribution or disclosure by others is strictly prohibited. If you
are not the intended recipient (or authorized to receive for the
recipient), please contact the sender by reply email and delete all
copies of this message. Also, email is susceptible to data
corruption, interception, tampering, unauthorized amendment and
viruses. We only send and receive emails on the basis that we are
not liable for any such corruption, interception, tampering,
amendment or viruses or any consequence thereof.


DB2 & UDB email list listserv db2-l LazyDBA home page