Using columns from two or more separate DB2 tables

Folks,
I'm trying to use data from two tables and I can not. follows the code:

statement => "
SELECT DISTINCT
M1.CD_UOR_RSP_SLC AS UOR,
C2.NR_PTL_ATDT AS NR_BB_ATENDE
FROM
DB2BBR.MNFC_PTL M1,
DB2BBR.CNSO_PAIN_MNFC C2
"

The error is simply to freeze on the [2018-12-26T14:05:32,406][INFO ][logstash.agent ] Successfully started Logstash API endpoint {:port=>9600}
line.
I've tried point and comma, comma and nothing.
If I call only one in select and one in from goes quiet, but when I try two it will not.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.