JPH0784842A - Relative record batch read system - Google Patents

Abstract

PURPOSE:To decrease the number of steps of a user program by storing records of a main and a subordinate file together in the work area of a user program. CONSTITUTION:When the user program 6 sends a relative record batch read instruction 60 to the main file, a relative record batch read instruction control part 10 reads a record RA out of the main file A by a main file read means 14 and stores it in an input/output buffer 11. Then on the basis of the contents of the record RA which are read in previously by a subordinate file read means 15 and the contents of an assignment information file 4, key values at the time of retrieval of subordinate files B and C and subordinate files B and C are determined and records RB and RC are read out of the subordinate files B and C determined by using the key values and stored in the input/output buffer 11. Then an informing means 16 stores the records RA-RC, read in the input/ output buffer 11, together in the work area 63 of the user program 6.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a record reading method in an information processing apparatus, and more particularly to reading a record from a certain file and reading the record from another file by using the contents of the items in the read record as a key. The related record batch reading method for executing the series of processes for one related record batch reading instruction issued from the user program.

[0002]

2. Description of the Related Art Conventionally, a user program operating on an information processing apparatus reads a record from a certain file and reads the record from another file by using the contents of the items in the read record as a key. In order to realize it, it is necessary to describe a plurality of read commands in the user program in advance. Hereinafter, a conventional technique will be described with reference to the drawings.

Now, three files A, as shown in FIG.
Assume that B and C are present. Where file A
Is a set of record RAs, and each record RA is an item a.
To e. The file B is a set of records RB, and each record RB has items b and f to i. Further, the file C is a set of records RC,
Each record RC has items c, j to m.

For such files A to C, for example, the record RA is read from the file A by using the item a as a key, and the content of the item b in the read record RA is used as the key by the record from the file B to the record RB. To read the record RC from the file C using the content of the item c in the record RA as a key, the processing as shown in FIG. 9 is described in the user program.

In FIG. 9, 100 is a read command for reading from the file A a record whose item a is equal to the value held in the work area WKA on the user program.
1 is the processing description when the read is successful, and the read file A
Processing for substituting the content of item b in the record of the above into the variable X1 and the content of item c into the variable X2.
A read command for reading a record having a value of 1 from the file B, and a read command 106 for reading a record having an item c having a value of the variable X2 from the file C. In addition,
Reference numerals 102, 105 and 108 describe the processing to be performed when each read instruction is unsuccessful, and 104 sets the content of the item f in the record of the file B read when the read instruction 103 succeeds in the variable X3. Description of processing, 10
7 is a file C read when the read command 106 is successful.
Is a description of the process of setting the content of item j in the record of (1) to variable X4.

FIG. 10 is a diagram for explaining the operation of the OS 201 on the information processing apparatus when the user program 200 including the process description as shown in FIG. 9 is executed.

When the user program 200 issues the read command 100 shown in FIG. 9, the record read command control unit 202 in the OS 201 stores the corresponding record RA from the file A (the contents of the item a are stored in the work area WKA). Record equal to content) input / output buffer 203
The read record RA is transferred to the user work area 204.

The user program 200 is 101 in FIG.
By executing the process corresponding to, the content of the item b of the record RA transferred to the user work area 204 is set to the variable X1, and the content of the item c is set to the variable X2.

Next, when the user program 200 issues the read command 103 of FIG. 9, the record read command control unit 202 causes the record B of the corresponding record RB from the file B.
(A record in which the content of item b is equal to the content of the variable X1) is read into the input / output buffer 203 and further transferred to the user work area 204.

The user program 200 is 104 in FIG.
The contents of the item f of the record RB in the user work area 204 is set to the variable X3 by executing the process corresponding to.

Next, when the read command 106 of FIG. 9 is issued from the user program 200, the record read command control section 202 causes the corresponding record RC from the file C.
The record RC in which the content of the item c is equal to the content of the variable X2 is transferred to the user work area 204 via the input / output buffer 203, and the user program 200 executes a process corresponding to 107 in FIG. The content of the item j in the inside is set to the variable X4.

[0012]

