1 DYNAMIC RESULT SETS integer EXTERNAL NAME 2 external-program-name 2 identifier 3 NOT DETERMINISTIC 3 DETERMINISTIC 4 MODIFIES SQL DATA 4 READS SQL DATA 4 CONTAINS SQL 5 NO COLLID 5 COLLID collection-id 6 WLM ENVIRONMENT 7 name 7 ( name , * ) 8 ASUTIME 9 NO LIMIT 9 LIMIT integer 10 STAY RESIDENT 11 NO 11 YES 12 PROGRAM TYPE 13 SUB 13 MAIN 14 SECURITY 15 DB2 15 USER 15 DEFINER 16 COMMIT ON RETURN 17 NO 17 YES 18 RUN OPTIONS run-time-options 19 INHERIT SPECIAL REGISTERS 19 DEFAULT SPECIAL REGISTERS 20 STOP AFTER SYSTEM DEFAULT FAILURES 20 STOP AFTER integer FAILURES 20 CONTINUE AFTER FAILURES