title: Create table in DB2
body: <p>I am new to DB2. I tried creating a table with the following query:</p>
  
  <pre><code>CREATE TABLE DB2ADMIN.CERTIFICATE_TAB
  (
      CERT_ID                     CHAR(36) NOT NULL,
      CERT_TRS_SEQ_NBR            SMALLINT(5) NOT NULL,
      EFFECTIVE_DT                DATE NOT NULL,
      CERT_EFF_TYPE_CD            CHAR(1) NOT NULL,
      CERT_STATUS_CD              CHAR(1) NOT NULL,
      CERT_VER_NBR                SMALLINT(5),
      EXPIRATION_DT               DATE NOT NULL,
      CERT_NBR                    INTEGER(10),
      CERT_ISSUE_CD               CHAR(1),
      CERT_DTB_CD                 CHAR(1),
      CERT_ERROR_CD               CHAR(10),
      FORM_AS_OF_DT               DATE,
      CERT_RNL_STATUS_CD          CHAR(1),
      CERT_CTU_CNC_IND            CHAR(1),
      CERT_FLD_ISS_IND            CHAR(1),
      CERT_MANUAL_IND             CHAR(1),
      CERT_FLD_ISS_BY_CD          CHAR(1),
      MNL_ADDENDUM_IND            CHAR(1),
      FORM_LEVEL1_CD              CHAR(10),
      FORM_LEVEL2_CD              CHAR(10),
      DOC_ON_FILE_IND             CHAR(1),
      STD_POL_IND                 CHAR(1),
      WET_SIGN_IND                CHAR(1),
      CERT_USER_ID                CHAR(25),
      CERT_ROUTE_PATH_CD          CHAR(10),
      CERT_USER_TXT               VARCHAR(255),
      CERT_ERROR_DES              VARCHAR(2000),
      LAST_MDF_USER_ID            CHAR(25) NOT NULL,
      ISSUE_ACY_TS                TIMESTAMP(26,6),
      LAST_MDF_ACY_TS             TIMESTAMP(26,6) NOT NULL,
      CONSTRAINT SQL120103120640250 PRIMARY KEY (CERT_ID, CERT_TRS_SEQ_NBR),
      CONSTRAINT CMSICER1 UNIQUE (CERT_ID, CERT_TRS_SEQ_NBR)
  );
  </code></pre>
  
  <p>However I got the below error</p>
  
  <p>Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=SMALLINT;CERT_TRS_SEQ_NBR;CHARACTER, DRIVER=3.50.152
   SQLState:  42601
   ErrorCode: -104</p>
  
  <p>Could someone plz point out what mistake am I doin?</p>