Has anyone used SQL Explorer? It's a neat program I use in Windows that connects to the AS400 to run SQL statements or queries.
I noticed on the AS400 if you run a 'SELECT *' statement on an object, it creates an object lock under the job name "QZDASOINIT."
Now, once the query is done, the object is still locked with *SHRRD. It finally releases the lock if you forcefully end SQL Explorer. Is this normal behavior? I've been testing with ALCOBJ/DLCOBJ at the moment which at least drops the lock so another program can place its exclusive lock on it. Thanks.
I noticed on the AS400 if you run a 'SELECT *' statement on an object, it creates an object lock under the job name "QZDASOINIT."
Now, once the query is done, the object is still locked with *SHRRD. It finally releases the lock if you forcefully end SQL Explorer. Is this normal behavior? I've been testing with ALCOBJ/DLCOBJ at the moment which at least drops the lock so another program can place its exclusive lock on it. Thanks.
Comment