tdan
New User
Joined: 13 Oct 2010
Posts: 1
Location: India
|
|
|
|
Hi,
I have a situation where I need to load data from a note pad to a DB2 table in mainframe. I uploaded the data from PC to mainframe in 79 byte records. But, when I see the coma separated data in mainframe, the column value is spread in two lines so Db2 can't read data properly.
For instance,
Below is the data in on PC side. Though it apperas here on two lines, it is on a single line in note pad.
Insert into A5555JAS.CXX_DATA values('PQR','*ERRD','CXR001',1,'1970-01-01',1,'ERRP','9999-12-31','C','00','R','H',08005,0,0,'N','','','2015-04-10-13.15.40.000000',90346); Commit;
But when it comes to mainframe as 79 bytes,
Insert into A5555JAS.CXX_DATA values('PQR','*ERRD','CXR001',1,'1970-01-01',1,'ERRP','9999-12-31','C','00','R','H',08005,0,0,'N','','','2015-04-10-13.15.40.000000',90346); Commit;
DB2 can't read data correctly since the column value for the date is split in to two lines,. Is there any way I could spread the data in two or three lines so that a coma will be the end of a line data and DB2 can read the data correctly?
There are several hundred lines of data to be loaded in DB2. Any suggestion will be greatly appreciated? |
|
