Technical Note - Go-Faster

EXECUTE IMMEDIATE 'ALTER SESSION SET CURRENT_SCHEMA=SYSADMRP'; END IF; ... We can also set current schema for named batch processes with a trigger on the process request table PSPRCSRQST. This example trigger fires for the process that runs scheduled PS/Queries. You might want to extend it to other specific process, perhaps PSXPQRYRPT. ................
................