As described above, when a record is read from a certain file and the record is read from another file by using the contents of the items in the read record as a key, the conventional method is shown in FIG. As described above, it is necessary to describe a plurality of read commands in the user program, which increases the number of steps of the user program and takes a lot of time for creating.

The present invention has been proposed in view of such circumstances, and an object thereof is to read a record from a certain file, and use the contents of the items in the read record as a key to read from another file. It is to provide a related record batch reading method that can realize a series of processes of reading records by simply describing one related record batch reading instruction in a user program.

[0014]

In order to achieve the above object, the present invention has the following constitution.

(A) Assignment information that holds a correspondence relationship between an item serving as an indirect key among the items in the record of the main file and a sub file that includes a record searched using the value of the item serving as the indirect key as a key A file and a related record batch read command control unit provided in the operating system are provided, and a related program batch read command is issued from the user program to the main file to the related record batch read command control unit. To read the record from the main file and store it in the input / output buffer, and the sub-file and the sub-file based on the content of the record read by the main file reading means and the content of the assignment information file. Decide the key value when searching the sub-file and decide -A sub-file reading means for reading a record from the determined sub-file by using a key value and storing it in the input / output buffer, and a record of the main file and a record of the sub-file read in the input / output buffer all together. And a notification means for storing the user program in the work area.

(B) Among the items in the record of the main file, an item serving as an indirect key and a subfile containing a record searched using the value of the item serving as the indirect key as a key are registered. An assignment information file, a registration file that enumerates the items that exist in the record for all files that can be sub-files, an indirect key setting table that sets the items of the main file that is the indirect key, and the source when the user program is translated. The program includes a compiler for setting an item of a main file as an indirect key described in a program in the indirect key setting table, and a related record batch reading instruction control unit provided in an operating system, and In the batch record reading command control unit, from the user program to the main file By issuing the continuous record batch reading command, an item to be an indirect key among the items in the record of the main file, and the indirect key thereof, based on the contents of the indirect key setting table and the contents of the registered file. Assign information file registration means for registering the correspondence relationship with the sub file containing the record to be searched with the value of the item as a key, and the main file read for reading the record from the main file and storing it in the input / output buffer And a key value for searching the sub-file and the sub-file based on the content of the record read by the main file reading means and the content of the assignment information file, and use the determined key value Then, the record is read from the determined sub-file and stored in the input / output buffer. Structure comprising a sub-file read unit that, a notification means for storing in the work area of the user program collectively record the record and subfile of the main file that was read into the output buffer.

[0017]

In the related record batch reading method of configuration (A), the assignment information file is searched using the item serving as an indirect key among the items in the record of the main file and the value of the item serving as the indirect key as a key. The related record batch read instruction control unit provided in the operating system issues a related record batch read instruction from the user program to the main file. When,
The main file reading means reads the record from the main file and stores it in the input / output buffer, and then the sub file reading means reads the record based on the contents of the record read by the main file reading means and the contents of the assignment information file. Determines the key value for searching files and subfiles, uses this determined key value to read records from the determined subfile and store them in the I / O buffer, and then the notification means Store the read main file record and sub file record in the work area of the user program all together.

In the related record batch reading method of configuration (B), the compiler sets the item of the main file as the indirect key described in the source program when the user program is translated in the indirect key setting table, and When the user program issues a related record batch read command to the main file, the related record batch read command control unit provided in the system causes the assignment information file registration means to display the contents of the indirect key setting table and the sub file. Based on the contents of the registered file that lists the items that exist in that record for all files that can be files, the items that are indirect keys among the items in the record of the main file and the values of the items that are indirect keys With a subfile containing the records to be searched with The correspondence is registered in the assignment information file, then the main file reading means reads the record from the main file and stores it in the input / output buffer, and then the sub file reading means reads the record read by the main file reading means. And a key value for searching the subfile based on the contents of the assignment information file and the key value for searching the subfile, and using this determined key value, read the record from the determined subfile and store it in the I / O buffer. Then, the notifying means collectively stores the record of the main file and the record of the sub file read in the input / output buffer in the work area of the user program.

[0019]

Embodiments of the present invention will now be described in detail with reference to the drawings.

