topic [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "case" was found following "else in SAS Enterprise Guide

[IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "case" was found following "else

learn_SAS_23 — Fri, 30 Nov 2018 06:32:43 GMT

Dear Team,

am getting below error :

ERROR: CLI describe error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "case" was found following "else
rstf.END_TS end". Expected tokens may include: "FROM". SQLSTATE=42601

Re: [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "case" was found follow

r_behata — Wed, 21 Nov 2018 14:58:00 GMT

Looks like Your Case statement Nesting is incorrect . try expanding all the scenarios like this :

case 
	when dt.DATE_TIME_KEY+900 < rstf.END_TS then 
                            dt.DATE_TIME_KEY+900
	when dt.DATE_TIME_KEY+900 > rstf.END_TS then rstf.END_TS 
	when dt.DATE_TIME_KEY > START_TS then dt.DATE_TIME_KEY
	when dt.DATE_TIME_KEY < START_TS then rstf.START_TS
end

Re: [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "case" was found follow

Tom — Wed, 21 Nov 2018 15:06:39 GMT

In addition to your messed up CASE statement (statements?) are you really trying to SUM() dates?

What is in the variables DATE_TIME_KEY, END_TS and START_TS ?

Re: [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "case" was found follow

learn_SAS_23 — Fri, 30 Nov 2018 06:33:32 GMT

Thanks, for finding it