<div>
<div class="content wysiwyg-content">
I am using DBArtisan 9.1.2 and I want to recompile a Sybase stored procedure that exists because I have to modify the stored procedure. How would I do so?<br />
<br />
The stored procedure starts out as ...<br />
<br />
create procedure dbo.usp_CalculateImportedI<wbr />tems<br />
as<br />
declare @err &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;int<br />
BEGIN<br />
declare @BalanceRecordCount int<br />
declare @PendingRecordCount int<br />
declare @WiredRecordCount int<br />
declare @OpenItemsRecordCount int<br />
declare @IntellimatchRecordCount int<br />
declare @AutoImportDate datetime<br />
declare @ManualImportDate datetime<br />
<br />
BEGIN &nbsp;TRANSACTION
</div>
</div>


I am using DBArtisan 9.1.2 and I want to recompile a Sybase stored procedure that exists because I have to modify the stored procedure. How would I do so?

The stored procedure starts out as ...

create procedure dbo.usp_CalculateImportedItems
as
declare @err                  int
BEGIN
declare @BalanceRecordCount int
declare @PendingRecordCount int
declare @WiredRecordCount int
declare @OpenItemsRecordCount int
declare @IntellimatchRecordCount int
declare @AutoImportDate datetime
declare @ManualImportDate datetime

BEGIN  TRANSACTION

I am using DBArtisan 9.1.2 and I want to recompile a Sybase stored procedure that exists because I have to modify the stored procedure. How would I do so?

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.