an overview of advantage ca culprit for ca idms l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
An Overview of Advantage CA-Culprit for CA-IDMS PowerPoint Presentation
Download Presentation
An Overview of Advantage CA-Culprit for CA-IDMS

Loading in 2 Seconds...

play fullscreen
1 / 40

An Overview of Advantage CA-Culprit for CA-IDMS - PowerPoint PPT Presentation


  • 864 Views
  • Uploaded on

An Overview of Advantage CA-Culprit for CA-IDMS. Brock Shaw (Author Carla Pereira, CA).

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'An Overview of Advantage CA-Culprit for CA-IDMS' - Antony


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
an overview of advantage ca culprit for ca idms

An Overview of Advantage CA-Culprit for CA-IDMS

Brock Shaw

(Author Carla Pereira, CA)

(c) 2003 Computer Associates International, Inc.(CA) All trademarks, trade names, service marks and logos herein belong to their respective referenced companies. CA confidential and proprietary information for CA internal use only. No unauthorized copying or distribution permitted.

topics of discussion
Topics of Discussion
  • What is Advantage CA-Culprit forCA-IDMS?
  • Processing Phases
  • Basic Parameter Types
  • Advantage CA-IDMS Database Access
  • JCL Considerations
  • Debugging
advantage ca culprit for ca idms

IDD

VSAM

Sequential

IDMS

CARD

CARD

CULPRIT

VSAM

IDMS

Sequential

Advantage CA-Culprit for CA-IDMS

INPUT DATABASES

INPUT FILES

OUTPUT FILES

STORED TABLES

PRINTED REPORTS SPECIAL FORMS

processing phases

PARAMETERS

COPIED PARAMETERS

Sequential Parameter Listing

Precompile Phase (CULP0)

PARAMETER VALIDATION

PARAMETER SORT

Parameter Sort

Input Parameter Listing

Compile Phase (CULL)

BUILD CODE

Run-Time Messages

Extract Phase (CULL)

INPUT

EXTRACT DATA

Processing Phases
processing phases cont

NO

YES

Sort Required?

Unsorted Extracted Items and Statistics

No Sort Extracted Items

SORT

Data Sort

Sorted Extracted Items and Statistics

Edit and Total Processing

Output Phase (CULE)

REPORTS

Processing Phases (cont.)
general coding considerations
General Coding Considerations
  • All parameters must be in uppercase
  • Column 1 blank
  • Columns 72-80 ignored
  • Continuation denoted by * in column 1
  • Comments denoted by $
  • Blank and comma interchangeable are delimiters
input parameters
Input Parameters
  • PROFILE
    • Used on a run-by-run basis to override system defaults
  • INPUT
    • Describes each input file
  • REC
    • Defines the fields in the input file
    • Automatically generated for database records
input parameters cont
Input Parameters (cont.)
  • SELECT
    • Used when all reports in a single run want the same subset of records
    • Can apply to specific INPUT files or database PATHs
output parameters
Output Parameters
  • OUTPUT
    • Describes output report or file
  • SORT
    • Specifies order of detail lines in each report
    • Specifies control breaks (subtotals)
  • TITLE
    • Describes 1 to 50 character title line printed at the top of each page
output parameters cont
Output Parameters (cont.)
  • Edit (4,5,6)
    • Defines output lines for each report
      • Header (type 4)
      • Detail (type 5)
      • Total (type 6)
    • At least one detail (5) per report required
    • Specifies output items, location and editing options
output parameters cont11
Output Parameters (cont.)
  • Process (7,8)
    • Logic for processing the data
    • Type 7 executed against the input file to create the extract file
    • Type 8 executed against the sorted extract file when a control break occurs
    • LEVL indicates current subtotal level in Type 8 logic
type 7 operations
Control

PERFORM/RETURN

CALL

PICK/UNPICK

RELS

TAKE

DROP

Type 7 Operations

Arithmetic

ADD (+)

MINUS (S) (-)

TIMES (X)

DIVIDE (/)

COMPUTE (C)

  • Conditional
    • IF
    • EOF
    • B (GOTO)
  • Assignment

MOVE

CONVERT

other basic parameters
Other Basic Parameters
  • Work field (0)
    • Defines new fields not found in input file
    • Alphanumeric or numeric
  • =MACRO, =COPY, USE
    • Copy stored code into parameter stream from
      • IDD
      • PDS
      • Source Statement Library
      • AllFusion Panvalet Library
      • AllFusion Librarian Library
other basic parameters cont
Other Basic Parameters (cont.)
  • CALL
    • Used to invoke a procedure module from processing logic (type 7)
    • CA-supplied user modules or user-written
    • US12
      • Century date conversion routine
    • US00
      • Interface to routine which was not written specifically for Advantage CA-Culprit
      • LO91988(MVS) or LO92554(VSE): modules called via US00 can be RMODE 31 and do not need RTEREUS=YES
