October 18, 2007, 02:30 AM
IngasEX 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
October 18, 2007, 10:15 AM
RichHHi Alex,
As far as I am aware, the EX/EXEC are equivalent.
Are you getting an error or having a problem?
Rich
October 18, 2007, 10:23 AM
Gobinath VelusamyI think both are equl.....
October 19, 2007, 01:35 AM
IngasThanks for your replies.
I just wanted to clear this topic.
October 22, 2007, 07:51 PM
GCohenIn the situation described you are probably better off using the command -INCLUDE, rather than EXEC e.g.
SQL SQLMSS
-INCLUDE fexname
END