OnDemand User Group
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
Home
Help
Search
Calendar
Login
Register
OnDemand User Group
»
Support Forums
»
z/OS Server
»
Best way to load a CSV file on the host
« previous
next »
Print
Pages:
1
[
2
]
Author
Topic: Best way to load a CSV file on the host (Read 7189 times)
Nolan
Full Member
Posts: 152
Re: Best way to load a CSV file on the host
«
Reply #15 on:
March 30, 2016, 01:50:15 PM »
Sounds like you are converting the data too much to start with. If this is a true CSV file created on a distributed system the line feeds should already exist. The file should be sent to Z/OS as a binary file and then loaded with the generic indexer. No conversion required.
OnDemand only puts out what you put in.
Logged
J.
#zOS #AIX #Windows #Multiplatforms
#DB2 #TSM #ODF #zODF #ODWEK
#CapacityPlanning #AFP #ReportDistribution
#Finance #ICN
lfbeach
Jr. Member
Posts: 43
Re: Best way to load a CSV file on the host
«
Reply #16 on:
April 05, 2016, 08:25:55 AM »
This was the final step to make this work. End of each line needs a hex'0D15' (and convert EBCDIC to ASCII)
SORT FIELDS=COPY
INREC BUILD=(1:1,78,X'0D15')
OUTREC OVERLAY=(1:1,80,TRAN=ETOA)
Thanks for all assistance!
Logged
Lori Frazier Beach
Developer-CMOD Admin
Document Management Systems
Ed_Arnold
Hero Member
Posts: 1200
Re: Best way to load a CSV file on the host
«
Reply #17 on:
April 05, 2016, 09:22:08 AM »
Lori - thank you for closing the loop on this one and giving the final solution.
Ed
Logged
#zOS #ODF
Print
Pages:
1
[
2
]
« previous
next »
OnDemand User Group
»
Support Forums
»
z/OS Server
»
Best way to load a CSV file on the host