Was there a reason you choose QTEMP and CREATE/REPLACE TABLE vs Declare Global Temporary Table and then reference that GTT? For example: "SESSION.FFD" vs "QTEMP/FFD"
IIRC, SESSION can be use more safely with SQL run in multi-thread situations.
I've used SESSION/QTEMP interchangeably in interactive jobs, where QTEMP is fixed. But with SQL Server Jobs, I don't know if QTEMP plays nice. But Scott F. would know better than I do.
Was there a reason you choose QTEMP and CREATE/REPLACE TABLE vs Declare Global Temporary Table and then reference that GTT? For example: "SESSION.FFD" vs "QTEMP/FFD"
IIRC, SESSION can be use more safely with SQL run in multi-thread situations.
I've used SESSION/QTEMP interchangeably in interactive jobs, where QTEMP is fixed. But with SQL Server Jobs, I don't know if QTEMP plays nice. But Scott F. would know better than I do.