Exit command in SQL script

[arpitasethi]

Hello Experts,

Is there an 'Exit' like command in SQL script (for script based calculation view)?

Thanks and Regards,

Arpita

[RichHeilman]

I've just tested this in a Rev61 system, and the RETURN statement works just fine for this.

CREATE PROCEDURE test_return ( in im_flag nvarchar(1))

          LANGUAGE SQLSCRIPT

          SQL SECURITY INVOKER

          --DEFAULT SCHEMA <default_schema_name>

          READS SQL DATA AS

BEGIN

/*****************************

          Write your procedure logic

*****************************/

  select 'This' from dummy;

select 'That' from dummy;

if :im_flag = 'Y' THEN

  RETURN;

end if;

select 'The Other' from dummy;

END;

Cheers,

Rich Heilman