[
https://issues.apache.org/jira/browse/NIFI-15224?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Patrik H updated NIFI-15224:
----------------------------
Description:
*Issue:*
Other SQL-related Processors (e.g. ExecuteSQL) permit surrounding the main
statement with pre- and post-queries. This functionality may be useful for
PutDatabaseRecord, too. For example, in the context of Teradata, we may want to
set a QueryBand, or lock the table before writing and unlock it afterwards.
*Solution:*
Introduce sql-pre-query and sql-post-query properties into PutDatabaseRecord.
was:
*Issue:*
Other SQL-related Processors (e.g. ExecuteSQL) permit surrounding the main
statement with pre- and post-queries. This functionality may be useful for
PutDatabaseRecord, too. For example, in the context of Teradata, we may want to
set a QueryBand, or lock the table before writing and unlock it afterwards.
*Solution:*
Introduce sql-pre-query and sql-post-query properties into
PutDatabaseRecord.{*}{*}
> Support pre- and post-queries in PutDatabaseRecord
> --------------------------------------------------
>
> Key: NIFI-15224
> URL: https://issues.apache.org/jira/browse/NIFI-15224
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Extensions
> Affects Versions: 2.6.0
> Reporter: Patrik H
> Priority: Minor
> Labels: putdatabaserecord
>
> *Issue:*
> Other SQL-related Processors (e.g. ExecuteSQL) permit surrounding the main
> statement with pre- and post-queries. This functionality may be useful for
> PutDatabaseRecord, too. For example, in the context of Teradata, we may want
> to set a QueryBand, or lock the table before writing and unlock it afterwards.
> *Solution:*
> Introduce sql-pre-query and sql-post-query properties into PutDatabaseRecord.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
