[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