Skip to main content

[Migrated content. Thread originally posted on 24 June 2004]

This question is mostly for the Acucorp technical staff.
Can a SQL Server stored procedure be executed from an Acucobol
program?
The following code compiles cleanly:
EXEC SQL
EXECUTE sp_verify_tbl_payrolldata
END-EXEC

But when I run the program I get a return code of -1 and an error
message of "unknown statement: sp_verify_tbl_payrolldata"

sp_verify_tbl_payrolldata is the stored procedure I am trying to call. The program has successfully connected to the database where it resides.

Thank You

[Migrated content. Thread originally posted on 24 June 2004]

This question is mostly for the Acucorp technical staff.
Can a SQL Server stored procedure be executed from an Acucobol
program?
The following code compiles cleanly:
EXEC SQL
EXECUTE sp_verify_tbl_payrolldata
END-EXEC

But when I run the program I get a return code of -1 and an error
message of "unknown statement: sp_verify_tbl_payrolldata"

sp_verify_tbl_payrolldata is the stored procedure I am trying to call. The program has successfully connected to the database where it resides.

Thank You
You may want to try "execute sp_xxx", which is the proper SQL Server syntax for executing stored procedures.