{"title":"DB Row Manipulator","nodeType":"Sink","id":"*xEbE5jaFSoZdwehG","factoryName":"org.knime.database.node.io.parameterizedmanipulator.ParameterizedDBManipulatorNodeFactory","factoryId":"org.knime.database.node.io.parameterizedmanipulator.ParameterizedDBManipulatorNodeFactory","path":["DB","Read/Write"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node runs SQL commands e.g. INSERT, UPDATE, DELETE in the connected database using the values given by the KNIME input table. The values of the selected columns are used in the command resulting in each row of the KNIME input table creating its own command that is send to the database with the corresponding values for execution.</p>\n        ","shortDescription":"This node runs SQL commands in the connected database restricted by the possible values given by the input \n        KNIME data table.","keywords":["database","db","sql"],"deprecated":false,"streamable":true,"tags":["DB","Read/Write","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7yAAAO8gHOFHveAAAAGXRFWHRTb2Z0d2FyZQB3d3cuaW5rc2NhcGUub3Jnm+48GgAAANpJREFUOI2l0j1KQ0EUxfFftAkBU5gFiBCLFEIiJK07sEunazArsHcVaeysTJ0i2FhaprcQRF+CIKKgaJF5ZEhePh7vwMDAvf9zZu4MBbWLe5yhgQ885zX5W1j9ogZfqGxgjrGfZfCI0w1wE2+htwY9dHG4xWlbSKLAYVys4hyDsF+VnMJTtAWXMX7MZ1DaFmZ5iKM8cGzwiTsc5YGZPcmB2aeCnbDgJoITnCzCqcro4BpP5kN8CVeaZCWnmuA3SnqPape4QH0VzPIQb9c1Z+kbr3jAFfbyGhTSP5fmTSOIabMTAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data to use during database statement execution.","description":"KNIME data table with the data rows to be used during statement execution."},{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"DB Connection","description":"DB Connection to the database."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input Data with Manipulation Status","description":"Input KNIME data table with additional columns providing the number of affected rows in the database and warnings, if checked in the dialog."},{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"DB Connection","description":"DB Connection to the database."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Settings","fields":[{"name":"SQL Statement","description":"Enter the SQL Statement here, for example <i>INSERT INTO table (col1) VALUES (1)</i> . Constant values and any identifier from the KNIME column and flow variable list can be used in the SQL statement by double clicking the column or variable name.\n<br />\nTo open code completion press <i>&lt;CTRL&gt; &#43; &lt;SPACE&gt;</i> . Table and columns names are only suggested if the metadata is available e.g. shown in the Database Metadata Browser. To perform undo press <i>&lt;CTRL&gt; &#43; Z</i> and for re-do <i>&lt;CTRL&gt; &#43; Y</i> .","optional":false},{"name":"Database Metadata Browser","description":"The Database Metadata Browser allows you to browse the database metadata and to select a table or view. Click the <i>Refresh</i> button at the bottom right to re-fetch the metadata from the database. The data is grouped by database schema and type e.g. view or table. By clicking on an entity it shows contained elements. If you click on a table or view the dialog will fetch the column names and types of the selected element. To select a table or view select the name and click <i>OK</i> or double click the element. To search for a particular table or view enter the name or parts of the name into the search field and click on the <i>Magnifying Glass</i> button or press <i>enter</i> .","optional":false},{"name":"Column List","description":"The list contains the columns that are available in the KNIME input table. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).","optional":false},{"name":"Flow Variable List","description":"The list contains the flow variables that are currently available at the node input. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).","optional":false},{"name":"Batch size","description":"Enter a number greater than 0 for the number of rows used in one batch job. Entering 1 disables batch processing. This way only one row is processed at a time.","optional":false},{"name":"Fail on error","description":"Disable this if you want to continue after a database error.","optional":false},{"name":"Append manipulation status columns","description":"Enable this to append two additional (status and error) columns to the output table (see description).","optional":false}]},{"sectionName":"Output Type Mapping","sectionDescription":"This option allows you to define rules to map from KNIME types to database types.","fields":[{"name":"Mapping by Name","description":"Columns that match the given name (or regular expression) and KNIME type will be mapped to the specified database type.","optional":false},{"name":"Mapping by Type","description":"Columns that match the given KNIME type will be mapped to the specified database type.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171318","bundleName":"KNIME database nodes","bundleSymbolicName":"org.knime.database.nodes","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.database","featureName":"KNIME Database","featureVersion":"5.12.0.v202606171318","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*0mIkLShcIfCXS7Y-"},"frequentSuccessors":[]}