| View previous topic :: View next topic | 
	
	
		| Author | Message | 
	
		| satyenderd Beginner
 
 
 Joined: 26 Aug 2005
 Posts: 144
 Topics: 73
 
 
 | 
			
				|  Posted: Thu Sep 24, 2009 5:15 pm    Post subject: DB2 LOAD problem |   |  
				| 
 |  
				| Hi all, 
 I am trying to load the table using LOAD utility.
 In the input file there is one record with special character "
 _________________
 Satya
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| kolusu Site Admin
 
  
 
 Joined: 26 Nov 2002
 Posts: 12394
 Topics: 75
 Location: San Jose
 
 | 
			
				|  Posted: Thu Sep 24, 2009 5:32 pm    Post subject: |   |  
				| 
 |  
				| satyenderd, 
 
 How are you uploading the file to mainframe? FTP or e IND$FILE  transfer via emulator?
 
 Kolusu
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| satyenderd Beginner
 
 
 Joined: 26 Aug 2005
 Posts: 144
 Topics: 73
 
 
 | 
			
				|  Posted: Thu Sep 24, 2009 6:13 pm    Post subject: |   |  
				| 
 |  
				| Hi Kolusu, 
 Thanks for your response.
 
 I am uploading thru file transfer option in the mainframes. (TN3270)
 _________________
 Satya
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| kolusu Site Admin
 
  
 
 Joined: 26 Nov 2002
 Posts: 12394
 Topics: 75
 Location: San Jose
 
 | 
			
				|  Posted: Thu Sep 24, 2009 6:32 pm    Post subject: |   |  
				| 
 |  
				| satyenderd, 
 I just uploaded the file as TEXT with "
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| satyenderd Beginner
 
 
 Joined: 26 Aug 2005
 Posts: 144
 Topics: 73
 
 
 | 
			
				|  Posted: Thu Sep 24, 2009 9:02 pm    Post subject: |   |  
				| 
 |  
				| Thank you Kolusu for that information. I will check that and will update you.
 _________________
 Satya
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| satyenderd Beginner
 
 
 Joined: 26 Aug 2005
 Posts: 144
 Topics: 73
 
 
 | 
			
				|  Posted: Fri Sep 25, 2009 10:49 am    Post subject: |   |  
				| 
 |  
				| Hi Kolusu, 
 As I a using TN3270 emulator, I did see those options.
 Herein is the screenshot.
 In the send options there is only two options in the drop down. CRLF and LF.
 I am unable to send you the screenshot.
 
 Could you please help me in this regard?
 _________________
 Satya
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| satyenderd Beginner
 
 
 Joined: 26 Aug 2005
 Posts: 144
 Topics: 73
 
 
 | 
			
				|  Posted: Fri Sep 25, 2009 11:01 am    Post subject: |   |  
				| 
 |  
				| Data in the text file: 
 11387	"RANDY"	"
 _________________
 Satya
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		|  | 
	
		|  |