Re: QTEMP objects and Different Users on the Same Job

[Buck Calabro <kc2hiz@xxxxxxxxx>]

On 3/18/2016 9:48 AM, Bradley Stone wrote:
> The process looks like this:
>
> 1.  Delete any existing QTEMP files
> 2.  Create new QTEMP files
> 3.  Put data in them to process
> 4.  Done.
>
> Now throw this into a web server situation.  The jobs change the User ID
> for the process from QTMHHTTP to a real user ID.
>
> A file in QTEMP is created, process completes, all is good.  Files in QTEMP
> are left there.
>
> A new user comes along and changes the User of the job.  Now the process
> errors out because the new user doesn't have the right authorities to the
> object in QTEMP to clear it or remove it and start over.

I gave up on QTEMP for web/odbc/etc.  Instead I put a 'scratch file' in
a production library and put the user ID as the first key.