Hi!
I would like, without writing a procedure which require the configuration of
an additionnal C-compiler and which is not portable (I am wring à java
application targeted on DB2). And I would like to create a kind of alias of
a sequence. The goal is to have a user access a sequence located in another
schema, but in the same database. I knonw that sequences synonyms do not
work. Did you ever try to do this? Another solution would be to set the
default schema of a user be different from its login name.Is this possible?
Thanks for your attention.