I think this question has been asked before...
I have instance DB2T, within which I would like to create multiple
schemas. I want to then create the same set of tables within each
schema. My questions are -
1. I want to create multiple TSO ids such that each TSO id has SELECT,
INSERT, UPDATE, and DELETE privileges to one schema only. Further, is
there any way to default the schema for each id. i.e. when user goes
into QMF, the schema he/she is defaulted is to the one that he/she has
access to.
2. I want to use one set of COBOL programs to run against the different
schemas. Currently all SQL statements within the COBOL programs have
schema qualifiers. Therefore, in the current scenario, the qualifier is
changed for each COBOL program prior to running it, then compiled,
linked, and bound before running it.
Thanks much in advance.
SS