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