Versions Compared

Key

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

See also: Actions

Page Properties


Description

Run actions generated by SQL provided by the sql parameter, a file, or standard input. 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 or file, (file or common or input), (database or url)

Optional Parameters

driver, database, host, port, url, dbUser, dbPassword, propertyFile, common, input, continue, simulate, field, encoding, clearFileBeforeAppend, findReplace, findReplaceRegex

Type

Run

Category

SQLRun

Output Formats

Replacement Variables

Since Version

Examples


...

Cql query
showLastModifierColumnfalse
showQueryfalse
showCreatorColumnfalse
showLastModifiedDateColumnfalse
cqlQuerylabel = 'cli-action-runFromSql' and label = 'cli-howto' and label = 'cli-product-segmentsystem' and space = SUPPORT
showCreatedDateColumnfalse
showTypeColumnfalse
showSpaceColumnfalse
showLabelsColumnfalse