TMG
03-18-2003, 11:29 AM
Hi, I am new to Acucorp's products - I am accessing MS SQL using AcuSQL, and I have not been able to successfully pre-compile my Cobol pgm with a call to a stored procedure. I obviously do not have either the syntax right, or do not have the precompiler options set correctly.
I am precompiling as follows:
\\dir01\acusql521\ACUSQL.EXE -Pk MSSQL mysrcesq.cob -Pr mysrcegt.cob
and the call to my stored procedure looks like:
EXEC SQL CALL pGETNEXT
:PTBL-SQL,
:TBL-SQL,
:NUM-SQL,
:optbl OUTPUT,
:otbl OUTPUT,
:onbr OUTPUT,
:oname OUTPUT,
:oprompt OUTPUT,
:ofile OUTPUT,
:oactive OUTPUT,
:oStatus OUTPUT
END-EXEC.
When I precompile the source file, I get 'parse error at :PTBL-SQL'
Does anyone have any idea what I am doing wrong??
Thanks!
Patti
I am precompiling as follows:
\\dir01\acusql521\ACUSQL.EXE -Pk MSSQL mysrcesq.cob -Pr mysrcegt.cob
and the call to my stored procedure looks like:
EXEC SQL CALL pGETNEXT
:PTBL-SQL,
:TBL-SQL,
:NUM-SQL,
:optbl OUTPUT,
:otbl OUTPUT,
:onbr OUTPUT,
:oname OUTPUT,
:oprompt OUTPUT,
:ofile OUTPUT,
:oactive OUTPUT,
:oStatus OUTPUT
END-EXEC.
When I precompile the source file, I get 'parse error at :PTBL-SQL'
Does anyone have any idea what I am doing wrong??
Thanks!
Patti