Application Programming Training Schedule

JCL COURSE SYLLABUS

INTRODUCTION TO JCL

JOB STATEMENT

POSITIONAL AND KEYWORD PARAMETERS

• JOB ACCOUNTING INFORMATION
• PROGRAMMER NAME
• CLASS
• PRTY
• MSGCLASS
• MSGLEVEL
• TYPRUN
• REGION
• TIME
• COND
• RESTART
• NOTIFY

EXEC STATEMENT

POSITIONAL AND KEYWORD PARAMETERS

• PGM
• PROC
• PARM
• ACCT
• ADDRSPC
• DPRTY
• PERFORM
• RD

DD STATEMENT

POSITIONAL AND KEYWORD PARAMETERS

• *
• DATA
• DUMMY
• DSN
• DISP
• UNIT
• VOL
• SPACE
• DCB

SPECIAL DD STATEMENTS

• JOBLIB
• STEPLIB
• CONCATENATION
• TEMPORARY DATASET
• REFERBACK
• SYSOUT
• SYSUDUMP
• SYSMDUMP
• SYSABEND

PROCEDURES

INSTREAM AND CATALOGED PROCEDURES

• INTRODUCTION
• INSTREAM PROCEDURE
• CATALOGED PROCEDURE
• PROCEDURE MODIFICATION
• SYMBOLIC PARAMETERS

GENERATION DATA GROUPS (GDG)

• INTRODUCTION
• CREATION OF GDG
• USING GDG
• ALTERING GDG DEFINITION
• DELETING GDG

UTILITIES

• IEBGENER
• IEBCOPY
• IDCAMS
• IEFBR14
• IEHPRGM
• IEHLIST
• IEEBEDIT
• IEBCOMPR
• SORT
• MERGE
• IEBPTPCH

VSAM COURSE SYLLABUS

INTRODUCTION TO VSAM

• HISTORY
• VIRTUAL STORAGE ACCESS METHOD
• ADVANTAGES AND DISADVANTAGES OF VSAM
• FUNCTIONAL COMPONENTS OF VSAM

VSAM TERMINOLOGIES

• LOGICAL RECORD
• PHYSICAL RECORD
• CONTROL INTERVAL
• CONTROL INTERVAL SPLITS
• CONTOL AREA SPLITS
• SPANNED RECORDS

VSAM DATASET TYPES

• KEY SEQUENTIAL DATA SET
• ENTRY SEQUENTIAL DATA SET
• RELATIVE RECORD DATA SET
• VARIABLE RELATIVE RECORD DATA SET
• LINEAR DATA SET

ACCESS METHOD SERVICES

• IDCAMS
• USING IDCAMS
• BASIC IDCAMS COMMANDS
• DEFINE COMMAND
• REPRO
• REUSE
• REPLACE
• IMPORT AND EXPORT
• VERIFY
• PRINT
• LISTCAT
• SPANNED
• ALTER
• DELETE

ALTERNATE INDEXES

• DEFINE ALTERNATE INDEXES
• BLD INDEX
• ALTERNATE INDEX PATHS
• AIX ORGANIZATION
• RELATE
• UPGRADE
• KEYS
• RECORDSIZE
• DEFINE PATH
• PATH ENTRY
• UPDATE

BACKUP AND RECOVERY

REPRO
EXPORT AND IMPORT

MODAL COMMANDS
IF-ELSE-ELSE-IF-END-IF

LASTCC

MAXCC

SET

COBOL COURSE SYLLABUS

INTRODUCTION TO COBOL CONTENTS

1.0 AIMS AND OBJECTIVES
1.1 HISTORY OF COBOL
1.2 FORMAT FOR COBOL PROGRAMS
1.3 STRUCTURE OF A COBOL PROGRAM
1.4 CHARACTER SET
1.5 COBOL WORDS
1.6 DATA NAMES AND IDENTIFIERS
1.7 LITERALS

DIVISIONS OF COBOL
CONTENTS
2.0 AIMS & OBJECTIVES
2.1 IDENTIFICATION & ENVIRONMENT DIVISION
2.2 IDENTIFICATION DIVISION.
2.3 ENVIRONMENT DIVISION
2.4 CONFIGURATION SECTION
2.4.1. SOURCE-COMPUTER
2.4.2 OBJECT-COMPUTER
2.4.3 SPECIAL NAMES
2.5 INPUT-OUTPUT SECTION
2.5.1 FILE-CONTROL
2.6 DATA DIVISION.

