Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Control characters in fastexport output file
 
From:   Agarwal, Rishi

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016