G Import Mass Data

A few of the technical interactive programs can run in batch mode and accept data from a Z file, allowing you to process mass amounts of data from an outside source easily and efficiently using existing programs to validate the data.

You can process any number of records to add, change, or delete. You also have the advantage of:

  • Data selection to limit the records you want to process.

  • Processing options that allow you to choose the version of the interactive program to process the records.

  • Error report printing.

Generally, the DREAM Writer program number corresponds to the screen and program number with a Z appended to the end. For example, P9612Z corresponds to the Function Key Security program (P9612).

The following table includes technical Z file processing programs.

Program Program Name Z File Program Z File
P8202 World Writer File/Field Security P8202Z F8202HZ (header) and F8202DZ (detail)
P9425 Report Writer Form Security P9425Z F9425HZ (header) and F9425DZ (detail)
P9612 Function Key Security P9612Z F9612HZ (header) and F9612DZ (detail)

Navigation

From World Writer Advanced Operations (G8231), choose File/Field Security Z FIle

or

From Security Z File Processes (G9401Z), choose an appropriate option

Technical Considerations

When you set up the World Writer File/Field Level Security - Z File program (P8202Z), be aware of the following:

  • Use only A (Add), C (Change), or D (Delete) in the Transaction Action (VDEDTC) field to set the Action code.

  • To delete single records, set the subfile hidden field (SHFLDN) to the field you want to delete for the User and File you enter in the F8202HZ (header) file. Enter C in the VDEDTC field of the F8202HZ file.

When you set up the Report Writer Form Security - Z File program (P9425Z), be aware of the following:

  • Use only A (Add), C (Change), or D (Delete) in the Transaction Action (VDEDTC) field to set the Action code.

  • To delete single records, set the subfile hidden field (SHFLDN) to the field you want to delete for the User and File you enter in the F9425HZ (header) file. Enter C in the VDEDTC field of the F9425HZ file.

When you set up the Function Key Security Z-File Process program (P9612Z), be aware of the following:

  • The Transaction Number is part of the key sequence for the Function Key Security Z-files (F9612HZ,DZ). A resolution for the value of the Transaction number is to have an identical number of significant digits or characters for this field value on every record.

  • Data entry for fields in F9612HZ (header file):

    • Action Code field (VDEDTC):

      Use only uppercase letters. Use A or 1 to add records, C or 2 to change records, and D to delete records.

      When you delete, the program deletes all detail records in the Function Key Security Maintenance File (F9612) for the User, Group or *PUBLIC or for the Video Screen or *ALL.

    • User (VDUSER) - Use this field to choose Function Key Security records for a particular User, Group or *PUBLIC. When you enter a value for this field, leave the Video Screen field (VDVSCR) blank.

    • Video Screen (VDVSCR) - Use this field to choose Function Key Security Records for a particular Video Screen or for *ALL. When you enter a value for this field, leave the User (VDUSER) field blank.

  • Data entry for fields in F9612DZ (detail file):

    • User (SFUSER) - Enter the value for User, Group, or *PUBLIC in this field.You must enter a value in this field when the Video Screen (VDVSCR) field in F9612HZ contains a value.

    • Screen (SFVSCR) - Enter a value for the form name that you use to setup access to Function Key/Selection Options. Use the value *ALL to specify Allow Y/N for all screens that you do not specifically define. If this value is set to *ALL, the Data Field Name (FLDN) allows only values of *ALL or *STD. You must enter a value in this field when the User (VDUSER) field in F9612HZ contains a value.

    • Field (SFFLDN) - Use this field to specify what Function Key/Selection Options you permit for a Screen. If Screen (SFVSCR) contains the value *ALL, then you can only enter *ALL or *STD in this field. If this value is *STD then the Allow Y/N (SFUSAL) field must contain the value Y.

    • Allow Y/N (SFUSAL) - Use this field to specify whether you allow access for the specific combination of User/Video/Function Key or Selection Option/ or Video/User/Function Key or Selection Option.

Processing Options

See the appropriate set of processing options in Chapter 68, "Additional DREAM Writer Options Processing Options".

Data Selection

Do not change the existing data selection. The Processed Y/N field is set to NE Y. This prevents the program from processing records more than once.

You can add additional selections to limit the data.

Data Sequence

Do not change the data sequence.