Query fails using bteq but works fine with queryman
I am using below mentioned query. This query works fine when i am using it in queryman but when i use this query through bteq then i am getting syntax error. I am unable to find any solution.
Please help me out in this problem.
select (case when SRC.name != TGT.name then tgt.name when SRC.name is null or TGT.name is null then tgt.name end) name, (case when SRC.age != TGT.age then tgt.age when SRC.age is null or TGT.age is null then tgt.age end) age from User1.test1 SRC,User1.test2 TGT where
where table test1 and test2 are having three columns id(PK),name and age
$ *** Failure 3707 Syntax error, expected something like an 'IN' keyword betw een the word 'name' and '|'. Statement# 1, Info =31 *** Total elapsed time was 1 second.