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

syscat.packagedep

P: n/a
when I select the field: 'tabauth' from syscat.packagedep I would expect
insert, update,delete.....
All I get are numbers as follows. What is encoded with this numbers, or what
is the meaning of this numbers?
0 4 16 20 32 36 48 52 64 80
84 96 100 112 116

thanks in advance,
Peter
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"Peter Postlbauer" <pe******************@apk.at> wrote in message
news:bn**********@newsreader1.netway.at...
when I select the field: 'tabauth' from syscat.packagedep I would expect
insert, update,delete.....
All I get are numbers as follows. What is encoded with this numbers, or what is the meaning of this numbers?
0 4 16 20 32 36 48 52 64 80
84 96 100 112 116

thanks in advance,
Peter


From Appendix D of SQL Reference Vol. 1: "If BTYPE is O, S, T, U, V or W
then it encodes the privileges that are required by this package (Select,
Insert, Delete, Update)."

Doesn't really say. Why do you need to know? You could probably tell by
looking at the SQL against the object (BSCHEMA and BNAME) in the package.
I.E., if the package does an insert on BSCHEMA.BNAME, then insert privilege
is needed.
Nov 12 '05 #2

P: n/a
Hi Mark,
thanks for your reply.
Well, on the DB2 on mainframe we had the possibility to see in the
sysibm.sysplandep which plan (program) did which action (insert, update,
delete, select) against a table (view). It wasn't encoded.
Any idea?
Peter
is the meaning of this numbers?
0 4 16 20 32 36 48 52 64 80
84 96 100 112 116

thanks in advance,
Peter

From Appendix D of SQL Reference Vol. 1: "If BTYPE is O, S, T, U, V or W
then it encodes the privileges that are required by this package (Select,
Insert, Delete, Update)."

Doesn't really say. Why do you need to know? You could probably tell by
looking at the SQL against the object (BSCHEMA and BNAME) in the package.
I.E., if the package does an insert on BSCHEMA.BNAME, then insert

privilege is needed.

Nov 12 '05 #3

P: n/a
"Peter Postlbauer" <pe********************@apk.at> wrote in message
news:bn**********@newsreader1.netway.at...
Hi Mark,
thanks for your reply.
Well, on the DB2 on mainframe we had the possibility to see in the
sysibm.sysplandep which plan (program) did which action (insert, update,
delete, select) against a table (view). It wasn't encoded.
Any idea?
Peter

The column is defined as smallint, so its going to be a number and I have no
idea how to decode it.
Nov 12 '05 #4

P: n/a
I believe the appendix or elsewher in the Ref man. it explains the numbers.
When you look at them, they are combinations. I.E. if 52, you have 32 an
20 where 20 is 16 and 4. Each represents S,U,I,D, alter, reference,
control and so on. This gives DB2 a quick view of what privileges are
granted.
HTH, Pierre.

Mark A wrote:
"Peter Postlbauer" <pe******************@apk.at> wrote in message
news:bn**********@newsreader1.netway.at...
when I select the field: 'tabauth' from syscat.packagedep I would expect
insert, update,delete.....
All I get are numbers as follows. What is encoded with this numbers, or


what
is the meaning of this numbers?
0 4 16 20 32 36 48 52 64 80
84 96 100 112 116

thanks in advance,
Peter

From Appendix D of SQL Reference Vol. 1: "If BTYPE is O, S, T, U, V or W
then it encodes the privileges that are required by this package (Select,
Insert, Delete, Update)."

Doesn't really say. Why do you need to know? You could probably tell by
looking at the SQL against the object (BSCHEMA and BNAME) in the package.
I.E., if the package does an insert on BSCHEMA.BNAME, then insert privilege
is needed.


--
Pierre Saint-Jacques
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.