Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Alphabetical list of system procedures

 

xp_cmdshell system procedure

Carries out an operating system command from a procedure.

Syntax
xp_cmdshell( 
command 
[ , 'no_output' ] )
Arguments
  • command   Use this CHAR(8000) parameter to specify a system command.

  • 'no_output'   Use this optional CHAR(254) parameter to specify whether to display output. The default behavior is to display output. If this parameter is the string 'no_output', no output is displayed.

Remarks

xp_cmdshell executes a system command and then returns control to the calling environment. The value returned by xp_cmdshell is the exit code from the executed shell process. The return value is 2 if an error occurs when the child process is started.

The second parameter affects only command line applications on Windows operating systems. For Unix, no output appears, regardless of the setting for the second parameter.

For Windows Mobile, any commands executed are visible in the database server message log, regardless of the setting for the second parameter. The console shell \\windows\cmd.exe is needed to run the procedure.

Permissions

DBA authority required

See also
Example

The following statement lists the files in the current directory in the file c:\temp.txt:

xp_cmdshell( 'dir > c:\\temp.txt' )

The following statement carries out the same operation, but does so without displaying a Command window.

xp_cmdshell( 'dir > c:\\temp.txt', 'no_output' )