Enter the parameter value for end -- stop popup

General
Enthusiast

Enter the parameter value for end -- stop popup

I am getting popup message as 'enter the parameter value for end'while creating view .. but its getting executed good while firing select statment ... as per my knoweledge .. i was getting error because of + used in that...  Can you please tell me how can we achive without + ..or My main concern is that while crreating view i should not give popup message

create view date_check_vw(ValidDate) as

select

CASE

  WHEN   (20000121 / 10000 BETWEEN 1900 AND 9999)  -- correct year, adjust to your minimum date

    AND  (20000121 / 100 MOD 100 BETWEEN 1 AND 12) -- correct month

    AND ((20000121 / 100 MOD 100 IN (1,3,5,7,8,10,12) AND 20000121 MOD 100 BETWEEN 1 AND 31)

      OR (20000121 / 100 MOD 100 IN (4,6,9,11) AND 20000121 MOD 100 BETWEEN 1 AND 30)

      OR (20000121 / 100 MOD 100 = 2 AND 20000121 MOD 100 BETWEEN 1 AND 28

          + CASE WHEN (((20000121 / 10000) MOD 4 = 0) AND ((20000121 / 10000) MOD 100 <> 0))

                   OR  ((20000121 / 10000) MOD 400 = 0) THEN 1 ELSE 0 -- leap year?

            END)) -- day between 1 and 28/29/30/31

  THEN 'hi'

ELSE 'hello'

END AS ValidDate

1 REPLY
Teradata Employee

Re: Enter the parameter value for end -- stop popup

Is this in SQL Assistant? If so, what version?

Looks like improper parsing of the comment style. Workaround is to remove the ? after "leap year" or switch to /* ... */ comment style.