Focal Point
EX and EXEC for MSSQL-procedures.

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3481064252

October 18, 2007, 02:30 AM
Ingas
EX and EXEC for MSSQL-procedures.
Greetings,

I'm little puzzled : is EX and EXEC in
[code]
SQL SQLMSS
EX/EXEC [procedure];
END

are equivalent or different?

Documentation talks only about MAINTAIN language command EX.

My suspicions are :
1. They differs: EX - for procedures without output, EXEC - for procedures with output
2. They are equivalent.

Can somebody clear this?

Alex


WF 7.6.2, WinNT/2K, MSSQL 2K, MSOLAP 2K, BID
October 18, 2007, 10:15 AM
RichH
Hi Alex,

As far as I am aware, the EX/EXEC are equivalent.
Are you getting an error or having a problem?

Rich


WebFOCUS 8202 Win 2012
Test - WebFOCUS 8203 on Win 2012
October 18, 2007, 10:23 AM
Gobinath Velusamy
I think both are equl.....


WebFOCUS 7610
Windows
October 19, 2007, 01:35 AM
Ingas
Thanks for your replies.

I just wanted to clear this topic.


WF 7.6.2, WinNT/2K, MSSQL 2K, MSOLAP 2K, BID
October 22, 2007, 07:51 PM
GCohen
In the situation described you are probably better off using the command -INCLUDE, rather than EXEC e.g.

SQL SQLMSS
-INCLUDE fexname
END


Release 7.6.9
Windows
HTML