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: 12378 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: 12378 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 |
|
 |
|
|