Database schema names, otherwise known as the OwnerID, are important when making queries and stored procedures in CA Aion Business Rules Expert. In the rare event that the OwnerID is not automatically set from within the Connection instance, it is possible to programmatically force the assignment to OwnerID to ensure a successful connection, and consequently also a Query and a Stored Procedure.
Sample code on how to programmatically force a schema name, in case the Connection properties fail to do so.
//Note that ConnectionName is the name of the user-defined Connection instance to the database.
var dummy Integer //output for the returned number of rows (this is a placeholder used in the Execute request)
var RCode boolean //for whether the connection has successfully connected
RCode = ConnectionName.Connect(FALSE)
if Platform = OS_UNIX
RCode = ConnectionName.Execute("Set current schema " & <String object>,dummy)
if retcode <> 0 then
MessageBox("Set current schema " & <String object> & " was unsuccessful")
// ...discontinue processing, or try another <String object>
// Your <String object> can be a string, or any operation that constructs a string,
// preferably one that corresponds to an existing schema in the database.