1! NOT DETERMINISTIC 1? 1 DETERMINISTIC 2! MODIFIES SQL DATA 2? 2 READS SQL DATA 2 CONTAINS SQL 3! CALLED ON NULL INPUT 4? DYNAMIC RESULT SETS integer 5? 5 DISALLOW DEBUG MODE 5 ALLOW DEBUG MODE 5 DISABLE DEBUG MODE 6? 6 PARAMETER CCSID ASCII 6 PARAMETER CCSID EBCDIC 6 PARAMETER CCSID UNICODE 7? QUALIFIER schema-name 8? PACKAGE OWNER authorization-name 9! ASUTIME NO LIMIT 9? 9 ASUTIME LIMIT integer 10! COMMIT ON RETURN NO 10? 10 COMMIT ON RETURN YES 10 AUTONOMOUS 11! INHERIT SPECIAL REGISTERS 11? 11 DEFAULT SPECIAL REGISTERS 12? WLM ENVIRONMENT FOR DEBUG MODE name 13? 13 DEFER PREPARE 13 NODEFER PREPARE 14! CURRENT DATA NO 14? 14 CURRENT DATA YES 15! DEGREE 1 15? 15 DEGREE ANY 16? 16 CONCURRENT ACCESS RESOLUTION USE CURRENTLY COMMITTED 16 CONCURRENT ACCESS RESOLUTION WAIT FOR OUTCOME 17! DYNAMICRULES RUN 17? 17 DYNAMICRULES BIND 17 DYNAMICRULES DEFINEBIND 17 DYNAMICRULES DEFINERUN 17 DYNAMICRULES INVOKEBIND 17 DYNAMICRULES INVOKERUN 18? 18 APPLICATION ENCODING SCHEME ASCII 18 APPLICATION ENCODING SCHEME EBCDIC 18 APPLICATION ENCODING SCHEME UNICODE 19! WITHOUT EXPLAIN 19? 19 WITH EXPLAIN 20! WITHOUT IMMEDIATE WRITE 20? 20 WITH IMMEDIATE WRITE 21! ISOLATION LEVEL CS 21? 21 ISOLATION LEVEL RS 21 ISOLATION LEVEL RR 21 ISOLATION LEVEL UR 22! WITHOUT KEEP DYNAMIC 22? 22 WITH KEEP DYNAMIC 23! OPTHINT '' 23? 23 OPTHINT string-constant 24? SQL PATH 24.1+ , 24.1.0 schema-name 24.1.0 SYSTEM PATH 24.1.0 SESSION USER 24.1.0 USER 24.1.1! RELEASE AT COMMIT 24.1.1? 24.1.1 RELEASE AT DEALLOCATE 25? 25 QUERY ACCELERATION NONE 25 QUERY ACCELERATION ENABLE 25 QUERY ACCELERATION ENABLE WITH FAILBACK 25 QUERY ACCELERATION ELIGIBLE 25 QUERY ACCELERATION ALL 26? 26 GET_ACCEL_ARCHIVE NO 26 GET_ACCEL_ARCHIVE YES 27? 27 ACCELERATOR accelerator-name 28! REOPT NONE 28? 28 REOPT ALWAYS 28 REOPT ONCE 29! VALIDATE RUN 29? 29 VALIDATE BIND 30? 30 ROUNDING DEC_ROUND_CEILING 30 ROUNDING DEC_ROUND_DOWN 30 ROUNDING DEC_ROUND_FLOOR 30 ROUNDING DEC_ROUND_HALF_DOWN 30 ROUNDING DEC_ROUND_HALF_EVEN 30 ROUNDING DEC_ROUND_HALF_UP 30 ROUNDING DEC_ROUND_UP 31? 31 DATE FORMAT ISO 31 DATE FORMAT EUR 31 DATE FORMAT USA 31 DATE FORMAT JIS 31 DATE FORMAT LOCAL 32? 32 DECIMAL(15) 32 DECIMAL(31) 32 DECIMAL(15,s) 32 DECIMAL(31,s) 33! FOR UPDATE CLAUSE REQUIRED 33? 33 FOR UPDATE CLAUSE OPTIONAL 34? 34 TIME FORMAT ISO 34 TIME FORMAT EUR 34 TIME FORMAT USA 34 TIME FORMAT JIS 34 TIME FORMAT LOCAL 35! BUSINESS_TIME SENSITIVE YES 35? 35 BUSINESS_TIME SENSITIVE NO 36! SYSTEM_TIME SENSITIVE YES 36? 36 SYSTEM_TIME SENSITIVE NO 37! ARCHIVE SENSITIVE YES 37? 37 ARCHIVE SENSITIVE NO 38? 38 APPLCOMPAT compatibility-level