Query fails using bteq but works fine with queryman

Tools
N/A

Query fails using bteq but works fine with queryman

Hi,

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

TGT.id=SRC.id;

where table test1 and test2 are having three columns id(PK),name and age

Error :

$
*** 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.

Thanks,
Kunal

2 REPLIES

Re: Query fails using bteq but works fine with queryman

Change != to <> ..it will work..
N/A

Re: Query fails using bteq but works fine with queryman

Thanks a lot...

It is working.................

Kunal