Referring to FIG. 1, an example of an information processing apparatus to which the related record batch reading method of the present invention is applied is an operating system (OS) 1, an indirect key setting table 2, a registration file 3, and assignment information. A file 4, a compiler 7 that compiles a source format user program 5 to generate an object format user program 6, and a plurality of files A to be processed,
B and C are included.

The OS 1 also includes a related record batch read instruction control unit 10 and an input / output buffer 11.
The related record batch reading command control unit 10 is composed of a judging unit 12, an assignment information file registering unit 13, a main file reading unit 14, a sub file reading unit 15 and a notifying unit 16.

FIG. 2 shows an example of a related record batch reading command 60 included in the user program 6 and this command 60.
An example of the processing description 61 when the reading by the
An example of the indirect key definition 62 is shown. The related record batch read command 60 is a kind of read command for reading a record in which the item a is equal to the value held in the work area WKA from the file A, and unlike the read command 100 shown in FIG. A parameter $ indicating that it is a batch read command is added. Also,
Item b and item c are defined as the indirect key definition 62.

FIG. 3 shows an indirect key set in the indirect key setting table 2 according to the indirect key definition 62 in the user program 5 when the compiler 7 compiles the source type user program 5 to generate the object type user program 6. An example of information is shown. In this example, item b
And the fact that item c is an indirect key are set in the indirect key setting table 2.

FIG. 4 is a diagram showing an example of the contents of the registration file 3. In this example, for the files B and C that may be sub-files, what items they have is described. The configurations of the files B and C are the same as those described in FIG. 8, and the configuration of the file A is the same as that described in FIG.

5 and 6 are flowcharts showing an example of processing of the related record batch read instruction control unit 10, and S1 to S16 show respective steps. FIG. 7 is a diagram showing an example of the contents of the assignment information file 4. Less than,
The operation of this embodiment will be described with reference to the drawings.

The user can use the file A as shown in FIG.
As a process for .about.C, the record RA is read from the file A by using the item a as a key, the record RB is read from the file B by using the content of the item b in the read record RA as a key, and the item c in the record RA is further read. When the process of reading the record RC from the file C is performed by using the contents of the above as a key, the related record batch reading instruction 60 as shown in FIG. 2 is described in the user program 5 for each reading position of the record RA. . In addition, a process such as 61 in FIG. 2 is described as a process when the reading is successful. Furthermore, since items b and c of file A are used as indirect keys, items b and c
Is defined as an indirect key in the user program 5 (62). Generally, in a source program such as Kobol, it is necessary to declare files to be used, and since files A to C are used in this example, they are declared. Further, the registration file 3 and the assignment information file 4 used indirectly are also declared.

When the compiler 7 compiles the user program 5 to generate the user program 6, the indirect key information 62 of FIG. 2 defined in the user program 5 is generated.
Is set in the indirect key setting table 2 that can be referred to by the OS 1 as shown in FIG.

When the user program 6 is executed and the related record batch read command 60 is issued, the related record batch read command control unit 10 of the OS 1 starts the process shown in FIG.

First, the determining means 12 identifies that the read command issued is a related record batch read command by the parameter $ of the command (S1).

Next, the assignment information file registration means 13
Then, the registered flag 70 of FIG. 7 provided in the assignment information file 4 is checked to determine whether the assignment information has been registered (S2).

If the issued related record batch read command 60 is the related record batch read command executed first after the user program 6 is started,
Since the registered flag 70 is off, the assignment information file registration means 13 executes the processing of S3 to S7 to perform the registration processing in the assignment information file 4.

That is, first, the item b is input as an indirect key from the indirect key setting table 2 (S3). Next, the registered file 3 of FIG. 4 is searched for with the input indirect key item b, and the file B including the indirect key item b is acquired as a subfile (S5). The correspondence relationship with B is registered in the assignment information file 4 as shown in FIG. 7 (S6).

Next, returning to the process S3, the next indirect key item c is input from the indirect key setting table 2, and in the process S5 the registered file 3 is searched by using the item c as a key to obtain the sub file C. In step S6, the correspondence relationship between the indirect key item c and the sub file C is registered in the assignment information file 4 as shown in FIG. With this, indirect key setting table 2
Since the processing for all of the indirect keys therein has been completed, it is determined in processing S4, the registered flag 70 of the assignment information file 4 in FIG. 7 is turned on in processing S7, and the processing proceeds to the processing in FIG.

