SELECT issue in TAFJ with multiple conditions

Hi All


This select works in TAFC but not works in TAFJ..

SELECT FBNK.COLLATERAL.TYPE WITH (@ID GE 100 AND @ID LE 399) OR (@ID GE 700 AND @ID LE 849) OR (@ID
GE 900 AND @ID LE 999)


But if we used one condition in select works in TAFJ itself....

SELECT FBNK.COLLATERAL.TYPE WITH (@ID GE 100 AND @ID LE 399)


when we using multiple conditions, its not working... If anyone had solution for this plz let me know

when we using same field in multiple conditions then select not works

Hi
Absolutely valid syntax, works in TAFC....
Maybe you try additional parentheses like:

Hi VK

Thanks for your inputs :)

we tried that too but not worked :(

Hi
you definitely have to address a bug report to Temenos.

In the meantime, you can produce a workaround - select 3 times (one criterion on each select) and then concatenate 3 resulting lists...

This is the TAFJ format:

SELECT * FROM FBNK_COLLATERAL_TYPE WHERE RECID >= 100 AND RECID <= 399

Hi

"GE" and ">=" are the same thing. Also, "LE" and "<=" are the same. So your SELECT is the same as one that worked.
What about "OR"? The topic starter claimed that OR didn't work.

"GE", "LE" etc not defined in SQL syntax\

"OR" is fine
SELECT * FROM FBNK_COLLATERAL_TYPE WHERE RECID = 100 OR RECID = 399

Hi

Your example contains one OR only and not (... AND ..) OR (.. AND ..)

Again, quoting the topic starter - the following SELECT (containing both GE and LE) is claimed to be OK:

SELECT FBNK.COLLATERAL.TYPE WITH (@ID GE 100 AND @ID LE 399)

I don't have TAFJ (and hope I never will :) - maybe you can retest all examples from the initial post under TAFJ?

The select syntax will work on TAFC, not on TAFJ.

The table names on TAFC is "FBNK.COLLATERAL.TYPE" and on TAFJ is "FBNK_COLLATERAL_TYPE". if one uses SQL the "." needs to be replaced by "_".

If one is using DBTools JQL option can give you something similar to TAFC.