Running v15 Teradata, and using the following export command, I'm getting what looks like fixed length or column records. I'm exporting SQL statements and what I want is variable length records based, of course, on how long the SQL statement is.
I have a picture of the output and the export code here.
SHOULDN'T THIS output variable length records???/
Thanks In Advanced
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~.
EXPORT OUTFILE sqltbl09182016sample1.txt
MODE RECORD FORMAT TEXT;
TRIM(L.QUERYID) || ' |' ||
TRIM(L.LOGDATE) || ' |' ||
WHERE L.LOGDATE = D.LOGDATE
AND L.QUERYID = D.QUERYID
AND L.PROCID = D.PROCID
AND D.STATEMENTTYPE = 'SELECT'
Well, actually these are variable length records, you probably don't want the first wo bytes per row which indicates the length of the following VarChar :-)
FastExport has no FORMAT to get readable delimited output, to fix this you can:
I would prefer the last two.