RE: How to modify a stored procedure

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

> -----Message d'origine-----
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Charles Wilt
> But it'd seem to me that while STRSQL doesn't want the final
> ; it'd still need any in the middle...
> CREATE PROCEDURE FOXWELL/DOAATN001 (
>        IN CLIENT_NO NUMERIC(9, 0) )
>
>    CASE
>        WHEN CLIENT_NO <> 0
>            THEN
>                  UPDATE DOAATN SET STRTFL = 'N', SMAJHT = CURRENT TIME
>                   WHERE SCLTNO = CLIENT_NO;
>
>            ELSE
>                  UPDATE DOAATN SET STRTFL = 'N', SMAJHT =
> CURRENT TIME;
>    END CASE

Now it's saying that CASE is misplaced. If I take off the CASE and just have the UPDATE, then UPDATE is misplaced. Ok, Friday afternoon's not the best time to try. Try again Monday morning!



> In any event, while I can see creating a procedure using iNav
> the first time, I'd never use it to modify (ie. recreate an existing).
> I'd generate the source statements and work with those from then on.

Its exactly what I'm trying to do! But I can't get a source file that will run with RUNSQLSTM.

Thanks