Getting rid of "schema" from DB2 statements in COBOL programs...

santoshs

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

Nov 12 '05 #1

Brian Tkatch

See SET SCHEMA in the SQL Reference Volume 2, under "Chapter 1.
Statements".

I do not think there is a way to default a person when they login.
However, a VIEW can be CREATEd in the person's default SCHEMA to point
to the correct TABLE.

B.

Nov 12 '05 #2