@@ CLPPlus command

The @@ CLPPlus command is an alias for the START CLPPlus command. It can be used only from within a CLPPlus script file to call and run another CLPPlus script file.

Invocation

You must run this command from within a CLPPlus script.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagram@@pathURLscript-file

Command parameters

path
Specifies the path, either absolute or relative, to the script file that contains SQL statements and commands to run. If no path is specified, the current directory is used.
URL
Specifies the URL to the script file that contains SQL statements and commands to run. The URL must start with http:// or https://.
script-file
Specifies the script file name that contains SQL statements and commands to run.

Example

A script called dept_details.sql calls another script called employee_count.sql. The contents of dept_details.sql follows:

    ACCEPT dept_id PROMPT "Enter Department ID code : "
    @@ employee_count &dept_id