Defining statements for database connection points

To define statements to read or write a database through a database connection point is explained with several examples. The sample SQL statements that are provided are MS SQL Server-specific. For similar examples of stored procedures in other supported types of database connection points, see the appropriate sub sections.

Note: These examples show how you can use statements in ION Connect. The examples must not be regarded as the only or the preferred approach and they might not fit each actual business case.

While reading from a database, the result set of the SQL query or the stored procedure must be returned as type VARCHAR or CLOB. No other types are supported.