1.CDO> ATTACH JIM SMITH $ In this example, the ATTACH command passes control from the current parent process at the CDO prompt to the JIM SMITH subprocess at the system prompt. 2.CDO> ATTACH "Jim Smith" $ In this example, the ATTACH command passes control from the current parent process at the CDO prompt to the Jim Smith process at the system prompt. The process name is entered in lowercase characters, which requires double quotation marks. 3.CDO> SPAWN $ SHOW DEFAULT USER1:[SMITH] $ ATTACH Smith CDO> SHOW DEFAULT USER1:[SMITH.REP] CDO> ATTACH Smith_1 $SHOW DEFAULT %DCL-S-RETURNED, control returned to process SMITH_1 In this example, the SPAWN command creates a subprocess, and the ATTACH commands pass control back and forth between the spawned subprocess and the parent process. 4.CDO> SPAWN RUN SYS$SYSTEM:SQL$ SQL> SQL> COMMIT SQL> $ATTACH SMITH CDO> CDO> ATTACH SMITH_2 %DCL-S-RETURNED, control returned to process SMITH_2 SQL> In this example, the SPAWN command creates a subprocess to invoke SQL and a secondary subprocess that runs SQL. When you are in CDO and want to reattach to your SQL subprocess, you can avoid subprocess quotas by attaching to the secondary subprocess.