MVSFORUMS.com

Vishwakiran

Friends,

I have to upload the excel sheet containing several fixed length fields to mainframe dataset.

Please suggest whether I can load the excel sheet directly to mainframe. Will it be consistant in the alignement if do it repeatedly ?

Is there any option in excel to indicate that a column is fixed length of say X bytes ?

Please suggest.

Thanks,
_________________
Regards,
Vishwakiran

kolusu · Posted: Fri Jun 30, 2006 7:12 am Post subject:

Vishwakiran,

Save the file as .csvor tab delimited .txt file and you can upload it to the mainframe. You can specify the columns as fixed , but excel truncates the trailing spaces.

for ex you have 3 columns

col1 - 10 bytes and col2 - 20 bytes and col3 - 10 bytes

and if you have data like this

kolusu · Posted: Fri Jun 30, 2006 7:14 am Post subject:

Btw I forgot to mention that the latest PTF from DFSORT can actually format variable format records into fixed length using PARSE function.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Vishwakiran · Posted: Thu Jul 06, 2006 8:24 am Post subject:

Thanks Kolusu for the guidance.
_________________
Regards,
Vishwakiran

jyoung · Posted: Thu Jul 06, 2006 12:32 pm Post subject:

I first set the lengths of each column in Excel and then save it as a .prn file. Then you can upload it. When I save it as a .txt the field lengths do not work.