How to place a new line via select statement in teradata?

1.6k views Asked by At

Suppose there is string = 'Hello how are you? Are you there?'

I want the string to be splitted into 2 lines, basically want to put a new line character in between, so that the export file (from bteq) captures it.

o/p in export file expected:

Hello
how are you? Are you there?

None of the below solutions could generate the expected output.

.EXPORT FILE=xyz.txt;

sel 'Hello \n how are you? Are you there?' sel 'hello Chr(10) how are you? Are you there?'

Any suggestions? Can anyone help with a way to print a newline into the export file?

0

There are 0 answers