As per your suggestion, executing the following statement works:
select * from "user1".stock
Perhaps you can tell me the significance of this. Although I used the name user1 in the example, the real name is Administ (note the capitalised A).
The problem is that I have a Java program that retrieves all the owner and table names automatically from the sysusers & systables tables and builds up the qualified name at runtime.
Is my solution to always enclose the owner name in double quotes? The reason I ask this is that my program works unchanged when connecting to other Informix servers, so it begs the question, what configuration differences exist between the different Informix servers.
I'm not sure but I think the proble is the capital character. I noticed earlier that Informix itself is always default specifying quotes around the user name. As far as I know this always works. So you can just implemented it in scripts etc.