Skip to content
Advertisement

Tag: sql-pl

DB2 SQLPL – Unable to exit Infinite loop

I have a stored procedure created to calculate the standard deviation by hand by going through each row in Employees Table in DB2 Sample Database – However, the procedure is stuck in an infinite loop. I am not sure as to why it is stuck as i expected the SQLSTATE to not be ‘00000’ after reading last row on table

Advertisement