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