All Forums Database
poonam 7 posts Joined 03/06
20 Mar 2006

hi, can someone plz pass on the sql to create a macro and the syntax to call the macro from a shell script.thanks.

20 Mar 2006

create macro samplemacro(variable1 int, variable2 char(3))as(Update table1 set col1 = col1 * :variable1where col2 = :variable2;);in the shell scriptexec samplemacro(2,'ABC')orexec samplemacro(variable1=2, variable2='ABC')

You must sign in to leave a comment.