[resolved] Unicode Procressing with Talend

Anonymous — Mon, 01 Aug 2016 09:38:03 GMT

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 ?

if not do i have other possibilities ?

regards john

Re: [resolved] Unicode Procressing with Talend

Anonymous — Fri, 05 Aug 2016 04:13:42 GMT

Hi,
We see this topic has been marked as resolved.Could you please sharing your solution with us?
Best regards
Sabrina

topic [resolved] Unicode Procressing with Talend in Talend Studio

[resolved] Unicode Procressing with Talend

Re: [resolved] Unicode Procressing with Talend