PICTURE CLAUSE CHARACTERISTICS
CONTENTS
3.0 AIMS & OBJECTIVES
3.1 PICTURE CLAUSE
3.1.1 CLASS
3.1.2 SIGN
3.1.3 POINT LOCATION
3.1.4 SIZE

EDITING
CONTENTS
4.0 AIMS & OBJECTIVES
4.1 EDITING
4.2 EDIT CHARACTERS FOR NUMERIC DATA

LEVEL STRUCTURE
CONTENTS
5.0 AIMS & OBJECTIVES
5.1 LEVEL NUMBERS
5.2 VALUE CLAUSE

DATA MOVEMENT VERB: MOVE
CONTENTS
6.0 AIMS AND OBJECTIVES
6.1 SYNTAX OF MOVE VERB
6.2 RULES OF MOVE VERB
6.3 EXAMPLES OF MOVE USAGE

ARITHMETIC VERBS
CONTENTS
7.0 AIMS AND OBJECTIVES
7.1 ADD VERB
7.2 SUBTRACT VERB
7.3 MULTIPLY VERB
7.4 DIVIDE VERB
7.5 COMPUTE VERB

INPUT AND OUTPUT VERBS
CONTENTS
8.0 AIM AND OBJECTIVES
8.1 OPEN STATEMENT
8.2 READ STATEMENT
8.3 WRITE STATEMENT
8.4 CLOSE STATEMENT
8.5 ACCEPT
8.6 DISPLAY
8.7 GO TO, STOP RUN

CORRESPONDING OPTIONS
CONTENTS
9.0 AIMS AND OBJECTIVES
9.1 MOVE CORRESPONDING
9.2 ADD & SUBTRACT CORRESPONDING
9.3 GENERAL RULES
9.4 ROUNDED OPTION
9.5 ON SIZE ERROR OPTION

PROGRAMS USING ARITHMETIC VERBS
CONTENTS
10.0 AIMS AND OBJECTIVES
10.1 PROGRAM FOR ADD VERB
10.2 PROGRAM FOR SUBTRACT VERB
10.3 PROGRAM FOR MULTIPLY VERB
10.4 PROGRAM FOR DIVIDE VERB
10.5 PROGRAM FOR SIZE ERROR
10.6 PROGRAM FOR COMPUTE VERB

CONDITIONS
CONTENTS
11.0 AIMS AND OBJECTIVES
11.1 CONDITION
11.2 RELATIONAL CONDITION
11.3 SIGN CONDITION
11.4 CLASS CONDITION
11.5 CONDITION-NAME CONDITION
11.6 NEGATED SIMPLE CONDITION
11.7 COMPOUND CONDITION

CONDITIONAL STATEMENTS
CONTENTS
12.0 AIMS AND OBJECTIVES
12.1 IF STATEMENT
12.2 IF…ELSE STATEMENT
12.3 NESTED IF STATEMENT

PERFORM STATEMENTS
CONTENTS
13.0 AIM AND OBJECTIVES
13.1 PERFORM STATEMENT
13.2 PERFORM WITH TIMES OPTION
13.3 PERFORM WITH UNTIL OPTION
13.4 PERFORM WITH VARYING OPTION

RENAMES & REDEFINES CLAUSES
CONTENTS
14.0 AIMS AND OBJECTIVES
14.1 RENAMES CLAUSE
14.2 RULES OF RENAMES CLAUSE
14.3 REDEFINES CLAUSE
14.4 RULES OF REDEFINES CLAUSE

SEQUENTIAL FILES
CONTENTS
15.1 AIMS AND OBJECTIVES
15.1 FILE CHARACTERISTICS
15.2 FILE-CONTROL ENTRIES FOR SEQUENTIAL FILES
15.3 FILE DESCRIPTION- FIXED-LENGTH RECORDS
15.4 STATEMENTS FOR SEQUENTIAL FILES
15.5 SEQUENTIAL FILES WITH VARIABLE-LENGTH RECORDS

SORTING AND MERGING OF FILES
CONTENTS
16.0 AIMS AND OBJECTIVES
16.1 THE SIMPLE SORT VERB
16.2 FILE UPDATING
16.3 SIMPLE MERGE VERB
16.4 INPUT AND OUTPUT PROCEDURE IN SORT STATEMENT
16.5 MERGE VERB WITH OUTPUT PROCEDURE

