| Div | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
On this page
|
Related information for 4.0.0
Actions
| P | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Parameter Tips
Parameters |
Parameter | Short | Value | Description | |||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | action
| a | |
| ||||||
| 2 | columns
|
| | Column selection and ordering when action generates CSV output. A comma separated list of column numbers (1-based) or column names (case insensitive). Only columns provided by the selected outputFormat are available for selection. Invalid columns will be ignored. | ||||||
| 3 | common
|
| | Common parameter string added to all run actions. | ||||||
| 4 | connectionTimeout
|
| | Allow overriding environment settings for connect and read timeouts on URL connections. In milliseconds, 0 means infinite. | ||||||
| 5 | continue
|
| | Continue processing even after errors are encountered. | ||||||
| 6 | database
|
| | Database name is required for SQL actions. | ||||||
| 7 | dateFormat
|
| | Format string for date in Java SimpleDateFormat, default is client date format. | ||||||
| 8 | dbPassword
|
| | Database user password. Defaults to password. | ||||||
| 9 | dbUser
|
| | Database user name. Defaults to user. | ||||||
| 10 | debug
|
| | Requests detail debug output. Optional for all actions. | ||||||
| 11 | driver
|
| | JDBC driver class or predefined value: postgresql, mysql, mssql, oracle, or db2400. Required for SQL actions. | ||||||
| 12 | encoding
|
| | Character encoding (character set) for text based file content - must be an encoding supported by your JAVA platform. | ||||||
| 13 | file
| f | | Path to file based content or result output. Use - for standard input. | ||||||
| 14 | findReplace
|
| | Find and replace text. Comma separated list of colon separated pairs. Single quote values containing a delimiter. Embedded quotes must be doubled. | ||||||
| 15 | findReplaceRegex
|
| | Find and replace text with a regular expression. Comma separated list of colon separated pairs. Single quote values containing a delimiter. Embedded quotes must be doubled. | ||||||
| 16 | help
|
| | Prints this help message. | ||||||
| 17 | host
|
| | Database host server for SQL actions. Not used if url is provided. (default: localhost) | ||||||
| 18 | list
|
| | Comma separated list of entries. Single quote values containing a delimiter. Embedded quotes must be doubled. | ||||||
| 19 | outputFormat
|
| | Specify output format for an action. (default: 1) | ||||||
| 20 | parameters
|
| | Client specific parameters | ||||||
| 21 | password
| p | | User password for remote access. | ||||||
| 22 | port
|
| | Database host port for SQL actions. Optional, defaults to database default. Not used if url is provided. | ||||||
| 23 | propertyFile
|
| | Property file with mapping information. | ||||||
| 24 | quiet
|
| | Limit some output messages. Optional for all actions. | ||||||
| 25 | simulate
|
| | Simulate running actions. Log the action that would be taken. | ||||||
| 26 | special
|
| | Ordered list of alternate characters for comma ( , ), colon ( : ), at ( @ ), quote ( ' ), and double quote ( " ) characters used for specialized processing of some specific parameters. | ||||||
| 27 | sql
|
| | SQL select statement used to generate a run script. | ||||||
| 28 | url
|
| | Action specific setting. Example: Database access url for SQL actions. Optional when host is provided. | ||||||
| 29 | user
| u | | User name for remote access. | ||||||
| 30 | verbose
| v | | Requests verbose output to help with problem determination. Optional for all actions. |
...