Previous Topic Next topic Print topic

Micro Focus Enterprise Test Server 2.3 Update 1 > Data Access > Database Access > Data Manager > Getting Started with z/OS Data Stores > Data Manager for z/OS Tutorials > Sample Sessions > Sequential Files Session > Importing the Sequential File and Copybook Information into Your Mainframe Environment

Importing the Sequential File and Copybook Information into Your Mainframe Environment

In this exercise, you submit the CREASEQS JCL to create the library URADAR.DEMOT in order to complete your environment creation. Then, you import sequential file and copybook into your mainframe environment.
  1. Edit the FTP script in the PUT_FILE_SEQ.txt file with the following information: 
    123.123.123.123   the IP address of your mainframe
YOURUSERNAME		    your mainframe user name
YOURPASSWORD			   your mainframe password
XXXXXX.XXXXXX     the name of the library created by JCL CREASEQS, for example: URADAR.DEMOT.
  2. This FTP script inserts the COPY and RECORD lines of the sequential files into the libraries created by the CREASEQS.TXT JCL.
  3. Within your TSO environment, submit the CREASEQS JCL.
  4. Review results to verify that the job ran successfully.
  5. Within your Windows environment, execute FTPTUTORIALSEQ.BAT to import the information into your mainframe environment.

    The information from the following sequential files is loaded into the output dataset you specified:

    Sequential File Related Data Element File Related Copybook File Data Elements
    CUSTOMER CUSTOMER_REC CUSTOMER_COPY
    • COD-CUS (customer code)
    • NAME (customer name)
    • SURNAME (customer surname)
    • DATE-OF-BIRTH (customer birth date)
    • PLACE-OF-BIRTH (customer place of birth)
    PHCONTRA PHCONTRA_REC PHCONTRA_COPY
    • COD-CUS (customer code)
    • OPERAT-NUM (operator number)
    • CONTR-NUM (contract number)
    • DATE-SIGN (date contract signed)
    PHNUMBER PHNUMBER_REC PHNUMBER_COPY
    • OPERAT-NUM (operator number)
    • CONTR-NUM (contract number)
    • PHON-TYPE (phone type: S=smart phone, M=mobile)
    • PHON-NUM (phone number)
    PHONBILL PHONBILL_REC PHONBILL_COPY
    • PHON-TYPE (phone type: S=smart phone, M=mobile)
    • PHON-NUMBER (phone number)
    • TOT-CALL (total number of incoming and outgoing calls)
    • PERIOD (billing cycle)
  6. Continue to the next section.
Parent topic: Sequential Files Session
Previous Topic Next topic Print topic