• How to run a prepared statement (QBMLimitedSQL) with parameters from a process step?

    Hi One Identity Manager Community,

    We have some complex SQL scripts that are run from processes that we would like to store as prepared statements (QBMLimitedSQL) rather than as the parameter to a SQLComponent task.

    So far I have not been able to find…

  • Parameter not getting injected into Stored-SQL

    I'm trying to execute a SQL statement with an embedded @parameter, and am receiving the error...

    VI.DB.DatabaseException: Database error 137: Must declare the scalar variable "@FromDate".

    I've uploaded a SQL statement with an @parameter…