In the given context, certain words like "User" and "Sequence" are reserved in database systems for specific functionalities. Using these reserved words as names for tables or columns is not recommended. Consequently, the DataMerger activity does not support these reserved words.

Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Database Version: 8.5.0 OS: All Supported Operating Systems

In the specific scenario where an individual intends to utilize reserved words as column names, the DataRequester activity becomes essential. This activity allows users to manually input SQL statements, enabling them to use square brackets '[]' around reserved column names. To configure the DataRequester activity for this purpose, follow the steps below:

Step 1:
When inserting data into a table with a reserved word as a column name, it is imperative to construct a SQL statement that encapsulates the reserved column name within square brackets '[],' adhering to SQL conventions.

Step 2:
Configure the Data Requester activity by setting up the DBRequester service and selecting the Mode as Request Reply/RPC. In the input tab of the Data Requester activity, input the SQL statement with square brackets around reserved column names, like so:
 
INSERT INTO Table_Name (Column1, [Column2], Column3,.....) VALUES (value1, value2, value3, ...);

How to handle reserved words as column names in the TIBCO ActiveMatrix BusinessWorks Plug-in for Database