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