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