Multiline Query

[MichalisDBA]

Hello.

How we can write a multiline query inside the config file?

source.query=SELECT * FROM TABLE
WHERE X=1 AND Y=2
ORDER BY X ASC

Something like that.

[osalvador]

Hi @MichalisDBA

Just put a backslash at end-of-line:

source.query=SELECT * FROM TABLE \
WHERE X=1 AND Y=2 \
ORDER BY X ASC

https://docs.oracle.com/javase/6/docs/api/java/util/Properties.html

[MichalisDBA]

Thanks. I was stuck with my bashing technique trying some << EOF etc.