advantage ca idms database retrieval
Advantage CA-IDMS Database Retrieval
  • DATABASE Parameter
  • INPUT Parameter
  • PATH Parameter
  • KEY/KEYFILE Parameter
  • DB-EXIT Facility
  • Miscellaneous Structures
database parameter
DATABASE Parameter
  • Optional, but if specified must precede all other parameters
  • DICTNAME
  • DICTNODE
  • DBNAME
  • DBNODE
input parameter
INPUT Parameter
  • Database options
  • DB(D)
  • SS=subschema (schema) (version)
path parameter
PATH Parameter
  • Describes the records and order of their retrieval from the database
  • Establishes a common entry record
  • Specifies set relationships
  • Allows Advantage CA-Culprit to process incomplete paths
  • Indicates whether an index set will be used
rules for coding paths
Rules for Coding PATHs
  • The entry record can be any record type, and the path can proceed from owner to member of member to owner
  • When a record is retrieved using an owner to member traversal, the next record on the path must be related directly to the member record
  • When a record is retrieved using a member to owner traversal, the next record can be related directly to the owner record or to any previous record on the path as long as that previous record, and any intervening records, were retrieved in a member to owner traversal
rules for coding paths cont

PATHB5 DEPARTMENT JOB

PATHRR DEPARTMENT EMPLOYEE OFFICE

PATHM1 EMPLOYEE EXPERTISE SKILL OFFICE

PATH22 EXPERTISE EMPLOYEE OFFICE SKILL

Rules for Coding PATHs (cont.)
  • Based on the data structure diagram, are the following PATHs valid?
multiple path parameters
Multiple PATH Parameters
  • Allows navigation of the database in more than one way
  • Entry record must be the same on each path
multiple path parameters cont

PATHZZ DEPARTMENT EMPLOYEE *EMPOSITION JOB

PATHYY DEPARTMENT EMPLOYEE

PATHZZ DEPARMENT EMPLOYEE *EMPOSITION JOB

Multiple PATH Parameters (cont.)
  • In this path, not all employees will be retrieved
  • An additional path will need to be coded
key keyfile
KEY/KEYFILE
  • Limits access to the database by limiting retrieval of the entry record
  • KEYs must be a CALC, Index or dbkey
  • Can specify a value or range of values
  • KEY statement coded directly in report
  • KEYFILE contains a file of keys and optionally other fields to be used by report
db exit
DB-EXIT
  • Access database record from 7 logic
  • Define dummy path (PATH --)
  • IDMS-STATUS contains Advantage CA-IDMS return code
  • For invalid call, IDMS-STATUS set to *00n
  • Can be used in conjunction with automatic path or alone
miscellaneous structures
Miscellaneous Structures
  • Indexed records
    • Qualify the record on path with index set name
  • Bill of material (nested) structure
    • Qualify fields with occurrence number
  • Multiple-Member sets
    • ALL-MEMBERS option
  • Logical Records
    • Can specify where clause on path
advantage ca idms database sql option
Advantage CA-IDMS Database SQL Option
  • Advantage CA-Culprit can perform for the following operations on an Advantage CA-IDMS SQL defined-database
    • Read rows
    • Add/Update/Delete rows
    • Create tables
    • Drop tables
parameter considerations for sql
Parameter Considerations for SQL
  • INPUT
    • DB(Q), SQL=(FIPS,ANSI,CAX)
  • SQL
    • Specify the SQL query
  • REC
    • Automatically generated
    • fieldname_NULL_IND for NULL indicators
  • OUTPUT
    • SQLTABLE=
    • TYPE=CREATE/ADD/REPLACE/DROP
jcl considerations
JCL Considerations
  • One-step JCL
  • Five-step JCL
  • Default file assignments
debugging
Debugging
  • Listings
  • Forced Buffer Dump
  • CULLUS48
  • Display Intermediate Results
  • Advantage CA-Culprit Manuals
listings
Listings
  • PARAM=LIST/NOLIST
  • Sequential Parameter Listing
  • Input Parameter Listing
  • Run Time Messages
forced buffer dump

010 ZERO 0

017 ZERO / ZERO ZERO

Forced Buffer Dump
  • Issue divide by zero in 7-logic
cullus48

017 CALL US48(‘0Entering this logic %%’)

CULLUS48
  • Add your own messages to the Run-time Message section
  • The message can be an alphanumeric work field up to 132 characters
  • The message must begin with a carriage control character and end with %%
advantage ca culprit manuals
Advantage CA-Culprit Manuals
  • Reference
  • User Guide
  • User Module Manual
  • Error Codes and Messages
session summary
Session Summary
  • Advantage CA-Culprit is a powerful tool for creating reports from sequential files and Advantage CA-IDMS databases.