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