Personal tools
You are here: Home Forums DB2 CALL SEQUENCES WITHOUT SCHEMA PREFIX
Navigation
Log in


Forgot your password?
 
Document Actions

CALL SEQUENCES WITHOUT SCHEMA PREFIX

Up to DB2

CALL SEQUENCES WITHOUT SCHEMA PREFIX

Posted by Ratheesh.K.Nair at July 16. 2009

Hi Experts,



I have two schemas having same tables and another schema contain
sequences.Is it possible to call the sequences from other two schemas
not specifying the sequence schema?



Thanks in Advance


Re: CALL SEQUENCES WITHOUT SCHEMA PREFIX

Posted by perallis at July 17. 2009

You have to set the specific schema before:


db2 set schema <schema_name>

 


 


Powered by Ploneboard
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls