× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. JAVA400-L
  3. February 2006

CREATE ALIAS issue...

Hi all:

I am having a problem using the CREATE ALIAS SQL statement to read a PF 
member. My Java program is receiving an SQL0901 error when the CREATE 
ALIAS statement is executed. From what I have been able to find out, this 
is a sort of generic SQL error. When I handle this exception and try to 
delete the ALIAS, I am told it does not exist. Then when I run the program 
again, I get SQL error SQL0601, "ALIAS2 in MYLIB type *FILE already 
exists." And I can see the file in the master file table, so I am being 
allowed to create the file, just not read it for some reason(?). I am 
pretty sure this is a permission issue, since this code worked on another 
system.

Thanks in advance for any help.


Mike Burdette

Comporium Data Services
Web Development

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.