Forum Discussion

vmanojrc30's avatar
vmanojrc30
Contributor
2 years ago
Solved

Calling DB Stored Procedures from OS

I want to execute a list of DB Stored procedures after executing a DM step in OS. Is it possible to call a DB Stored Procedure from OS?After the Stored Procedures are run, I want to execute a list of...
Data Integration
  • Steven's avatar
    Steven
    2 years ago

    Yes, you can call a stored procedure from OS:

    Do something like this in a business rule:

     

    Using dbConnApp = BRApi.Database.CreateApplicationDbConnInfo(si)
    BRApi.Database.ExecuteActionQuery(dbConnApp, "EXEC [StoredProc]", True, True)
    End Using

Steven's avatar
Steven
Contributor II
2 years ago

[StoredProc] is the name of the stored procedure you are running.

I have a stored procedure named TruncateMyTable

I would be: Exec TruncateMyTable

 

vmanojrc30's avatar
vmanojrc30
Contributor
2 years ago

Thanks I will try that