[smotheram]

I have SQL in my sql.properties file like this ..

emp_sql=select * \
from employees \
where \
name = ‘JON’

The loader sees only first line – rest of the lines are being ignored. what am I doing wrong. thanks.

[support-joy]

smotheram,

Ensure there are no blanks after the “\” backslashes at the end of each line. A blank in the last position cancels the effect of the backslash.

[smotheram]

Thanks. That worked.

[support-joy]

smotheram,

Good to hear you are all set.

Best.

[Author]

Posts