Optional table updates

The purpose of this function is to help you to update tables that are large (several thousands of lines) and updated frequently (daily, for example). To do this, you can use the direct update available in Rule Engine.

This function must be used for tables for which you have set the Rule Engine option entries handled by Rule Engine.

The procedure is:

  1. Export the table structure from AI Enabler to Rule Engine. Update Rule Engine by running the RDJMAJ from the files produced during the exchange.
  2. On successful completion of the first step, create an update file in Rule Engine containing the data values to be updated.
  3. Update the parameter settings by running the RDJMAJ procedure with the update file.

Create an update file

The update file must be saved in:

  • $RDJ_EXEC/dat directory for UNIX
  • %RDJ_EXEC%\dat directory for Windows
  • <RDJ_EXEC>.DATLIB.MVTRDJ for MVS

It must be called mvt.mvt (UNIX and Windows) or mvtmaj (MVS).

You cannot add entries to an existing internal table (partial update). The only possible action is to replace the table (complete update).

The update file contains the description of the user table (table name, argument characteristics and associated value) as well as a list of entries (argument/value pair) that the table will include.

This file comprises two table header lines (command delete and create table) and a set of lines that represent each table entry (argument/value pair). The line length is limited to 105 characters.

Axway Rule Engine enables you to manage entries that have:

  • arguments up to 128 characters long
  • associated values up to 256 characters long

However, it is also possible to manage arguments limited to 17 characters to enable processing of RDJ V8 internal tables.

Syntax of mvt.mvt file

The mvt.mvt is a sequential file composed of two sections:

  • Header: This is a two-line description of the table, that is, the table name and characteristics of the argument and value
  • Set of lines where each line represents a table entry within this table, that is, an argument/ value pair

The length of each of these lines is limited to 105 characters.

Rule Engine can handle arguments of up to 128 characters long with associated values of up to 256 characters. However to ensure compatibility with RDJ V8 tables, Rule Engine has a special procedure for handling arguments limited to 17 characters. The following sections describe the syntax of the headers and table entry lines in tables with arguments limited to 17 characters and those with arguments exceeding 17 characters.

Header syntax: Tables with arguments limited to 17 characters

The illustration below shows the required syntax for the header. The TAB header code at the beginning of the line indicates that this is an update to an internal table whose argument does not exceed 17 characters.

Specifying header fields

Note   The fields must be in the position shown in the illustration to be read correctly by the parameter update procedure. Fill unused fields with blanks to maintain the correct positioning of the subsequent fields. You must supply values for all fields.

The table below explains how to specify each field in the header.

Field Position Length Value

Table name

4

8

Name of the table that you want to update

Update code

36

1

Type of update:

0:

If the line contains:

  • The table name, header code and update code, 0 corresponds to a request to delete the entire table.
  • All elements, 0 represents a request to delete the argument and value of the table entry indicated on that line.

1:

Requests the creation of an internal table

2:

Requests the modification of an internal table

SPACE
(char.):

Automatically handled by the update program

 

Fast access code

39

1

Fast access mode loads the corresponding table entry into memory during the initialization of the Input-Event Transformation Phase:

Y:

Activates fast access

N:

Disables fast access

BLANK:

If you do not specify a code, Rule Engine applies the default value, that is, Y.

 

Argument class

40

1

Data class of the table entry argument to search for:

  • N: Numeric
  • D: Date
  • A: Alphanumeric

Argument length

41

2

Length of the table entry argument to search for (two numeric characters depending on the data class):

  • Between 01 and 17 for Numeric and Alphanumeric
  • Either 06 or 07 for Date

 

Value class

43

1

Data class of the table entry value to search for:

  • N: Numeric
  • D: Date
  • A: Alphanumeric

Note: You can only change the characteristics of the table if it does not contain any table entries already.

Value length

44

3

Value length: Three numeric characters between 001 and 256.

Note: You can only change the characteristics of the table if it does not contain any table entries already.

Table header label

47

30

Table header label: Between 1-30 alphanumeric characters.

Table check

77

1

Set the code :

  • Y: to activate the check on the existence of the Table
  • N: to deactivate the check on the existence of the Table
  • BLANK: default value

Header syntax: Tables with arguments exceeding 17 characters

The illustration below shows the required syntax for the header. The TBL header code at the beginning of the line indicates that this is an update to an internal table whose argument is between 18 and 128 characters.

The table below explains how to specify each field in the header.

Field Position Length Value

Table name

4

8

Name of the table that you want to update

Update code

36

1

Type of update:

0:

If the line contains:

  • The table name, header code and update code, 0 corresponds to a request to delete the entire table.
  • All elements, 0 represents a request to delete the argument and value of the table entry indicated on that line.

1:

Requests the creation of an internal table

2:

Requests the modification of an internal table

SPACE
(char.):

Automatically handled by the update program

 

Fast access code

39

1

Fast access mode loads the corresponding table entry into memory during the initialization of the Input-Event Transformation Phase:

Y:

Activates fast access

N:

Disables fast access

BLANK:

If you do not specify a code, Rule Engine applies the default value, that is, Y.

 

Argument class

40

1

Data class of the table entry argument to search for:

  • N: Numeric
  • D: Date
  • A: Alphanumeric

