Access 97 Check Form for Records BATCH Poor Mans Cron Job C# Call Webservice from Javascript C++ Function Prototype CL CHGVAR Use HTML Easy Popups Enlarge HTML Controls Javascript Arrow Key Navigation Count Characters Load Stylesheet by Resolution MYSQL Return n number random records PHP Generate a Thumbnail Image RPG IV CHAIN using ~percent~Found Create Procedure SQL 2000 Apply a Custom Sort Order Auto-increment on insert Comma-delimited list from sql

  

  RPG IV - Create Procedure (Add To Favorites)

CREATE PROCEDURE ASPE3AUD()
  RESULT SETS 1
  LANGUAGE SQL
  READS SQL DATA
BEGIN
  DECLARE c1 CURSOR WITH RETURN FOR
  SELECT PLCTRL, PLMPOG, PLYEAR,
  PLPER, PLWEEK, PLPOGEF
  FROM PLNCAL
  ORDER BY PLCTRL;
  OPEN c1;
  SET RESULT SETS CURSOR c1;
END