Archives of the TeradataForum

Message Posted: Thu, 05 Feb 2004 @ 13:55:05 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Vivek,

I am merging the output of two fexp output file s and sending the final one in e-mail displaying two list of questions. Suppose the two fexp output files are:-

file1:
Q100
Q200
Q300
Q400

file2:
Q111
Q222
Q333

I am merging these two files in a single file along with some header text and then send that final file through e-mail in the shell script, so final file looks like:-

final:
List of Question - 1
--------------------
Q100
Q200
Q300
Q400

List of Question - 1
--------------------
Q111
Q222
Q333

###########################

When I see these three files file1,file2,final in Unix using vi editor. Data is being displayed correctly as mentioned above. But the mail I get, it looks like:

List of Question - 1
--------------------

List of Question - 1
--------------------

###########################

Only the Output of fexp is not visible in the mail. Earlier when varchar was used, I was merging the two files after doing some manipulation, manually removing the control characters. At that time e-mail contents were being displayed correctly. I don't want to use this workaround method of removing control characters because it doesn't work all the time. Can you guess what could be the reason behind getting the blank e-mail.

- Rishi

	<Prev	Next>		<<First	<Prev	Next>	Last>>