User Tools

Site Tools


transformations:sqlcommand

This is an old revision of the document!


SQL Command

Sends a free-form SQL query to a database, specified by a connector.

The query can include parameters wrapped in braces. Parameters will be replaced with their values during runtime. For instance:

TRUNCATE TABLE "{TableName}"

The query can include multiple statements, if this is supported by the database connector.

Use cases

  • Export data into a database by instructing the database to load a text file (e.g. previously generated by EasyMorph)
  • Truncate/drop/create tables
  • Trigger stored procedures

See also

transformations/sqlcommand.1466376284.txt.gz · Last modified: 2016/06/19 18:44 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki