HI, I use TOS 2.1.1 - java
I?m trying for to create a minus.
There are 2 tables: A and B.
|A.NOME | B.NOME | A-B SQL |
|-----------+-----------+------------|
|(null) |MARIO | (null) | 1° case
|ROSSI | ROSSI | ________|
|A.NOME|B.NOME | A-B SQL |
|---------+---------+-----------|
|MARIO | (null) | MARIO | 2° case
|ROSSI | ROSSI | ________|
|A.NOME |B.NOME | A-B SQL |
|-----------+----------+------------|
|(null) | (null) | (empty) | 3° case
|ROSSI | ROSSI | ________|
|A.NOME|B.NOME| A-B SQL |
|---------+--------+-----------|
|ROSSI | (null) | (empty) | 4° case
| | ROSSI | _______ |
How can I have the same result using TOS?
I have tried with 2 tOracle inpmut and 1 tMap, but the results are different from SQL.
Thanks a lot
With 2 tables there aren?t any problems, but with more table the results are wrongs!!
Hi, I use TOS 2.1.1 Java version,
and I try to reproduce a MINUS with 3 tables in TOS.
This is the oracle select:
select msg from log
minus
select msg from log2
minus
select cognome from paziente
I use 3 tOracleInput and 1 tMap.
I tried to 'simulated' the minus with an left outer join and a filter on the part that is not matched, but the result is wrong!!
There are my tables:
TABLE LOG
ciao
aaaa
CIAO
A1
TABLE LOG2
(null)
CIAO
CIAO2
TABLE PAZIETE
A1
(null)
rossi
The result of this MINUS in Oracle is:
-------------
ciao
aaaa
------------
Any idea?
Thanks to all
Hello eng,
This MINUS problem is quite difficult to handle in TOS.
We have planned to develop all those DB functions in dedicated components.
In the interval, I think that the best thing to do is to put your request directly in your tOracleInput.
Regards,
Michaël.
Hello Michaël!
Thanks for answer!
I find a ?little? solution. I?ve think to split the minus in more parts.
(A-B-C) = (A-B)-C
It runs
Do you have some idea about the release plan ?
When version 2.1.2 will be released?
Thank you
Regards,
Marco