Argument length

41

3

Length of the table entry argument to search for: three numeric characters between 018 and 128

 

Value class

44

1

Data class of the table entry value to search for:

  • N: Numeric
  • D: Date
  • A: Alphanumeric

Note: You can only change the characteristics of the table if it does not contain any table entries already.

Value length

45

3

Value length: three numeric characters between 001 and 256.

Note: You can only change the characteristics of the table if it does not contain any table entries already.

Table header label

48

30

Table header label: between 1-30 alphanumeric characters.

Table Check

78

1

Set the code as follows:

  • Y: Activates ExistenceTable check
  • N: Disables ExistenceTable check

BLANK: If you do not specify a code

Table entry syntax: Tables with arguments limited to 17 characters

The illustration below shows the required syntax for each table entry. The TAB header code at the beginning of the line indicates that this is an update to an internal table whose argument does not exceed 17 characters.

Specifying table entry fields

Note   The fields must be in the position shown in the illustration to be read correctly by the parameter update procedure. Fill unused fields with blanks to maintain the correct positioning of the subsequent fields. You must supply values for all fields.

The table below explains how to specify each field in the table entry.

Field Position Length Value

Argument

12

 

Search argument whose characteristics you have specified in the header.

Expiry date

29

7

Date at which the table entry value ceases to be valid
Express this date in the format CYYMMDD

Update code

36

1

Type of update whose characteristics you specified in the header

Suffix

37

2

Line identifier for a table entry. This means you can express the value of a table entry in four separate lines, each of 64 characters, making a total of 256 characters.

Set the suffix as either of the following, depending on which of the four lines contains the description of the table entry:

  • P1
  • P2
  • P3
  • P4

Fast access code

39

1

Fast access mode loads the corresponding table entry into memory during the initialization of the Input-Event Transformation Phase:

Y:

Activates fast access

N:

Disables fast access

BLANK:

If you do not specify a code, Rule Engine applies the default value, that is, Y.

 

Table entry value and associated comments

40

64

Table entry value: Set the value of the table entry that corresponds to the argument.

The characteristics of the table entry value are set in the header.

Comments: To include any comments, you must prefix them with an exclamation mark (!) to distinguish them from the table entry value.

You can define an alternative character to use as a comment marker during the Rule Engine installation procedure.

The start position of the comment cannot be less than the length of the value +one character.

 

Table entry syntax: Tables with arguments exceeding 17 characters

The illustration below shows the required syntax for each table entry. The TBL header code at the beginning of the line indicates that this is an update to an internal table whose argument is between 18 and 128 characters.

Specify table entry fields

Note   The fields must be in the position shown in the illustration to be read correctly by the parameter update procedure. Fill unused fields with blanks to maintain the correct positioning of the subsequent fields. You must supply values for all fields.

The table below explains how to specify each field in the table entry.

Field Position Length Value

Argument

12

 

Search argument represented by an incremential index that delimits the different arguments.

Expiry date

29

7

Date at which the table entry value ceases to be valid
Express this date in the format CYYMMDD

Update code

36

1

Type of update whose characteristics you specified in the header

Suffix

37

2

Line number that corresponds to one of the following elements:

  • Table argument: suffix A1 or A2
  • Value of table entry: suffix P1, P2, P3 or P4

Fast access code

39

1

Fast access mode loads the corresponding table entry into memory during the initialization of the Input-Event Transformation Phase:

Y:

Activates fast access

N:

Disables fast access

BLANK:

If you do not specify a code, Rule Engine applies the default value, that is, Y.

 

Table entry value and associated comments

40

64

Table entry value: Set the value of the table entry that corresponds to the argument.

The characteristics of the table entry value are set in the header.

Comments: To include any comments, you must prefix them with an exclamation mark (!) to distinguish them from the table entry value.

You can define an alternative character to use as a comment marker during the Rule Engine installation procedure.

The start position of the comment cannot be less than the length of the value +one character.

Refer to the table entry syntax table for explanations of how to specify each field in the table entry. For more information, refer to Section Table entry syntax: Tables with arguments limited to 17 characters.

Sample definition

This example updates the AGT_BAFI table, which has an argument of 6 alphanumeric characters and a value of 89 alphanumeric characters:

  • By adding a BAMMCD argument
  • By changing the DTMM05 argument
    To do this, the entry is first deleted and the new value then added.  

Eexample for AGT_BAFI table update

And this is an example of a table with an argument that exceeds 17 characters.

Example of a table with an argument that exceeds 17 characters

Specifying a VALDEF default value for tables with an argument limited to 17 characters:

Specifying a VALDEF default value for tables with an argument that exceeds 17 characters:

Execute procedure rdjmaj

The results of running rdjmaj are made available in a number of reports.

The reports on anomalies found during update of the parameter settings are stored in the edi directory (under UNIX or NT) and in files with the .EDI extension (under MVS).

The following reports are available:

  • Report on the content of the update file: listmvt.edi
  • Report on anomalies found in the update file, to allow diagnosis of problems:
    errmvt.edi, ano400.edi ,errtra.edi

Report on the update of the parameter settings: iexplmaj.edi.

Related Links