JPH0371328A - Sort key information definition processing method - Google Patents

Abstract

(57) [Summary] This bulletin contains application data before electronic filing, so abstract data is not recorded.

Description

[Detailed Description of the Invention] [Field of Industrial Application] The present invention relates to a sort key information definition processing method, and in particular,
The present invention relates to a sort key information definition processing method that can simplify the work of defining sort key information when using a sort program when performing sort processing on a database.

[Conventional technology]

To perform sort processing on the database,
Sort key information must be defined in advance so that sorting can be performed according to desired sorting conditions using a sorting program. Figures 3 and 4 outline the sorting process and sort key information definition work. Explain with reference to.

FIG. 3 is a block diagram schematically showing the equipment configuration of a data processing system that performs sort key information definition processing and sorting processing, and FIG. 4 is a flowchart showing processing of sort key information definition work.

In FIG. 3, 30 is a data processing device, 31 is a terminal device, and 32 is a file device. The data processing device 30 is equipped with a sort processing program 33 and an editor 34. Also, in the file device 32.

Contains files for data processing. Here, as shown in FIG. 3, sorting processing is performed.

As a file related to the sort key information definition process, there is a sort target file 35. Sort key information definition file 3
6. A sort result file 37 is provided. In such data processing systems.

For example, the sorting process is performed on the sorting target file 35 by the sorting process program 33 using the sorting key information from the sorting key information definition file 36. The sorting results after the sorting process are stored in the sorting result file 37.
is stored in

In this case, the user of the sorting process performs the sort key information definition process in advance and stores the sort key information in the sort key information definition file 36. 31
This is done by inputting sort key information such as key position, length, and attributes.

Next, the procedure for inputting key information using an editor will be explained with reference to FIG. do. After finding a corresponding field through the search, in the next step 42, the position, length, attributes, etc. of that field are input from the editor screen.

[Problem to be solved by the invention]

In this way, when performing sorting processing, sort key information definition processing is performed. In this case, there is a problem in that the following points are not considered, and the burden on the sorting user to perform the sorting process is heavy. That is, (1) the user must define all the key information such as key position, key length, key priority, etc. for each job, which requires a large amount of work to define sort key information.

(2) Users manually input definitions by referring to record specifications, etc., resulting in many input errors.

The present invention has been made to solve the above problems.

SUMMARY OF THE INVENTION An object of the present invention is to provide a sort key information definition processing method that reduces the work of sort key information definition processing performed when performing sort processing on sort targets.

The above and other objects and novel features of the present invention will become apparent from the description of this specification and the accompanying drawings.

[Means to solve the problem]

In order to achieve the above object, the present invention provides a sort key information definition processing method for defining sort key information for performing sort processing on sort target files, which includes sort target files existing in a relational database dictionary. The present invention is characterized by comprising key information definition processing means for displaying field definition information on a screen and defining sort key information such as the position, length, and attributes of the sort key from an instruction on the screen of a field to be used as a sort key.

[Effect]

According to the means, the key information definition processing means is provided in order to easily define the sort key information for executing the sorting process. This key information definition processing means displays the field definition information of the files to be sorted that exists in the relational database dictionary on the screen, and determines the position, length, and attributes of the sort key from the instructions of the field that should be the sort key on one screen. Define sort key information.

That is, the field definition information in the WI database dictionary is used and quoted in the definition of the sort key information. This field definition information includes field position, length, and attribute information, and this information is used to define sort key information.In sort key definition work, field definitions displayed on one screen are used. The user selects a field name from the information on one screen.

As a result, the position, length, and attribute of the field are specified as a set by the selected field name. Therefore, sort key information can be defined simply by specifying a field name, reducing the work of defining sort key information.Specification (Embodiment) An embodiment of the present invention will be specifically described below with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of main parts of a processing system that executes sort key information definition processing according to an embodiment of the present invention.

In FIG. 1, 1 is a terminal device, 2 is a central processing unit, and 3 is a terminal device.
is a disk device. The terminal device 1 displays output data from the central processing unit 2 on a screen to the operator,
An input request message is displayed on the screen for the operator and input is accepted, and input of arbitrary commands and the like from the operator is accepted and provided to the central processing unit 2. Central processing unit 2
is a program that performs, for example, data input/output processing, sorting processing, sort key information definition processing, etc.

It is equipped with a processing control unit and performs various data processing.

The disk unit w3 is used as an external storage device, and various files for data processing are stored here.For example, as shown in the figure, files 15. Sort key definition information storage file 16, sort target file 17. Files such as are stored. The RDB dictionary file 15 is provided with a plurality of field definition information 15a and a file index 15b for managing the field definition information 15a as RDB dictionary information. The field definition information 15a is managed by being pointed to by a pointer from the file index 15b.

