Re: SPL issue

[Javier Sanchez <javiersanchezbarquero@xxxxxxxxx>]

Kind of weird, huh?
Can you give the above code?

Javier

El lun, 25 abr 2022 a las 13:35, Rob Berendt (<rob@xxxxxxxxx>) escribió:

> Let me try to simplify an earlier email.
> I have these lines as part of a Stored Procedure
>
> ...
>           DECLARE WORK_YEAR INT;
>           DECLARE BREAK_YEAR INT;
> ...
>              IF WORK_YEAR > BREAK_YEAR then
> ...
>                 SET BREAK_YEAR = WORK_YEAR;
>              END IF; -- Control break on year
> I am running this in the system debugger.
> I see that work_year=2014 and break_year=0 yet it jumps from the if to the
> end if.
> Why is that?
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  7310 Innovation Blvd, Suite 104
>           Ft. Wayne, IN 46818
> Ship to:  7310 Innovation Blvd, Dock 9C
>           Ft. Wayne, IN 46818
> http://www.dekko.com
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com