Set Schema problems 
Author Message
 Set Schema problems
I am trying to use the Set Schema command in the interactive command center
of developer edition 7.1 on NT.

The command seems to run (no errors) but does not seem to have any affect. I
read that the DYNAMICRULES  BIND option could affect whether or not the Set
Schema command will do anything or not. How do I find out what DYNAMICRULES
BIND is set to and how do I change it?

Thanks in advance.

--
George McLean
R&R Sytec



Wed, 07 Jan 2004 00:37:56 GMT
 Set Schema problems



Quote:
> I am trying to use the Set Schema command in the interactive command center
> of developer edition 7.1 on NT.

> The command seems to run (no errors) but does not seem to have any affect. I
> read that the DYNAMICRULES  BIND option could affect whether or not the Set
> Schema command will do anything or not. How do I find out what DYNAMICRULES
> BIND is set to and how do I change it?

> Thanks in advance.

Use the command

SET CURRENT SCHEMA ...

The SET SCHEMA by itself does not appear to do anything except set a
value that is obtained when you get the schema name....

(at least on DB2 7.1 FP2 and FP3 on OS/2)

--
Lorne Sunley



Wed, 07 Jan 2004 07:34:16 GMT
 Set Schema problems
syscat.packages column dynamicrules contains a 'B' for dynamicrules Bind.
(What packages the command center uses=?)

It can be set at prep/bind time.
One of owner/qualifier or the binder id is used depending on what was set at
prep/bind time.

What does not fit your expectations? auth id or implicit objet qualification.
Maybe the set schema does not have any effect because it's the set path you
need?
What commands are you trying? select, create ?

A few examples that may help understand :

(sample database)

Quote:
>connect to dsam user DSAMA ...
>DB2 BIND DB2CLPCS.BND BLOCKING ALL DYNAMICRULES BIND GRANT_GROUP DSAMGU OWNER

DSAM0 qualifier admin
(package name for this one is sqlc29n3 for me.  See ddcspkgn and/or db2bfd
commands ...)

LINE    MESSAGES FOR DB2CLPCS.BND
------  --------------------------------------------------------------------
        SQL0061W  The binder is in progress.
        SQL0091N  Binding was ended with "0" errors and "0" warnings.

Quote:
>db2 connect reset

DB20000I  The SQL command completed successfully.

Quote:
>DB2 CONNECT TO DSAM USER DSAM1 USING xxxx

   Database Connection Information

 Database server        = DB2/NT 6.1.0
 SQL authorization ID   = DSAM1
 Local database alias   = DSAM

db2 select * from employee
SQL0551N  "DSAM0" does not have the privilege to perform operation "SELECT" on
object "ADMIN.EMPLOYEE".  SQLSTATE=42501
-----------------

Quote:
>db2 create table DSAM1.TAB1 (COL1 INT)

DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0549N  The "create" statement is not allowed for "package" "SQLC29N3"
because the bind option DYNAMICRULES(BIND) in the "package" is in effect.
SQLSTATE=42509

PM

Quote:

> I am trying to use the Set Schema command in the interactive command center
> of developer edition 7.1 on NT.

> The command seems to run (no errors) but does not seem to have any affect. I
> read that the DYNAMICRULES  BIND option could affect whether or not the Set
> Schema command will do anything or not. How do I find out what DYNAMICRULES
> BIND is set to and how do I change it?

> Thanks in advance.

> --
> George McLean
> R&R Sytec



Sun, 11 Jan 2004 07:55:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Problems with XSD schema mapping to SQL Server schema

2. SET CONSTRAINTS not schema-aware

3. SET SCHEMA?

4. SET SCHEMA?

5. Setting Schema

6. Setting schema

7. DateTimeFormat Schema setting

8. Set current-schema and granting

9. Set schema="yourdb"

10. Set schema="yourdb"

11. set current schema


 
Powered by phpBB® Forum Software