Issues with LEFT JOIN through ODBC iclient Access

[Bertrand GAVROY]

Hi,

I met an issue running a query in GENIO ETL (in a dataset). The
dataset is made of left joins between 3 DB2 files.
Thus it seems to loop ! When launched, the query generates 15Gb of
temporary file in less than 5 minutes.

The center table, ACSTADLM, holds 8 million lines so we should get as
a maximum the same number.

Is there somthing special using left joins under DB2 ?

Thanks