Example 1: Defining Your Own Output Record

Handling Output Records › Example 1: Defining Your Own Output Record

Example 1: Defining Your Own Output Record

DataManager provides many predefined records that your PMA applications can use. However, you may want your PMA application to include other data collected at your site. This example shows how to handle the following input for DataManager use.

Field Name         Description        Fmt    Atr   Offset   Len   Prec

JOBNAME            JOB NAME            C             1       8
STARTDATE          JOB START DATE      N     DN      9       8
STARTTIME          JOB START TIME      N     T      17       6
STOPDATE           JOB END DATE        N     DN     27       8
STOPTIME           JOB END TIME        N     T      35       6
ELAPSEDTIME        ELAPSED TIME        N     TD     45       8
CPUTIME            CPU DURATION        N     TD     53       6
I/O DBS            I/O DBS             N            61       5
EXCPS              EXCPS               N            66       5

Using the fast path, you can start building an output record by typing OO on the Primary Panel and pressing Enter. That displays a blank Output Record Description panel. The first step to follow when defining a new output record is describing the new ORD on this panel.

userid CA PMA/DataManager mm/dd/yy hh:mm:ss __ Input Output oPtions Exit Help +-- DMODESP -----Output Record Description --------------- º Panel Exit Help º ------------------------------------------------------- º Enter a New Output Record Description or Browse ORDs | º ORD Name . . . . . . . OUR º Description . . . . . OUR PERFORMANCE DATA º º F2=Create F11=Browse +---------------------------------------------------------

To describe this new ORD, type in a unique value for ORD Name. Description is optional and Record Length is computed by DataManager.

Then press F2 to save this description and proceed with defining the fields in this ORD on the Output Record Definition panel.

Output Record Definition Panel

userid CA PMA/DataManager mm/dd/yy hh:mm:ss __ Input Output oPtions Exit Help +-- DMODESE ---------- Output Record Definition ----------------------------- º Panel Exit Help º -------------------------------------------------------------------------- º º ORD Name . . . : OUR º Description . . : OUR PERFORMANCE DATA More - + ____ Row ____ of 0001 º IRD Name . . . . > º º Cmd ORD Field Type IRD Field Name Fmt Len Prec Description º º _ ________________ _ ________________ _ __ __ ____________________ º _ ________________ _ ________________ _ __ __ ____________________ º _ ________________ _ ________________ _ __ __ ____________________ º _ ________________ _ ________________ _ __ __ ____________________ º _ ________________ _ ________________ _ __ __ ____________________ º _ ________________ _ ________________ _ __ __ ____________________ º º F5=Save F6=Delete F7=Bkwd F8=Fwd F11=Header +---------------------------------------------------------------------------- Command ===> ____________________________________________________________ F1=Help F3=Exit F4=Prompt F9=Command F10=Action Bar F12=Cancel PA1=Susp

Begin by specifying what IRD is the source for these fields. If you can't remember a specific IRD name, use the prompt feature to view a list of valid IRDs. You must specify an existing IRD here. This is why you must define IRDs before ORDs.

Rule:: Always define input records before output records.

To define each field, just type over the underlining and fill in ORD Field, Type, IRD Field Name, Fmt and Len values:

No two ORD fields within a record can have the same name.
The Type of data stored in this field:

C

A construct.

E

A data field extracted from an input record.

R

A redefined value. For example, mmddyy broken down into mm, dd, yy.
IRD Field Name is the name of the input field from which this output field is derived. This input field must occur on the input record specified for IRD Name.
Fmt is the format of this output field:

C

Character

D

Date: yyyymmdd. Always 8 bytes, precision 0, zoned decimal unsigned.

N

Numeric: any length, packed decimal

R

Duration in seconds. 8 digits, precision=5, packed decimal unsigned.

T

Time: hhmmsstttt. (to 1/10,000 of a second) precision 4
Len tells the number of characters in this field.

Note: The length and precision of formats D, R, and T are fixed as described on the previous page and cannot be changed.

If a field has decimal places, specify how many under Prec. The Description field is optional. After you've finished filling in the field's information, press F5 to save that field. DataManager will display a message if it has trouble processing any of your input.

When defining output fields, you can omit those that will belong in the output header record. Excluding the start and stop stamps and duration fields from this record reduces it to just these fields.

º Cmd ORD Field Type IRD Field Name Fmt Len Prec Description º º _ JOBNAME_________ E JOBNAME_________ C 8_ __ ____________________ º _ CPUTIME_________ E CPUTIME_________ R 6_ __ ____________________ º _ I/O DBS_________ E I/O DBS_________ N 5_ __ ____________________ º _ EXCPS___________ E EXCPS___________ N 5_ __ ____________________ º _ ________________ _ ________________ _ __ __ ____________________ º _ ________________ _ ________________ _ __ __ ____________________ º º F5=Save F6=Delete F7=Bkwd F8=Fwd F11=Header > +---------------------------------------------------------------------------- Command ===> ____________________________________________________________ F1=Help F3=Exit F4=Prompt F9=Command F10=Action Bar F12=Cancel PA1=Susp

You can wait to save until you've defined six new fields on the panel before saving.

Caution: You must save your entries using F5 before scrolling the panel. If you do not, the data you have entered will be cleared from the panel.

Output records all require one additional field to prepare them for input to CA PMA Chargeback. That field must be called CB-CONS and have Type C. Instead of specifying an IRD Field Name for construct fields, you specify the name of the program DataManager should run to supply values for this field. For CA PMA Chargeback, that program name is CA$KRCN and it returns values up to 84 characters long.

Rule:: Always remember to define an output construct field called CB-CONS.

º Cmd ORD Field Type IRD Field Name Fmt Len Prec Description º º _ JOBNAME_________ E JOBNAME_________ C 8_ __ ____________________ º _ CPUTIME_________ E CPUTIME_________ R 6_ __ ____________________ º _ I/O DBS_________ E I/O DBS_________ N 5_ __ ____________________ º _ EXCPS___________ E EXCPS___________ N 5_ __ ____________________ º _ CB-CONS_________ C CA$KRCN_________ C 84 __ ____________________ > º _ ________________ _ ________________ _ __ __ ____________________ º º F5=Save F6=Delete F7=Bkwd F8=Fwd F11=Header +---------------------------------------------------------------------------- Command ===> ____________________________________________________________ F1=Help F3=Exit F4=Prompt F9=Command F10=Action Bar F12=Cancel PA1=Susp

Be sure to remember to save the construct field by pressing F5. Then press F11 to define the Output Record Header by filling in IRD field names.

Output Record Header Panel

userid CA PMA/DataManager mm/dd/yy hh:mm:ss __ Input Output oPtions Exit Help +- DMODESH ----------- Output Record Header --------------- ---------------- º Panel Exit Help º -------------------------------------------------------- --------------- º Enter the Output Record Header Information | º ORD Name : OUR 0000 of: 0000 º IRD Name : OURSITE º º IRD Date IRD Time ription º Field Field º _____________ º Start Stamp . STARTDATE_______ STARTTIME_______ _____________ º Stop Stamp . STOPDATE________ STOPTIME________ _____________ º _____________ º Duration Time . . . . . . . . . . . ELAPSEDTIME_____ _____________ | _____________ º F5=Save +---------------------------------------------------------- +---------------------------------------------------------------------------- Command ===> ____________________________________________________________ F1=Help F3=Exit F4=Prompt F9=Command F10=Action Bar F12=Cancel PA1=Susp

Then press F5 to save this information.

Rule:: Always remember to define an output record header.