Re: Is the table created or not?

On Thu, Sep 6, 2018 at 7:04 PM Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

On Thu, Sep 6, 2018 at 4:55 PM John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

Maybe more precisely, the *file* is not there. Immediately after
attempting to create the table, I
check for existence of the file
object, and the result is negative. But I can still query the table
with SQL to get a row count (which will be zero). A table that doesn't
exist shouldn't be able to be queried at all.

How?

It smells like an authority issue to me.

The SQL side has authority to the table (file), whatever you're using to

"

check for existence of the file" doesn't.

Well, (a) the same job is doing both the SQL and the file existence
checking, (b) the SQL and file existence checking both succeed in the
existing version of the application but the file existence checking
doesn't find the file in the new version, and (c) I've manually
verified the file's existence or absence at a command line, and my
user profile has *ALLOBJ authority.

"File existence checking" actually takes many forms in the program.
One is that the program tries to open the file for RLA processing.
Another is that I use the operating system's IFS path existence
checking (as wrapped by Python's os.path.exists() function),
specifying '/qsys.lib/mylib.lib/myfile.file' as the argument.

John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD