Supported SQL

The RSSBus BizTalk Adapter for NetSuite supports several basic operations on data, including querying, deleting, modifying, and inserting. These operations are performed using SQL that is close to standard SQL, but may have minor differences described here.

The adapter does not support batching of SQL statements. To execute multiple commands, create multiple instances and execute each separately.

SELECT Statements

SELECT statements generally follow the standard SQL syntax. For more information and specific examples, see SELECT Statements.

UPDATE Statements

UPDATE statements generally follow the standard SQL syntax, but the adapter supports updating only one row at a time. Hence, the primary key Id is always required. For more information and specific examples, see UPDATE Statements.

INSERT Statements

INSERT statements generally follow the standard SQL syntax. For more information and specific examples, see INSERT Statements.

DELETE Statements

DELETE statements generally follow the standard SQL syntax, but the adapter supports deleting only one row at a time. Hence, the primary key Id is always required. For more information and specific examples, see DELETE Statements.

CACHE Statements

CACHE statements allow you to have direct control over the cached data. The CacheLocation must be specified in order to use cache statements. For more information and specific examples, see CACHE Statements.

Names and Quoting

• Table and column names are considered identifier names; as such, they are restricted to the following characters: [A-Za-z0-9_:@].
• To use a table or column name with characters not listed above, the name must be quoted using square brackets ([name]) in any SQL statement.
• Parameter names start with the @ symbol (e.g., @p1 or @CustomerName) and cannot be quoted.
• Strings should be quoted using single quotes (e.g., 'John Doe').