You can control the ODBC access cycle of Silk Performer with the following parameters:
The reprepare parameter can be enabled/disabled in the Silk Performer ODBC settings (menu Settings/ODBC Settings/Reprepare SQL commands). If the reprepare parameter is enabled, Silk Performerprepares a SQL statement (using the ODBC function SQLPrepare) every time it is called, regardless of whether it is active. The setting of reprepare is effective over the whole Silk Performer script. On default the reprepare parameter is disabled.
The autocommit parameter can be enabled/disabled in the Silk PerformerODBC settings (menu Settings/ODBC Settings/Auto commit). If the autocommit parameter is enabled, the database is committed automatically after each SQL command. Otherwise, the database is committed only after an explicit commit statement or at the end of a Silk Performer transaction. The parameter setting is effective over the whole Silk Performer script.
If you are using a dynamic SQL statement, Silk Performer uses the ODBC function SQLExecDirect to execute the SQL statement instead of using SQLPrepare and SQLExecute. For how to use dynamic SQL in Silk Performer, see Dynamic SQL.