SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
X-22
Examples—=_SQL_TM_node_vol

This TACL command directs NonStop SQL/MP to create all temporary tables that
would normally go to volume \NY.$HDQ on volume \NY.$SCR instead and to use
SYNCDEPTH 1 for the tables rather than the usual SYNCDEPTH 0:
32> ADD DEFINE =_SQL_TM_NY_HDQ, FILE \NY.$SCR.TMP.SYNC1

Both DEFINEs shown in the previous examples can exist simultaneously, directing
different sets of temporary tables to different locations. To redirect temporary tables
to normal locations, delete the DEFINEs with these commands:
35> DELETE DEFINE =_SQL_TM_A_B
36> DELETE DEFINE =_SQL_TM_NY_HDQ