A
ArnoldJansen
Is it possible for Excel to write a dataset with specific formatting:
This dataset has to be transferred to a mainframe, and there they use
computaional fields, packed decimal fields, just like Cobol does.
Is it possible (and how) to convert data from an Excel sheet into these
formats before writing this dataset to our mainfarame?
Example of the Cobol-layout of the data the mainframe needs to have in
this dataset:
01 VERA-AANLEVERING-VOORLOOP.
03 RE-RECORD-TYPE PIC X(02).
03 RE-BRONNAAM PIC X(08).
03 RE-AANLEVER-NUMMER USAGE PACKED-DECIMAL
PIC
S9(08)V.
03 RE-VALUTAJAAR USAGE PACKED-DECIMAL
PIC
S9(04)V.
03 RE-AANLEVER-DATUM PIC X(08).
03 RE-PERIODE-NUMMER USAGE COMP-5
PIC
S9(04).
03 RE-VOLGNUMMER USAGE COMP-5
PIC
S9(04).
03 RE-AANLEVER-OMS PIC X(40).
03 FILLER PIC X(10).
This dataset has to be transferred to a mainframe, and there they use
computaional fields, packed decimal fields, just like Cobol does.
Is it possible (and how) to convert data from an Excel sheet into these
formats before writing this dataset to our mainfarame?
Example of the Cobol-layout of the data the mainframe needs to have in
this dataset:
01 VERA-AANLEVERING-VOORLOOP.
03 RE-RECORD-TYPE PIC X(02).
03 RE-BRONNAAM PIC X(08).
03 RE-AANLEVER-NUMMER USAGE PACKED-DECIMAL
PIC
S9(08)V.
03 RE-VALUTAJAAR USAGE PACKED-DECIMAL
PIC
S9(04)V.
03 RE-AANLEVER-DATUM PIC X(08).
03 RE-PERIODE-NUMMER USAGE COMP-5
PIC
S9(04).
03 RE-VOLGNUMMER USAGE COMP-5
PIC
S9(04).
03 RE-AANLEVER-OMS PIC X(40).
03 FILLER PIC X(10).