Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Page Properties


Description

Run actions generated by SQL provided by the sql parameter, a file, or standard input. The default behavior is that each column name that matches a valid parameter for the client generates a parameter with value matching the column value for the row being process. A special case is if the value of the first column starts with a '-', then the entire row will be treated as a single action. Alternatively, use '--options setReplacementVariables' to change the behavior to set a replacement variable whose key (case sensitive) is the column name, with blanks removed, and whose value is the value matching the column value for the row being Replacement variables will be set representing each column (case sensitive, blanks removed) in the result set and the corresponding column value for each row processed.

Required Parameters

sql, (sql file or common or file input), (database or url)

Optional Parameters

dbUser, dbPassword, propertyFile, common, input, continue, simulate, field, encoding, clearFileBeforeAppend, findReplace, findReplaceRegex

Type

Run

Category

Run

Output Formats

Replacement Variables

Since Version

Examples


...