Highlighted
Absent Member.
Absent Member.
581 views

[archive] Calling Stored Procedures

[Migrated content. Thread originally posted on 18 March 2003]

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
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.