471,887 Members | 1,458 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,887 software developers and data experts.

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 1691
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
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.