When the processing by the assignment information file registration means 13 is completed, the main file reading means 14 then reads the record of the main file (S8). That is, in the case of the related record batch read command 60 shown in FIG. 2, the corresponding record RA (the record in which the content of item a is equal to the content stored in the work area WKA) is read from the file A into the input / output buffer 11.

Next, the sub-file reading means 15 executes the processes S9 to S14 of FIG. That is,
First, the item b that serves as an indirect key is extracted from the assignment information file 4 (S9), and the value of the extracted item b is read by the main file reading means 14 as a record RA.
From the assignment information file 4 (S12), and the sub file B corresponding to the item b of the indirect key is retrieved from the assignment information file 4 (S12). Then, a record is read from the secondary file B with the value of the item b of the indirect key, and the read record RB is stored in the input / output buffer 11 (S1).
4).

Then, the process returns to the process S12 of acquiring the sub-file corresponding to the item b of the indirect key, but in the example of FIG. 7, since the only sub-file corresponding to the item b of the indirect key is the file B, the processes S13 to S9. Return to. If a plurality of sub-files are registered in the assignment information file 4 for one indirect key item, a record is read from each sub-file with the indirect key.

Returning to step S9, the next indirect key item c is retrieved from the assignment information file 4, and the value of the retrieved indirect key item c is obtained from the record RA read from the main file A (S11). Further, the sub file C corresponding to the item c of the indirect key is taken out from the assignment information file 4 (S12). And the indirect key item c
Value is read from the sub file C, and the read record RC is stored in the input / output buffer 11 (S1).
4). Then, the process returns to the acquisition process S12 of the sub file corresponding to the indirect key item c, but in the present example, the only sub file corresponding to the indirect key item c is the file C, so the process returns to the process S9.

Returning to step S9, since there is no unprocessed indirect key remaining in the assignment information file 4, it is discriminated in step S10 and the process proceeds to step S16 in FIG.

In step S16, the notifying means 16 collectively stores the record RA of the file A, the record RB of the file B, and the record RC of the file C stored in the input / output buffer 11 in the user work area 63. .

With this, the processing of the OS 1 relating to the related record batch read instruction 60 issued from the user program 6 is completed, and the control is returned to the user program 6.

In the user program 6, the item b of the record RA of the file A stored in the user work area 63 is set to the variable X1 and the item c is set to the variable X2 by performing the process corresponding to the process description 61 of FIG. , The item f of the record RB of the file B to the variable X3, the record R of the file C
The item j of C is substituted into the variable X4.

