Originally posted by: Greenspan

Hi ,

I am trying to buil a map where the input is a zOS db2 database. I am trying to create a typetree from the sql query. The query is quite small.

Select CID,DID from DA01.ID_EVNT

However I am getting an error

"could not get a temporary file name"

How do I resolve this.

I have wtx 8.4.0.2 , DB2 data service client 9.5, Access to zOS DB2 via ODBC .

Originally posted by: 8F19_Jesse_Menning

I had the same issue under Windows 7.  I ran database interface designer as Admin and the issue went away.

Hope this helps,

Jesse

Originally posted by: VinothKumarRajkumar

Hi,

Any other way to overcome this issue? Because I don't have privileges to run DID as admin. 

Regards,

Vinoth

Originally posted by: paul.brett

I believe if you create and save the MDQ first, then any temporary files *should* be created in the same directory as the MDQ.

Only if you attempt to generate a Typetree before you have saved the MDQ, will the product attempt to use the WTX installation directory, and potentially fail on a locked-down Windows installation.

Thank-you.

Paul.

Follow me on Twitter