Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I call a SQL stored procedu

Status
Not open for further replies.

rummage

MIS
Apr 8, 2003
33
US
How can I call a SQL stored procedure from Webfocus? I need the code.

Thanks
 
Try this :

SET SQLENGINE=SQLMSS
SQL SQLMSS SET USER LocalServer/id,pwd
SQL
EX mysqlproc;

TABLE FILE SQLOUT
PRINT *
END
 
Thanks for the answer. I am having another issue. I am trying to call a stored procedure using two parameters. The parameters are '40709297-9D5F-4D26-BF76-9159F0D664D9','0'

It is giving me two errors.
First when I save this, it says
'One of the line is longer than 80 char. Do you want to save?'
After I save and run, I get the SQL code error 170. Incorrect syntax.

The complete code is the following. Please help me fix it.

SQL SQLMSS
EX GOA01_SQL.dbo.spgoa_GetSummaryDataA '40709297-9D5F-4D26-BF76-9159F0D664D9','0';
TABLE FILE SQLOUT
PRINT *
END
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top