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