472,326 Members | 2,100 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

QADBXREF authority - aliases creation

Hi all,

I have an issue with QSYS\QADBXREF file - it keeps aliases on tables.
I take care of an application that works on many places (servers) and
on one of them it's not possible to create alias. I've checked the
authority of QADBXREF file on this 'problematic' machine and it's as
follows:

Object ----------Data--------- --------Object---------
User Group Authority Read Add Upd. Del. Exec. Opr Mgt Exist Alter Ref
*PUBLIC USER DEF X
On all the other machines (there is no problem to create aliases and
then to use them) it's:

Object ----------Data--------- --------Object---------
User Group Authority Read Add Upd. Del. Exec. Opr Mgt Exist Alter Ref
*PUBLIC *CHANGE X X X X X X

My questions are:
1. How to enable aliases creation?
2. Are there any SQL setting on AS400 that enable/disable aliases?

On IBM sites I found a note that QADBXREF file is one of the files
that are always opened so there is no possibility to change the
authorities...

Thanks in advance for any suggestions,
kb
Nov 12 '05 #1
0 1543

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

Similar topics

0
by: Andrew | last post by:
With command-line interface ( 3.23.37, UNIX Socket ) all is well with column aliasing. However, column aliases disappear in Excel, over ODBC, when...
5
by: Kevin | last post by:
I'm making my first attempt to put embedded SQL in a visual C++ application and I'm having trouble getting aliases to work. If I try the following...
11
by: TheBurgerMan | last post by:
Hi all. I am using W2K3, .NET2 on a machine running AD and Exchange. I started getting the message below last week. I googled the error and not...
3
by: li_zy | last post by:
Hello , everyone ! It is appreciated that someone tell me what's the difference between direct SYSADM authority and indirect SYSADM authority ....
0
by: hugo_herrera | last post by:
Hi there, Anyone know of a webhost that provides an API that allows the website code to automate the domain/subdomain/alias/email account...
22
by: mp | last post by:
i have a python program which attempts to call 'cls' but fails: sh: line 1: cls: command not found i tried creating an alias from cls to clear...
15
by: jacob navia | last post by:
Recently, we had a very heated thread about GC with the usual arguments (for, cons, etc) being exchanged. In one of those threads, we came into...
22
by: Daniel Rucareanu | last post by:
I have the following script: function Test(){} Test.F = function(){} Test.F.FF = function(){} Test.F.FF.FFF = function(){} Test.F.FF.FFF.FFFF...
6
by: dom.k.black | last post by:
Is it still common practice to use type aliases (INT, PCHAR etc). It looks ugly and breaks the syntax highlighting, are there any advantages...
0
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
0
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

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.