473,386 Members | 1,842 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Bind Error while using ALIAS on VIEW with other owner (DB2 OS/390)

We have following situation:

USER1 uses secondary-IDs SEC1 and SEC2

We defined an ALIAS with

SEC1.ALIAS1 => SEC2.VIEW1 => SEC2.TABLE1

and GRANT SELECT user SEC1 on VIEW SEC2.VIEW1.

We also defined a VIEW with

SEC1.VIEW2 => SEC1.TABLE1

in a COBOL we joined the ALIAS with the VIEW

SEC1.ALIAS1 <-> SEC1.VIEW2

an bound the programm with

OWNER(SEC1) QUALIFIER(SEC1)

The BIND abended with SQL-code -551 which said user SEC1 doesnot have
SELECT authority on VIEW SEC2.VIEW1.

We found that it is no problem to run the JOIN within SPUFI. Got
anyone an idea what is the problem with the BIND?
Nov 12 '05 #1
0 2129

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Strategic Mind | last post by:
The bind error messages below are returned when running the db2batch command on Windows NT against an AS/400 database. Most batch scripts are running without error. What files and and command...
4
by: Mark | last post by:
I am running DB2 V8.1 ESE client running on Windows XP Professional configured to connect directly to DB2 V6.1.2 on OS/390. I can connect to the OS/390 DB2 database (DB2 subsystem). But when I try...
4
by: prasad | last post by:
I am getting sql error during binding a program which access a temporary table. The temporary table declaration and access methods are given below. EXEC SQL DECLARE GLOBAL TEMPORARY TABLE TEM88...
0
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
5
by: Santiago Ordax Solivellas | last post by:
Hi. We have almost all our tables defined on library lib1 and some on lib2. We have alias defined on lib1 to access tables on lib2 so there is no need to qualify library name. Alias for tables on...
4
by: banz | last post by:
Hello I have a problem to resolve: I wrote a Perlscript which caches data from a server (local on my machine) I would like to have a other connection to a remote server but I don't know how to...
0
by: anaik100 | last post by:
am trying to run a java db2 program. my db2 is in os/390. below is the code public class T4DB2Connect { public static void main(String args) { try { // load the DB2 Driver...
0
by: mike | last post by:
At this site, they use DB2 8.2.2 on LUW , and have thousands of DARI style stored procedures ('c', embedded-static SQL). During PREP and BIND they specify the package-owner with the OWNER...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.