This table lists how DB2 sql dialect was supported by general sql parser.
There are two supporting levels accroding to how general sql parser handle that sql.
| All
sqls |
Level 1 |
Level 2 |
| allocate
cursor |
Y |
|
| alter
bufferpool |
Y |
|
| alter
database partition group |
Y |
|
| alter
function |
Y |
|
| alter
method |
Y |
|
| alter
nickname |
Y |
|
| alter
procedure |
Y |
|
| alter
sequence |
Y |
|
| alter
server |
Y |
|
| alter
table |
Y |
Y |
| alter
tablespace |
Y |
|
| alter
type |
Y |
|
| alter
user mapping |
Y |
|
| alter
view |
Y |
|
| alter
wrapper |
Y |
|
| associate
locators |
Y |
|
| begin
declare section |
Y |
|
| call |
Y |
Y |
| case |
Y |
|
| close |
Y |
Y |
| comment |
Y |
|
| commit |
Y |
|
| connect |
Y |
Y |
| create
alias |
Y |
|
| create
bufferpool |
Y |
|
| create
database partition group |
Y |
|
| create
distinct type |
Y |
|
| create
event monitor |
Y |
|
| create
function |
Y |
Y |
| create
function mapping |
Y |
|
| create
index |
Y |
Y |
| create
index extension |
Y |
|
| create
method |
Y |
|
| create
nickname |
Y |
|
| create
procedure |
Y |
Y |
| create
schema |
Y |
|
| create
sequence |
Y |
|
| create
server |
Y |
|
| create
table |
Y |
Y |
| create
tablespace |
Y |
|
| create
transform |
Y |
|
| create
trigger |
Y |
Y |
| create
type |
Y |
|
| create
user mapping |
Y |
|
| create
view |
Y |
Y |
| create
wrapper |
Y |
|
| declare
cursor |
Y |
Y |
| declare
global temporary table |
Y |
|
| delete |
Y |
Y |
| describe |
Y |
|
| disconnect |
Y |
|
| drop |
Y |
|
| drop
index |
Y |
Y |
| drop
table |
Y |
Y |
| drop
view |
Y |
Y |
| end
declare section |
Y |
|
| execute |
Y |
Y |
| execute
immediate |
Y |
|
| explain |
Y |
|
| fetch |
Y |
Y |
| flush
event monitor |
Y |
|
| flush
package cache |
Y |
|
| for |
Y |
Y |
| free
locator |
Y |
|
| get
diagnostics |
Y |
|
| goto |
Y |
Y |
| grant |
Y |
|
| if |
Y |
Y |
| include |
Y |
|
| insert |
Y |
Y |
| iterate |
Y |
Y |
| leave |
Y |
Y |
| lock
table |
Y |
|
| loop |
Y |
Y |
| merge |
Y |
Y |
| open |
Y |
Y |
| prepare |
Y |
Y |
| refresh
table |
Y |
Y |
| release |
Y |
|
| rename |
Y |
|
| rename
tablespace |
Y |
|
| repeat |
Y |
Y |
| resignal |
Y |
|
| return |
Y |
Y |
| revoke |
Y |
|
| rollback |
Y |
|
| savepoint |
Y |
|
| select |
Y |
Y |
| select
into |
Y |
Y |
| set
connection |
Y |
|
| set
current default transform group |
Y |
Y |
| set
current degree |
Y |
Y |
| set
current explain mode |
Y |
Y |
| set
current explain snapshot |
Y |
Y |
| set
crrent isolation |
Y |
Y |
| set
current lock timeout |
Y |
Y |
| set
current maintained table types for optimization |
Y |
Y |
| set
current package path |
Y |
Y |
| set
current pacakgeset |
Y |
Y |
| set
current query optimization |
Y |
Y |
| set
curent refresh age |
Y |
Y |
| set
encryption password |
Y |
|
| set
event monitor state |
Y |
|
| set
integrity |
Y |
Y |
| set
passthru |
Y |
|
| set path |
Y |
|
| set
schema |
Y |
|
| set
server option |
Y |
|
| set
session authorization |
Y |
|
| set
variable |
Y |
Y |
| signal |
Y |
Y |
| upate |
Y |
Y |
| values |
Y |
Y |
| values
into |
Y |
|
| whenever |
|
|
| while |
Y |
Y |
|
|
|