By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,225 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,225 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.