Mainframe Specialist

CLIST – Foundations

This badge earner can explain what CLIST is and how it can be used to execute common tasks in a z/OS operational environment. This person will also be able to create and execute basic CLISTs from a TSO/ISPF environment.

CLIST – Experienced

This badge holder can create more advanced CLISTs using control variables, built-in functions as well as utilize error and attention exit routines and be able to explain how CONTROL options affect the way a CLIST will execute. This person will also be able to create nested CLISTs and subprocedures and be able to explain how …

CLIST – Experienced Read More »

Db2 V13 SQL Coding – Advanced

This badge earner has experience with SQL code structure and syntax, and can efficiently create code to access, insert, sort, update, and delete Db2 database content. This individual can identify and resolve SQL errors, and diagnose and fix SQL performance-related issues.

Db2 V13 Operations

This badge earner has a solid understanding of the Db2 environment, its components, and the use of SQL to extract data. This individual can initialize and shutdown Db2 and individual database components, identify and analyze problems through information gathering, and resolve errors and performance issues.

REXX Programming – Foundations

The earner of this digital badge can describe how REXX programs can benefit an organization, and best practices when creating a REXX program. They can create REXX code that performs simple and complex arithmetic calculations, and parse source data to create variables that REXX can work with.

Interskill – Mainframe Specialist – Database – Fundamentals 2023

This badge holder can identify the different types of databases used in today’s enterprise environment and explain how and why they differ. They can describe DBMS functions, and how important aspects such as security, and backup/recovery are implemented. This person can also create a simple database and its associated components, and describe core DBMS administrative …

Interskill – Mainframe Specialist – Database – Fundamentals 2023 Read More »

Interskill – Mainframe Specialist – Database Management – Intermediate 2023

This badge holder can create, alter, and delete database components such as table spaces, tables, and indexes, and can also define security, granting and revoking access to the database as need be. They can create stored procedures and user-defined functions, and explain how they can best be used. This person can also describe how communication …

Interskill – Mainframe Specialist – Database Management – Intermediate 2023 Read More »

Interskill – Mainframe Specialist – SQL – Intermediate 2023

This badge holder has experience with SQL code structure and syntax, and can efficiently create code to select, insert, sort, update, and delete database content. They can also use more advanced features to join tables, select specific data, create views, and build subqueries.

Interskill – Mainframe Specialist – SQL – Fundamentals 2023

This badge holder can code SQL to perform basic selection of database content. They can code scalar and aggregate functions, and use SQL to perform arithmetic calculations. This individual can also manipulate selected data through grouping and sorting, and can insert data into, and delete data from, a database.