TABLE HANDLING
CONTENTS
17.0 AIMS AND OBJECTIVES
17.1 OCCURS CLAUSE
17.2 RULES FOR OCCURS CLAUSE
17.3 MULTI-DIMENSIONAL TABLES

DB2 COURSE SYLLABUS

INTRODUCTION TO DB2

• HISTORY
• ADVANTAGES OF DBMS OVER FILES
• BASIC OBJECTS AND OPERATORS SUPPORTED BY DB2
• WHAT IS DATABASE AND ITS BASIC TYPES
• DATABASE MODELS
a. HIERARCHICAL
b. NETWORK

c.RELATIONAL

d. OBJECT ORIENTED
• DISCUSS ABOUT STORAGE GROUP AND VOLUMES
• TABLE SPACES AND ITS TYPES
a.SIMPLE TABLE SPACE
b.SEGMENTED TABLESPACE
c.PARTIONED TABLESPACE

• INDEX SPACES
• SQL AND ITS TYPES
• BASIC INFORMATION ABOUT
a.TABLE
b.ROW
c.COLUMN
d.QUERIES
e.VIEW
f.SYNONYMS
g.ALIAS

• DB2 INTERNALS
a.DB2 DATA OBJECTS

b.DB2 SYSTEM OBJECTS

INTEGRITY AND DATA CONSTRAINTS

SECURITY AND AUTHORIZATIONS

DISCUSSING THE COMPILATION OF COBOL-DB2 PROGRAM

INTERACTION WITH DB2

• DYNAMIC SQL – INTRODUCTION
• DYNAMIC SQL – TYPES
• WHEN TO USE DYNAMIC SQL
• EXECUTE IMMEDIATE SQL
• NON-SELECT DYNAMIC SQL
• PARAMETER MARKER
• FIXED-LIST SELECT
• VARYING LIST SELECT

CURSOR HANDLING

• INTRODUCTION TO CURSOR CONCEPT

DB2 LOCKING
• LOCKING FACILITY
• COMMIT
• ROLLBACK

DB2 UTILITIES

• DATA CONSISTENCY UTILITIES CHECK UTILITY

REPAIR UTILITY REPORT UTILITY DIAGNOSE UTILITY

• BACKUP AND RECOVERY UTILITIES COPY UTILITY MERGECOPY UTILITY

• DATA ORGANIZATION UTILITIES LOAD UTILITY

REORG UTILITY

• CATALOG MANIPULATION UTILITIES CATMAINT UTILITY

MODIFY UTILITY
RUNSTATS UTILITY
STOSPACE UTILITY

CICS COURSE SYLLABUS

INTRODUCTION TO CICS

• CICS
• BATCH VS. ONLINE
• CICS PROGRAM FORMAT
• TASK AND TRANSACTION
• HOW TO INITIATE TRANSACTIONS

CICS CONCEPTS

• MULTITASKING
• MULTI-THREADING
• QUASI-REENTRANCY

• CONVERSATIONAL , NON-CONVERSATIONAL AND PSEUDO CONVERSATIONAL PROGRAMMING

#11/1, 1st Floor,100 Feet Ring Road, BTM Layout 2nd Stage, Bangalore – 560076. www.tecsacon.com, Mobile : +91 9886526644 / 9742290834.

CICS RESOURCE DEFINITION

• PPT
• PCT
• FCT
• TST
• DCT
• RCT

MAPSETS, MAPS, MAP FIELDS

• PHYSICAL & SYMBOLIC MAPS

FILE HANDLING IN CICS AND VSAM

• FILE CONTROL
• TYPES OF VSAM FILES
• START BROWSE COMMANDS

QUEUES

• TSQ
• TDQ

CICS REGION COMMANDS

• XCTL AND LINK

CICS EXCEPTION HANDLING

• TEST AND DEBUGGING COMMANDS
• FUNCTIONS OF EDF

COBOL-CICS-DB2

• GENERAL STRUCTURE OF CICS PROGRAM
• CICS PROVIDED FACILITIES FOR PROGRAMMING
• HOW TO WORK WITH DB2 DATABASES
• HOW TO DESIGN, CODE AND TEST A MODULAR CICS PROGRAM
• HOW TO COMPILE A CICS PROGRAM?
• PRE-REQUISITES FOR THE EXECUTION OF A CICS PROGRAM
• EXECUTION