Non-Clinical RN Provide support to <strong>clinical</strong> and <strong>non</strong>-<strong>clinical</strong> individuals via phone and email â¢ This support pertains to <strong>clinical</strong> issues, data definitions. 3.1 95 Reviews etech.
OLE DB Command Transformation. The OLE DB Command transformation runs an SQL statement for each row in a data flow. For example, you can run an SQL statement that inserts, updates, or deletes rows in a database table. You can configure the OLE DB Command Transformation in the following ways: 1  Provide the SQL statement that the transformation runs for each row. 2  Specify the number of seconds before the SQL statement times out. 3  Specify the default code page.
A query generated via ODBC is functionally similar to a query generated by OLE DB. However, be aware that if you generate a query (via STATISTICA Query) using an ODBC connection, STATISTICA uses OLE DB to connect to the ODBC connection. Because there is an intermediate connection, ODBC queries may be slower than OLE DB queries.