1! LANGUAGE SQL 1? 2? 2 SPECIFIC specific-name 3! NOT DETERMINISTIC 3? 3 DETERMINISTIC 4! EXTERNAL ACTION 4? 4 NO EXTERNAL ACTION 5! READS SQL DATA 5? 5 CONTAINS SQL 5 MODIFIES SQL DATA 6! CALLED ON NULL INPUT 6? 6 RETURNS NULL ON NULL INPUT 7! STATIC DISPATCH 7? 8? 8 ALLOW PARALLEL 8 DISALLOW PARALLEL 9? 9 DISALLOW DEBUG MODE 9 ALLOW DEBUG MODE 9 DISABLE DEBUG MODE 10? 10 PARAMETER CCSID ASCII 10 PARAMETER CCSID EBCDIC 10 PARAMETER CCSID UNICODE 11? 11 QUALIFIER schema-name 12? 12 PACKAGE OWNER authorization-name 13! ASUTIME NO LIMIT 13? 13 ASUTIME LIMIT integer 14! INHERIT SPECIAL REGISTERS 14? 14 DEFAULT SPECIAL REGISTERS 15? 15 WLM ENVIRONMENT FOR DEBUG MODE name 16! CURRENT DATA NO 16? 16 CURRENT DATA YES 17! DEGREE 1 17? 17 DEGREE ANY 18? 18 CONCURRENT ACCESS RESOLUTION USE CURRENTLY COMMITTED 18 CONCURRENT ACCESS RESOLUTION WAIT FOR OUTCOME 19! DYNAMICRULES RUN 19? 19 DYNAMICRULES BIND 19 DYNAMICRULES DEFINEBIND 19 DYNAMICRULES DEFINERUN 19 DYNAMICRULES INVOKEBIND 19 DYNAMICRULES INVOKERUN 20? 20 APPLICATION ENCODING SCHEME ASCII 20 APPLICATION ENCODING SCHEME EBCDIC 20 APPLICATION ENCODING SCHEME UNICODE 21! WITHOUT EXPLAIN 21? 21 WITH EXPLAIN 22! WITHOUT IMMEDIATE WRITE 22? 22 WITH IMMEDIATE WRITE 23! ISOLATION LEVEL CS 23? 23 ISOLATION LEVEL RS 23 ISOLATION LEVEL RR 23 ISOLATION LEVEL UR 24! OPTHINT '' 24? 24 OPTHINT string-constant 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? SQL PATH 28.1.0+ , 28.1.0 schema-name 28.1.0 SYSTEM PATH 28.1.0 SESSION USER 28.1.0 USER 28.1.1! REOPT NONE 28.1.1? 28.1.1 REOPT ALWAYS 28.1.1 REOPT ONCE 28.1.1.1! VALIDATE RUN 28.1.1.1? 28.1.1.1 VALIDATE BIND 28.1.1.1.1? 28.1.1.1.1 ROUNDING DEC_ROUND_CEILING 28.1.1.1.1 ROUNDING DEC_ROUND_DOWN 28.1.1.1.1 ROUNDING DEC_ROUND_FLOOR 28.1.1.1.1 ROUNDING DEC_ROUND_HALF_DOWN 28.1.1.1.1 ROUNDING DEC_ROUND_HALF_EVEN 28.1.1.1.1 ROUNDING DEC_ROUND_HALF_UP 28.1.1.1.1 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! NOT SECURED 33? 33 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 compatibility-level