0 - 2 of 2 tags for create table errors

Hi everyone,
 
Im trying to create a table but when try to run it, it says:  
EXPLAIN Failed.  [3707] Syntax error, expected something like a 'CHECK' keyword between ',' and the 'SUM' keyword.
Is there someone out there who knows what this might mean?

Hi, I have a simple SQL where I am trying to create a table using a select statement, I have no idea why this is bumping me out. The select by itself is working and returning rows successfully. Please help.

This is the SQL -

create table dbc.tb2 as
(select
Rcrd_No,
compltn_dt,
substr(compltn_dt,1,position(' ' in compltn_dt )) as dt,
trim(substr(compltn_dt,position(' ' in compltn_dt )+1,characters(compltn_dt)))as ts,
Trim(case when position ('/' in dt) = 2 then 0||substring(dt,1,1) else substr(dt,1,2) end) as mth,