Hi,
I created an interface that relate source table to target table.
I get this error:
This is the code:
/* DETECTION_STRATEGY = NOT_EXISTS */
insert /*+ append */ into PHOSDW.I$_BACH
(
CODEBACH,
DATEBACH,
IND\_UPDATE
)
select
CODEBACH,
DATEBACH,
IND\_UPDATE
from (
select
C1\_CODEBACH CODEBACH,
C2\_DATEBACH DATEBACH,
'I' IND\_UPDATE
from PHOSDW.C$_0BACH
where (1=1)
) S
where NOT EXISTS
( select 1 from PHOSDW.BACH T
where T.IDBACH = S.IDBACH
and ((T.CODEBACH = S.CODEBACH) or (T.CODEBACH IS NULL and S.CODEBACH IS NULL)) and
((T.DATEBACH = S.DATEBACH) or (T.DATEBACH IS NULL and S.DATEBACH IS NULL))
)
If you can help me to find a solution. Thanks.