Cisco Cisco Process Orchestrator 3.1 User Guide

Click the Configuration tab to specify the character restrictions for a database identifier. A distinction 
is made between simple identifiers and special identifiers.

Click the Permission tab to define the type of SQL commands that can run on the target.

Click OK to close the dialog box and complete the procedure.

This script executes an SQL script against a Generic (OLEDB) database.

In the Process Editor Toolbox, choose the [Generic (OLEDB) SQL Database Activity] property page, 
then click the Execute Generic Database SQL Script tab.

Specify the information that describes the script you want to run, including the SQL script text for the 
selected database. For example, to encrypt data using the ODBC ENCRYPT function:

create proc #tfn

as

select { fn USER() } , { fn CURRENT_DATE() },

{ fn CURRENT_TIME() }, { fn CURRENT_TIMESTAMP() }

go

exec #tfn

go

drop proc #tfn

In the Columns panel, click Add to display the Table Column properties dialog box and define the table 
column and data type to be displayed.

Enter the other criteria as necessary.