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.

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.

This FTP script inserts the COPY and RECORD lines of the sequential files into the libraries created by the CREASEQS.TXT JCL.
Within your TSO environment, submit the CREASEQS JCL.
Review results to verify that the job ran successfully.

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)

Continue to the next section.