Tags

, , , , , , , , , , , , , ,

In my blog, below post already has a way to read an Excel (csv) file through SORT

http://mainframesf1.com/2012/03/28/sort-parse-read-excel-csv-in-mainframes/

Other approach we use in our shop is provided below.

In the Excel file, for each column, set the column width by right clicking the column and choosing “Column Width” and providing a fixed width value that you want. For example, if a max value for your account number is 10, choose 10 as “Column Width”

If you have a numeric value (with 2 decimals), ensure to choose the format as numeric (with 2 decimals) by right click on the Excel column and choosing Format cells. This will ensure that if you have any values as 1.2, it populates as 1.20 to give fixed width

If you have any text columns, it is preferred to right click the Excel column and choose Text in the Format cells. This will ensure all the data in the column is left justified. By doing this any cell value that is only numeric also will be left justified.

Once you have done all above, you can use “Save as” and choose the format “PRN” (Formatted Text (space delimited). This will save the Excel file as a text file in fixed width.

This “PRN” format file can now be FTP to a mainframe FB PS dataset with the required LRECL and used to process in a COBOL program by reading the file into a COPYBOOK layout in the layout as your input dataset is.

——————————————————————————————————–

In United States, If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog

——————————————————————————————————–

You may also like to look at:

Working on Mainframes – Is Change to a different technology necessary
Important SQL CODES and ABEND CODES
SORT JOIN – TO JOIN TWO FILES BASED ON A KEY
KNOW YOUR MAINFRAME
REXX – INITIAL SETUP
HOW TO SUBMIT A BATCH JOB FROM THE CICS PROGRAM
CICS – EXEC interface block – EIBRESP Values
CICS – EXEC interface block Fields
Flow of control between COBOL programs, run units, and CICS
CICS INTERVIEW QUESTIONS
CICS TIPS
COBOL – COPY and INCLUDE statements
COBOL – PERFORMANCE IMPROVEMENT
COBOL – SIGN STORED IN COMP, COMP-3 AND DISPLAY FORMATS
SHORTEST COBOL PROGRAM
RESTART LOGIC IN COBOL DB2 Program
GOBACK – EXIT PROGRAM – STOP RUN
Continuation lines in COBOL
Computational items – COMP, COMP 1 , COMP 2, COMP 3
COBOL program format
cobol indicator area column-7 and area a and area b
COBOL INTERVIEW QUESTIONS
COBOL TIPS
COBOL COMPILER OPTIONS
The IDENTIFICATION DIVISION