Creating sql inside talend and create it with outputdelimited

[jensej]

Hey!

This is probably simple but I don't find a good way to solve it.

What I want is to create a .SQL file that should look exactly like this.

It's important that the comment are there and also the linebreaks should be there.

Is there some component for adding free text and then send it into a tFileoutputDelimited and save it as a .sql?

[Anonymous]

The best way to do this is to build your SQL using a tJavaFlex. You can Java in this to give you everything you need to build a String. You would build it in this component and then output to a tFileOutputRaw component. This component's documentation is shown below....

https://help.talend.com/r/en-US/8.0/raw/tfileoutputraw