Db2约束查询给出错误

Question

我试图添加以下约束到我的DB2表，但它给出了错误。

    ALTER TABLE Table_name ADD CONSTRAINT VALID_BINDING 
    CHECK((LOWER(REQ_BINDING) IN ('http-post','http-redirect'))
    AND ((LOWER(RESP_BINDING) IN ('http-post','http-redirect')));

错误堆栈跟踪

DB21034E  The command was processed as an SQL statement because it was not a 
valid Command Line Processor command.  During SQL processing it returned:
SQL0104N  An unexpected token "END-OF-STATEMENT" was found following "',
'http-redirect')))".  Expected tokens may include:  ")".  SQLSTATE=42601
SQL0104N  An unexpected token "END-OF-STATEMENT" was found following "','http-redirect')))".  Expected tokens may include:  ")                               ".
Explanation: 
A syntax error in the SQL statement or the input command string 
for the SYSPROC.ADMIN_CMD procedure was detected at the specified 
token following the text "<text>".  The "<text>" field indicates 
the 20 characters of the SQL statement or the input command 
string for the SYSPROC.ADMIN_CMD procedure that preceded the 
token that is not valid.  
 As an aid, a partial list of valid tokens is provided in the 
SQLERRM field of the SQLCA as "<token-list>".  This list assumes 
the statement is correct to that point.  
 The statement cannot be processed. 

Answer 1

缺少括号。

ALTER TABLE Table_name ADD CONSTRAINT VALID_BINDING 
    CHECK((LOWER(REQ_BINDING) IN ('http-post','http-redirect'))
    AND ((LOWER(RESP_BINDING) IN ('http-post','http-redirect'))));