Link
Search
Menu
Expand
Document
(external link)
Home
Get started
How this website works
User guide - start here
First steps
What is GenevaERS?
Install
Lessons in basic skills
01 - How to learn quickly
02 - Introduction
03 - Lessons Guide
Lesson A - Simple report
Lesson B - Add lookup to report
Lesson C - Speed the lookup
How to use this product
Stage1 - Define goal
Stage2 - Analyze existing systems
Stage3 - Design batch flows
Stage4 - Develop solution using workbench
Stage5 - Run solution
Typical goals
Goal1 - Speed a report
Goal2 - Speed overnight batch
Goal3 - Make possible complex reports
Goal4 - Change annual reports
Basic solutions
Solution S01 - Generate report
Solution S02 - Update file
Solution S03 - Access data in a reference file
Solution T01 - Speed processing by Pipes
Solution T02 - Speed processing by Tokens
Solution T03 - Use IBM ZIIP hardware features
Solution T04 - Match files that share a common key
Feature introductions
Introduction F01 - Views
Introduction F02 - Phases
Introduction F03 - Files
Introduction F04 - File layouts
Introduction F05 - Lookup Paths
Introduction F06 - VDP File
Introduction F07 - JLT File
Introduction F20 - Parallel running
Introduction G01 - Workbench Environments
Introduction G02 - Workbench Users and Groups
Introduction G03 - Workbench View Folder
Introduction G04 - Workbench Global Field
Introduction G05 - Workbench Control Record
Introduction H01 - Pipes
Introduction H02 - Tokens
Introduction H03 - ZIIPs
Introduction H04 - User-Exits
Introduction H05 - Sub-Programs
Introduction H06 - General utilities
Introduction H07 - Run control utilities
Introduction H10 - Compiler
Introduction J01 - Format Phase
Introduction J02 - Logic Text for Format Phase
Introduction F08 - XLT File
Introduction F09 - Logic Table codes
Overall Training
Basic Views Training
Workbench Training
High Speed Techniques Training
Workbench
Workbench User Guide
Keyboard Shortcuts for General Users
Workbench Overviews
Workbench Screens
Dependency Checker Report screen help
Workbench Admin Guide
Keyboard Shortcuts for Admins
Workbench Logic Text
Workbench Logic Text Intro
Dummy
Workbench Logic Text Types
Extract Record Filter (ERF)
Extract Column Assignment (ECA)
Format Column Calculations (FCC)
Format Record Filter (FRF)
Workbench Logic Text Syntax
Syntax - COLUMN & COL.nnn statements
Syntax - functions
Syntax - IF statements
Syntax - lookup paths
Syntax - SELECT, SELECTIF, SKIP & SKIPIF statements
Syntax - string comparison
Syntax - WRITE statements
Keyboard Shortcuts Logic Text
Rules for all Logic Text
Workbench Logic Text Summary Diagrams
Diagrams - Extract Record Filter (ERF)
Diagrams - Extract Column Assignment (ECA)
Diagrams - Format Column Calculations (FCC)
Diagrams - Format Record Filter (FRF)
Performance Engine (PE)
Run Performance Engine (PE)
Create JCL for batch flow
Run PE
Turbocharge PE
PE Checklists
General PE Checklist
Checklist for Pipes
Checklist for Tokens
PE Programs
Runbook - MR91 Control File Generator
Runbook - MR95R Reference Data
Runbook - MR95E Extract Data
Runbook - MR88 Format Data
User-Exits
How to program User-Exits
Runbook - LX13 Key Break Tester
Runbook - RD15 Lookup Detail File Convert
Runbook - RD35 Lookup File Build
Runbook - SMFX SMF Record Flattening
Runbook - SR01 Permutation Exploder Old
Runbook - SR02 Permutation Exploder
Runbook - XLENV MR92 Env Info Lookup
Runbook - XLEXP Calculate exponential values
Runbook - XLFIL MR95 File Info Lookup
Runbook - XLST String Concatenator
Runbook - XP01 Record Paste Up
Sub-Programs
Runbook - DAYS Date Diff Calculator
Runbook - GDAT Date Convert Serial to Gregorian
Runbook - JDAY Date Convert Gregorian to Serial
Runbook - UR05 Memory Allocation
Runbook - UR10 Memory Release
Runbook - UR15 Address Pointer Set
Runbook - UR20 Sequential I/O
Runbook - UR25 Direct Sequential File
Runbook - UR26 Data Set VOLSER List
Runbook - UR27 File Extent Table
Runbook - UR28 Relative Block Num Convert
Runbook - UR29 File VOLSER List
Runbook - UR30 DB2 Table Read
Runbook - UR31 Data Set Name
Runbook - UR32 Dataspace Services
Runbook - UR33 Substitute Symbolic Var
Runbook - UR35 Dynamic Allocation
Runbook - UR39 GENWRITE
Runbook - UR40 HW Compress Expand
Runbook - UR45 Table Search
Runbook - UR65 Get System Info
Runbook - UR66 COBOL ENQ DEQ
Runbook - XXTHC Exit space and threads
Run Control Utilities
How to read the syntax diagrams
GVBLTPRT DD Statements
GVBLTPRT Parameter File Syntax
GVBMR91 DD Statements
GVBMR91 Parameter File Syntax
GVBVDPNL DD Statements
GVBVDPNL Parameter File Syntax
Runbook - MR48 VDP XML Importer
Runbook - MR93 Job Scheduler
Runbook - UT90 Logic Table Report
Runbook - UT99 User Abend
Compiler & Data Types
Errors
Errors in PE Programs
Errors in User-Exits
Errors in Sub-Programs
Errors in Run Control Utilities
Errors in Workbench
Reference
Publications
REA Accounting Guide
Frequently Asked Questions (FAQ)
Website Index
About this website
Workbench Logic Text
Workbench Logic Text Types
Format Column Calculations (FCC)
Format Column Calculations (FCC)
Table of contents
Introduction - Format Column Calculations (FCC)
Examples - COLUMN statements
Examples - IF statements with COLUMN