BTEQ export output and including a newline between concatenated text

Tools & Utilities
Enthusiast

BTEQ export output and including a newline between concatenated text

Hello Team,

I'm trying to run a BTEQ export script to file to generate another BTEQ file.

.EXPORT REPORT FILE='xxx.btq'

causes all newlines to be flattened/smooshed onto one line

.EXPORT DATA FILE='xxx.btq'

shows the new lines but puts

ZX..............

jh...............

on the front of the line - I can't seem to get a happy medium.

neither of these work sadly...

'0A'xc

'0D0A'xc

CHR(10)