469,342 Members | 5,299 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,342 developers. It's quick & easy.

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

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.


Nov 12 '05 #1
1 1653
See SET SCHEMA in the SQL Reference Volume 2, under "Chapter 1.

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.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by thomasfj | last post: by
4 posts views Thread by Sean LeBlanc | last post: by
3 posts views Thread by Peter Wang | last post: by
8 posts views Thread by situ | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.