By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,021 Members | 912 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,021 IT Pros & Developers. It's quick & easy.

Can we create an alias for a sequence in db2

P: n/a
Can we create an alias for a sequence in db2 udb? We can do it in
oracle. But the same thing is not working in db2. I can create an
alias, but when i am trying to use it, there is an error that the
object is not found.

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
rajdb2 wrote:
Can we create an alias for a sequence in db2 udb? We can do it in
oracle. But the same thing is not working in db2. I can create an
alias, but when i am trying to use it, there is an error that the
object is not found.

Not supported.
ALIAS is only for table-objects. So if you CREATE ALIAS a1 FOR s1
DB2 will go looking for a table, not a sequence.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

P: n/a
Serge Rielau wrote:
rajdb2 wrote:
Can we create an alias for a sequence in db2 udb? We can do it in
oracle. But the same thing is not working in db2. I can create an
alias, but when i am trying to use it, there is an error that the
object is not found.

Not supported.
ALIAS is only for table-objects. So if you CREATE ALIAS a1 FOR s1
DB2 will go looking for a table, not a sequence.

PS: I see this request once in a blue moon, never remotely high enough
to make it on the short list.
FWIW, I'm willing to be convinced otherwise...

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3

P: n/a
Thanks Serge.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.