Operations
Version 21.0.8126
Operations
Version 21.0.8126
While Formatters are used to handle simple data manipulation and formatting, Operations are used for more complex operations within ArcScript.
Operation Basics
Each operation specifies a set of input parameters and output parameters.
You can write scripts, triggered by events, to automate message processing. You can invoke the built-in operations to automate many common tasks when processing, from file I/O to working directly with the protocol used by the connector. The available operations are described below. Additionally, you can make calls to the API in the same way that you invoke the built-in operations. Use arc:call to invoke an operation.
Operation Name | Description |
dbBeginTransaction | Start the transaction. |
dbCall | Executes a stored procedure in the database. |
dbEndTransaction | Commit or rollback the transaction. |
dbListColumns | Lists the columns of a table or view. |
dbListTables | Lists the tables in the database. |
dbListViews | Lists the views in the database. |
dbNonQuery | Executes a query against the database. |
dbQuery | Executes a query against the database. |
excelClose | Close an Excel connection. |
excelCreate | Create a new Excel worksheet. |
excelDelete | Delete the row by RowId in an Excel worksheet. |
excelGet | Queries the specified Excel worksheet. |
excelGetHeader | Describe the specified Excel worksheet. |
excelInsert | Append a record to an Excel sheet. |
excelListSheets | Lists the worksheets in a specified Excel workbook. |
excelOpen | Open an existing Excel workbook. |
excelUpdate | Update cells in an Excel worksheet. |
fileCopy | Copies a file or directory to the path specified. |
fileCreate | Creates a text file, and optionally writes to it. |
fileDelete | Deletes a file or directory. |
fileListDir | Lists the files and directories in the specified path. |
fileMakeDir | Creates the directory specified by the path. |
fileMove | Moves a file or directory to the path specified. |
fileRead | Reads a text file and pushes the data out. |
fileReadLine | Reads a text file and pushes the data out. |
fileReceive | Receives a file from the request. |
fileWrite | Write encoded data to a file. |
httpGet | Get a document from the Web using the HTTP GET method. |
httpPost | Post data to a URL using the HTTP POST method. |
httpPut | Put a Web document using the HTTP PUT method. (Usually requires authentication.) |
httpReceive | Receive files included in the HTTP request. The file content is sent using the input type=file element and encoded as multipart form data. |
httpUpload | Execute an HTTP post with multipart form data to upload files to Web servers compliant with RFC1867 (INPUT TYPE=FILE). |
jsonClose | Stop reading or writing a JSON document. |
jsonDOMGet | Get values from a JSON document. |
jsonDOMSearch | Loop from a JSON document. |
jsonOpen | Begin reading or writing a JSON document. |
sysExecute | Executes a program or command. |
xmlClose | Stop reading or writing an XML document. |
xmlDOMGet | Get values from an XML document. |
xmlDOMSearch | Loop from an XML document. |
xmlOpen | Begin reading or writing an XML document. |
xmlPut | Puts values to an XML document. |
zipCompress | Compress files into an archive. (GZIP,JAR, TAR, ZIP) |
zipExtract | Extract files from an existing archive. (GZIP, JAR, TAR, ZIP) |
zipScan | Scan an archive for information on the files it contains. (GZIP,JAR, TAR, ZIP) |