Additionally, in the block diagram of the first engineering drawing, as a processing block that executes the sort key information definition processing according to this embodiment,
Each processing block provided in the central processing unit 2 is illustrated. In other words, sort target file Meijinrikibu 1
1. RDB dictionary search unit 12. These are each processing block of a key information definition screen display input section 13° and a sort key information output section 14.

21st! 1 is a diagram illustrating a data structure used in sort key information definition processing. In Figure 2, in the case of RD, the display screen information of the key information definition screen displayed on the display screen of the terminal device, the relationship with field definition information, and the relationship with the sort key information storage file as a result of defining the sort key information. It shows.

Next, the operation of sort key information definition processing will be described with reference to FIGS. 1 and 2.

The operator creates sort key information from the terminal device t,
When a command (EDIT SMD) instructing to update sort key information or the like in an interactive manner is input, a program for executing sort key information definition processing is started.

When this program is started, the sort target file name human power unit 11 displays a function selection screen on the terminal device 1 that prompts the operator to input the name of the file to be sorted and the name of the file storing sort key information. In response, the operator inputs the name of the file to be sorted and the name of the sort key information storage file. For example, the operator inputs rGOODsJ as the file name to be sorted, and rGOODsKEYJ as the name of the sort key information storage file.

When the sort target file name and the sort key information storage file name are input, the RDB dictionary search unit 1
2 uses the file name (GOODS) as a key and RDB
Search for the same file name as rGOODsJ from the file index 15b in the dictionary 15, follow the pointer, and search for the field definition information 1 of the file name.
5a into memory.

As shown in FIG. 2, the field definition information read into the memory stores the position, length, and other attribute information for each field name.

Attribute information such as length is displayed on the display screen of the terminal device 1. This process is performed by the key information definition screen display input section 13.

In this way, the key information definition screen display input section 13 allows
Among the field definition information 15a, information necessary for key information definition (position, length, etc.) is displayed on the terminal device l as a key information definition screen 21. At this time, a message ``Please specify the priority order and arrangement of keys'' is displayed on the display screen, prompting the user to select and input a field that will serve as a sort key. On the other hand, the operator selects, for example, the product code as the first key and specifies the color as the second key, so he inputs roIJ and r02J in the respective priority columns. Moreover, furthermore,
At the same time, in order to instruct that both keys be sorted in ascending order, a parameter value rAOJ is entered in the "Order" column on the key information definition screen 21. As a result, the sort key information output unit 14 creates key information for the selected (priority input) field according to the selection input and parameter instructions, and stores the created key definition information in the sort key information storage file 16. Output.

As a result, the file with the file name rGOODsKEYJ of the sort key information storage file 16 has the following information:

As shown in FIG. 2, sort key information of field name 2 position and length is created from the field definition information 15a of the RDB dictionary file 15 and stored.

In this way, the field definition information for "product code" and "color" is rGOODs as sort key information.
Stored in KEYJ.

After defining the sort key information in this way.

In order to perform the sorting process using the defined sort key information,
The sort processing program (3) is executed by the command (SORT).
3; start up the software (Fig. 3) and execute the sorting process.

The present invention has been specifically explained above based on examples, but
It goes without saying that the present invention is not limited to the embodiments described above, and can be modified in various ways without departing from the spirit thereof.

〔Effect of the invention〕

As explained above, according to the sort key information definition processing method of the present invention, by quoting field definition information from the RDB dictionary, a series of sort key information can be defined simply by specifying the field name. In the definition work for sorting processing, it is no longer necessary to input the position, length, attributes, etc. of fields that serve as sort key information, so the work time for defining a sort key can be shortened. Furthermore, errors in the definition work of sort key information can be reduced.

[Brief explanation of drawings]

1 is a block diagram showing the main part configuration of a processing system that executes sort key information definition processing according to an embodiment of the present invention; FIG. 2 is a diagram illustrating a data structure used in sort key information definition processing; FIG. 3 is a block diagram showing an outline of the equipment configuration of a data processing system that performs sort key information definition processing and sorting processing, and FIG. 4 is a flowchart showing processing of sort key information definition work. 1.31...Terminal device, 2...Central processing unit, 3.
...Disk device, 15...RDB dictionary,
15a...Field definition information, 15b...File index, 16...Sort key information storage file, 17.35...Sort target file, 21...
Key information definition screen, 30... data processing device, 32.
...File device, 33...Sort processing program,
33... Editor, 36... Sort key information definition file, 37... Sort result file. 1 bamboo 2 parts

Claims (1)

[Claims] 1. A sort key information definition processing method that defines sort key information for executing sort processing on files to be sorted, which displays field definition information for files to be sorted that exists in a relational database dictionary on the screen, and A sort key information definition processing method comprising: a key information definition processing means for defining sort key information of the position, length, and attributes of a sort key based on the above instruction of a field to be used as a sort key.