Urgent help in AS400 joining two tables

[#1]

Hello Gurus

As I am trying to join two tables and one table having value of Date as 'YYYYMM' and another table value has DD/MM/YYYY

I tried this in the where condition but Makedate function is not acceptable in DB AS400, could you please suggest any alternate way to do.

Select *,

From Table Y

Left Join Table Z ON Y.DATE = Makedate(Left(Z.DATE,4),Right(Z.DATE,2))

Date	Value
201302	500
201303	6000
201304	7
201305	8
201306	4
201307	2

Date	Cusd_id
01/02/2013	AB1
02/02/2013	AB1
05/03/2013	AB23
08/03/2013	AB1
12/03/2013	AB23

[jer_2011]

hola

intenta con:

Y.DATE = TO_CHAR( Z.DATE,'YYYYDD')

suerte.

[alematex]

you can join them IN QLIKVIEW combining sql instructions an qview intructionslike this:

FINAL_TABLE:

SELECT DATE.....

FROM TABLE1;

LEFT JOIN (FINAL_TABLE)

SELECT TO_CHAR(DATE2,'YYYYMM') AS DATE......

FROM TABLE2;