With the above, the execution of the processing related to one related record batch read instruction 60 is completed. A command similar to the related record batch read command 60 from another location in the user program 6 (however, a key item a
However, since the correspondence relationship between the indirect key and the sub file has already been registered in the assignment information file 4, the process proceeds from step S2 of FIG. 5 to step S8 of FIG. Following the reading of the record from A, the reading of the records from the sub-files B and C is performed, and those records are collectively returned to the user program 6.

As described above, in this embodiment, it is possible to read the records from the related sub-file with one related record batch reading command. If the record read command issued from the user program 6 to the main file A is a normal read command,
In step S15 of FIG. 5, the main file reading means 14
A record is read from the main file and stored in the input / output buffer 11 by the, and the stored record is stored in the work area 63 of the user program 6 by the notifying means 16 in step S16.

In the above embodiment, the assignment information file 4
The registration was performed by the OS, but it is also possible for the user to register the necessary information in advance in the assignment information file 4, in which case the indirect key setting table 2, the registration file 3, the assignment information The file registration means 13 can be omitted, and the setting function for the indirect key setting table of the compiler 7 can be omitted.

[0045]

As described above, according to the related record batch reading method of the present invention, the following effects can be obtained.

A series of processes of reading a record from a certain file and reading a record from another file by using the contents of the items in the read record as a key are executed by a single related record batch reading instruction in the user program. It can be realized just by describing it.
Therefore, the number of steps of the user program is reduced, and the number of preparation steps is reduced.

The compiler has a function of setting the items of the main file as indirect keys described in the source program at the time of translation of the user program in the indirect key setting table, and the related record batch reading instruction of the operating system. According to the configuration in which the control unit has the assignment information file registration means, the user does not need to create the contents of the assignment information file by himself, but only the indirect key needs to be defined. The burden on the user at that time can be further reduced.

[Brief description of drawings]

FIG. 1 is a block diagram showing an example of an information processing apparatus to which a related record batch reading method of the present invention is applied.

FIG. 2 is a diagram showing an example of a related record batch read command and the like described in a user program.

FIG. 3 is a diagram showing an example of contents of an indirect key setting table.

FIG. 4 is a diagram showing an example of contents of a registration file.

FIG. 5 is a flowchart showing a part of a processing example of a related record batch read instruction control unit.

FIG. 6 is a flowchart showing the remaining part of the processing example of the related record batch read instruction control unit.

7 is a diagram showing an example of contents of an assignment information file 4. FIG.

FIG. 8 is a diagram showing an example of files to be processed and items of records in each file.

FIG. 9 is a diagram showing a conventional description example in a user program when a record is read from another file by using the content of an item in the record read from a certain file as a key.

FIG. 10 is O during execution of the user program of FIG.
It is an operation | movement explanatory drawing of S.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 ... Operating system (OS) 10 ... Related record batch reading command control unit 11 ... Input / output buffer 12 ... Judgment means 13 ... Assignment information file registration means 14 ... Main file reading means 15 ... Sub file reading means 16 ... Notification means 2 ... Indirect key setting table 3 ... Registration file 4 ... Assignment information file 5 ... Source format user program 6 ... Object format user program 60 ... Related record batch read instruction 63 ... User work area 7 ... Compiler A, B, C ... Processing Target file

Claims (3)

[Claims] 1. An assignment information file which holds a correspondence relationship between an item serving as an indirect key among the items in a record of a main file and a sub file including a record searched by using a value of the item serving as the indirect key as a key. And a related record batch read command control unit provided in the operating system, and a related program batch read command is issued from the user program to the main file to the related record batch read command control unit. The main file reading means for reading a record from the main file and storing it in the input / output buffer, and the sub file and the sub file based on the contents of the record read by the main file reading means and the contents of the assignment information file. Decide the key value for searching the file, and A sub-file reading unit that reads a record from the determined sub-file by using a value and stores the record in the input / output buffer, and a record of the main file and the sub-file record read in the input / output buffer by a user A related record batch reading method comprising: a notification means for storing the program in a work area of the program. 2. An assignment for registering a correspondence relationship between an item serving as an indirect key among the items in a record of a main file and a sub file including a record searched by using a value of the item serving as the indirect key as a key. An information file, a registration file that lists the items that exist in the record for all files that can be sub-files, an indirect key setting table that sets the items of the main file that is the indirect key, and the source program when the user program is translated. A related file batch read instruction control unit provided in the operating system, and a compiler for setting the items of the main file as indirect keys described in the indirect key setting table described therein; The batch read command control unit controls the main file from the user program. By issuing the continuous record batch reading command, an item to be an indirect key among the items in the record of the main file, and the indirect key thereof, based on the contents of the indirect key setting table and the contents of the registered file. Assign information file registration means for registering the correspondence relationship with the sub file containing the record to be searched with the value of the item as a key, and the main file read for reading the record from the main file and storing it in the input / output buffer Means for determining a sub-file and a key value for searching the sub-file based on the content of the record read by the main file reading means and the content of the assignment information file, and using the determined key value Then, the record is read from the determined sub-file and stored in the input / output buffer. Batch reading related records, comprising: sub-file reading means for reading, and notification means for collectively storing the records of the main file and the records of the sub-file read into the input / output buffer in the work area of the user program. method. 3. The related record batch read command control unit identifies whether the record read command issued from the user program to the main file is a related record batch read command or a normal read command by a command parameter. In the case of a normal read command, the main file reading means reads the record from the main file and stores it in the input / output buffer, and the notifying means stores the stored record in the work area of the user program. The related record batch reading method according to claim 1 or 2.