Re: SQLLDR: Record terminator question

Thanks. I had to create a small Unix/Perl script that would find and replace the logical end of record with a temporary character (semi-colon). Basically the script searches for 000"<LF> and replaces it with 000";<LF> as follows:

perl -pe 's/\x30\x30\x30\x22\x0a/\x30\x30\x30\x22\x3b\x0a/g' accthldrtmp.dat > temp1

Then I changed my Control file's termination character to search for the semi-colon/<LF> combination: "str X'3b0a'".

Not the neatest solution, but it works. Received on Thu May 01 2003 - 16:12:57 CDT