I want to save a few lines as a file etl.xml I tried the following but it is not working for obvious reasons.
cat etl.xml << myscript
<etl>
<connection id="in" driver="xpath" url="/home/test.xml"/>
<query connection-id="in">
/TXNEXP/AUTHADV
<script connection-id="db">
</script>
</query>
</etl>
myscript
EOFis often used. If you want it to be a little more descriptive, perhapsEOF-myscript.