2 2 10 SQL Database Activities

LANSA Composer

2.2.10 SQL Database Activities

SQL_CALL

Execute an SQL stored procedure

SQL_CALLQRYCSV

Query database using an SQL stored procedure to CSV

SQL_CALLQUERY

Query database using an SQL stored procedure

SQL_COMMIT

Commit a database transaction using SQL

SQL_CONNECT

Connect to database using SQL

SQL_DISCONNECT

Disconnect from database using SQL

SQL_PARAMS

Set parameter values for SQL operation

SQL_PARAMSCSV

Set parameter values for SQL operation from CSV

SQL_QUERY

Query database using SQL

SQL_QUERYTOCSV

Query database using SQL to output CSV file

SQL_ROLLBACK

Rollback a database transaction using SQL

SQL_UPDATE

Update database using SQL