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