Operations
Version 22.0.8473
Operations
Version 22.0.8473
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 | Starts the transaction. |
| dbCall | Executes a stored procedure in the database. |
| dbEndTransaction | Commits or rolls back 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. |
| encDecode | Decodes an encoded file or string of data. |
| encEncode | Encodes a file or string of data in a specified encoding format. |
| excelClose | Closes an Excel connection. |
| excelCreate | Creates a new Excel worksheet. |
| excelDelete | Deletes the row by RowId in an Excel worksheet. |
| excelGet | Queries the specified Excel worksheet. |
| excelGetHeader | Describes the specified Excel worksheet. |
| excelInsert | Appends a record to an Excel sheet. |
| excelListSheets | Lists the worksheets in a specified Excel workbook. |
| excelOpen | Opens an existing Excel workbook. |
| excelUpdate | Updates 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 specified path. |
| 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 | Writes encoded data to a file. |
| httpGet | Gets a document from the Web using the HTTP GET method. |
| httpPost | Posts data to a URL using the HTTP POST method. |
| httpPut | Puts a Web document using the HTTP PUT method. (Usually requires authentication.) |
| httpReceive | Receives files included in the HTTP request. The file content is sent using the input type=file element and encoded as multipart form data. |
| httpUpload | Executes an HTTP post with multipart form data to upload files to Web servers compliant with RFC1867 (INPUT TYPE=FILE). |
| jsonClose | Stops reading or writing a JSON document. |
| jsonDOMGet | Gets values from a JSON document. |
| jsonDOMSearch | Loops from a JSON document. |
| jsonOpen | Begins reading or writing a JSON document. |
| sysExecute | Executes a program or command. |
| xmlClose | Stops reading or writing an XML document. |
| xmlDOMGet | Gets values from an XML document. |
| xmlDOMSearch | Loops from an XML document. |
| xmlOpen | Begins reading or writing an XML document. |
| zipCompress | Compresses files into an archive. (GZIP,JAR, TAR, ZIP) |
| zipExtract | Extracts files from an existing archive. (GZIP, JAR, TAR, ZIP) |
| zipScan | Scans an archive for information on the files it contains. (GZIP,JAR, TAR, ZIP) |