Hello Community I have an query code which works pretty well in oracle .. but not in Talend.
[color=#566579][size=2] [spoiler][/size][/color]
SELECT t.* FROM (
SELECT -- DENSE_RANK () OVER ( ROW_NUMBER () OVER ( PARTITION BY RELFIRMA.FIRMANR ORDER BY RELADRESSE.ADRESSENR,( CASE RELZTZB.Sprache WHEN N'' || 'de' THEN 1 WHEN N'' || 'us' THEN 2 ELSE 9 END ) ) AS rnk, ( CASE RELZTZB.Sprache WHEN N'' || 'de' THEN 1 WHEN N'' || 'us' THEN 2 ELSE 9 END ) as case,
RELFIRMA.FIRMANR as company, RELANSCH.STRASSE, RELANSCH.ORT, RELANSCH.LAND, RELANSCH.STAAT, RELANSCH.PLZORT, RELANSCH.POSTFACH, RELACP.VERTRETER1, RELANSCH.LANDKNG, RELADRESSE.ANSCHRIFTNR, RELFIRMA.ABCKLAS, RELFIRMA.USTIDNR, RELFIRMA.KTXT, RELFIRMA.BEMERKUNG, RELFIRMA.VERWENDUNG1, RELFIRMA.CREATEDATE, RELFIRMA.MODIFYDATE, RELFIRMA.NAME, RELACP.TEXT0, RELACP.TEXT1, RELACP.TEXT2, RELACP.TEXT3, RELACP.TEXT4, RELACP.ZBED, RELZTLB.KTXT as LB, RELZTSPE.KTXT as SPEDVS, RELZTZB.KTXT as ZB, reltext.betreff
FROM (INFOR.RELFIRMA RELFIRMA left outer join infor.reltext reltext on relfirma.textnr = reltext.textnr INNER JOIN INFOR.RELADRESSE RELADRESSE ON (RELFIRMA.FIRMANR = RELADRESSE.FIRMANR) inner JOIN INFOR.RELACP RELACP ON (RELFIRMA.FIRMANR = RELACP.MNR) inner join INFOR.RELANSCH RELANSCH ON (RELADRESSE.ANSCHRIFTNR = RELANSCH.ANSCHRIFTNR)) left outer JOIN INFOR.RELZTLB RELZTLB ON (RELACP.TEXT0 = RELZTLB.ZTKEY) left outer JOIN INFOR.RELZTSPE RELZTSPE ON (RELACP.TEXT1 = RELZTSPE.ZTKEY) left outer JOIN INFOR.RELZTZB RELZTZB ON (RELACP.ZBED = RELZTZB.ZTKEY) WHERE RELFIRMA.VERWENDUNG1 = '1' AND RELANSCH.VERWENDUNG1 = '1' AND RELFIRMA.FIRMANR NOT LIKE 'I%' ---ungeprüft Ende--- ) t WHERE t.rnk = 1 -- and rownum < 300 ORDER BY t.company
I think the Unicode conversion in the query "N" causes the error: Fail to convert to internal representation
So does Talend can cope with "N" Conversion in query's ?
