Importing JCL Job Streams into Your Mainframe Environment

In order to import the JCL CREATBT and CREASEQD into your mainframe environment, you must first edit an FTP script, PUT_JCL_DB2, to include your login credentials.

Next, you run FTPJCLDB2.BAT, which executes the FTP commands listed in the file PUT_JCL_DB2.txt to transfer the JCL job streams to an existing library in your mainframe environment.

To import the JCL job streams CREATBT and CREASEQD into your mainframe environment:

Edit the FTP script in the PUT_JCL_DB2.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
YOURJCLLIBRARY    the name of the library that you want to contain the JCL
```
This FTP script transfers the JCL job streams CREATBT and CREASEQD onto the mainframe environment into your the specified JCL library when FTPJCLDB2.BAT is executed.
Ask the DBA to customize the following parameters in the CREATBT.TXT file:
- DSN
- DSN SYSTEM
- PLAN
- LIB
- TABLESPACE
- DATABASE NAME
- STOGROUP
- PRIQTY
- SECQTY
- FREEPAGE
- PCTFREE
- BUFFERPOOL
- SEGSIZE
- COMPRESS
The CREATBT.TXT file contains the JCL that is used to create the tablespace DETESTLG and the following DB2 tables:
- CUSTOMER
- ACCOUNT
- CCARD
- OPERAT
Change each instance of the XXXXXX.XXXXXX library in the CREASEQD.TXT file to URADAR.DEMOT. For example, DSN=XXXXXX.XXXXXX.LISTDB2 becomes: DSN=URADAR.DEMOT.LISTDB2.
Note: The library URADAR.DEMOT is used as an example throughout this tutorial. You can use any library that suits your mainframe library naming conventions. However, it is assumed that the mainframe user ID you are using has no restrictions and can therefore access this library.
Execute FTPJCLDB2.BAT to import the JCL job streams into your mainframe environment.
Continue to the next section.