JPH07319662A - System for data format conversion between different kinds of machines - Google Patents

Abstract

PURPOSE:To perform the code conversion and record format conversion of a file on a general purpose machine. CONSTITUTION:An updated record extracting means 111 extracts updated records from a data base 12 to an updated record file 13 and a file transfer means 112 sends the updated record file 13. A file transfer means 211 receives the updated record file 22, a code converting means 212 performs the code conversion of the records in the updated record file 22 by referring to a 1-byte code conversion master file 23 and a 2-byte code conversion master file 24 and outputs the result to a code-converted record file 25, and a record format converting means 213 converts the record format of the code-converted records and outputs them to a format-converted record file 26. A data base update means 214 updates the records in a data base 27 on the basis of the format- converted record.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data format conversion method between different machine types, and more particularly to a data format conversion method between different machine types that performs file code conversion and record format conversion.

[0002]

2. Description of the Related Art Conventionally, in a computer system in which a UNIX machine and a general-purpose machine are connected via a communication line, when a data file is transferred from the UNIX machine to the general-purpose machine, the UNIX machine and the general-purpose machine are connected to each other. Since the code system is different, the code is converted on the UNIX machine and then the file is transferred to the general-purpose machine, and the file is converted to the desired record format by the application program specially created for the record format conversion on each file on the general-purpose machine. Was there.

As a conventional technique, OSI (Open)
System Interconnection) An office document format conversion method for converting a standard office document into a host format office document (see Japanese Patent Laid-Open No. 3-282657).
Is known, but it was specialized for office documents and could not be used universally.

[0004]

In the above-mentioned conventional data format conversion method, it is necessary to create an application program for converting the record format for each file, which requires a lot of man-hours for creating the application program. was there.

Further, since each UNIX machine had to have a master file for code conversion, the UN machine
There is a problem that the file structure of the IX machine becomes complicated.

SUMMARY OF THE INVENTION In view of the above points, an object of the present invention is to provide a data format conversion system between different types of machines, which is adapted to perform file code conversion and record format conversion on a general-purpose machine.

[0007]

According to another aspect of the present invention, there is provided a data format conversion method between different machine types in a computer system in which a machine of a certain model and a machine of another model are connected via a communication line. A machine of a model inputs a file transferred from a machine of a certain model and performs a code conversion, and a record format conversion that converts the record format of the file converted by this code conversion into a general-purpose And means.

[0008]

The present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of a computer system to which a data format conversion method between different types of machines according to an embodiment of the present invention is applied. This computer system is configured by connecting a UNIX machine 1 and a general-purpose machine 2 via a communication line 3.

The UNIX machine 1 comprises an update record extraction utility 11, a database 12 and an update record file 13, and the update record extraction utility 11 has an update record extraction means 1
11 and a file transfer means 112.

The general-purpose machine 2 includes a database update utility 21, an update record file 22, a 1-byte code conversion master file 23, a 2-byte code conversion master file 24, a code-converted record file 25, and a format-converted record. The file update utility 21 includes a file 26 and a database 27.
Code conversion means 212 and record format conversion means 213
And database updating means 214.

Referring to FIG. 2, the processing of the update record extraction means 111 is performed by a database / update record file open step S101, an update record extraction step S102, an end determination step S103, a shift code addition step S104, and a database / update record extraction step S102. The update record file closing step S105.

Referring to FIG. 3, the file transfer means 11
The second process includes an operation environment setting step S201, a line open step S202, a general-purpose machine check step S203, a file transmission step S204, a response reception step S205, and a line close step S206.

Referring to FIG. 4, the file transfer means 21
The processing of No. 1 is the operation environment setting step S301, the line opening step S302, and the file receiving step S3.
03, a response transmission step S304, and a line close step S305.

Referring to FIG. 5, code conversion means 212
The process is performed by the file open step S401, the 1-byte input step S402, and the end determination step S40.
3, shift start code determination step S404, shift flag on step S405, shift end code determination step S406, shift flag off step S4.
07, shift flag determination step S408, 1-byte code conversion step S409, 1-byte input step S410, 2-byte code conversion step S411
And a conversion code output step S412.

Referring to FIG. 6, the process of the record format conversion means 213 is a file open step S501.
1 record input step S502, end determination step S503, delimiter count step S504
And an input record number / output record item number comparison step S505, an output record editing step S506, and an output record writing step S507.

Referring to FIG. 7, in the 1-byte code conversion master file 23, 1-byte UNIX code and general-purpose machine code are registered in association with each other.

Referring to FIG. 8, in the 2-byte code conversion master file 24, 2-byte UNIX code and general-purpose machine code are registered in association with each other.

Next, the operation of the data format conversion system between different types of machines according to the present embodiment configured as described above will be described.

In the daytime business, the UNIX machine 1 performs maintenance of the database 12 by itself in order to reduce the load on the general-purpose machine 2. The database 12 handled here is a file that requires daily maintenance (such as price change and addition of new products at a later date) like a product master file. On the other hand, on the general-purpose machine 2, the database 27 is used as a normal task.

After the daytime work ends, the update record extraction utility 11 is started on the UNIX machine 1.

Then, first, the update record extraction means 111
Is the database 12 and the update record file 13
Is opened (step S101), and, for example, as shown in FIG. 9, an update record is extracted from the database 12 with an arbitrary item such as an update date (step S102). If there is an update record (NO in step S103), the update record extracting unit 111, as shown in FIG.
A 1-byte shift start code "!" And a shift end code "?" Are added before and after the byte data item (step S104), and the control is returned to step S102. When the update records are exhausted in step S103, the update record extracting means 111 closes the database 12 and the update record file 13 (step S105).

FIG. 9 is a diagram for explaining an example of update record extraction processing by the update record extraction means 111. Records 1 to 3 are stored in the database 12, and the update date is set to "9" by the update record extracting means 111.
When the update record is extracted with 30824 ", two update records are extracted, and the shift start code"! "Is added before and after the 2-byte data item in the update record. And shift end code "? "Is added.

Next, the file transfer means 112 sets the operating environment (step S201), opens the line (step S202), and checks the operating state of the general-purpose machine 2 (step S203). When the operation state of the general-purpose machine 2 is checked, the file transfer means 112
The update record file 13 is transmitted to the general-purpose machine 2 via the communication line 3 (step S204), and when a response is received from the general-purpose machine 2 (step S205), the line is closed (step S206).

On the other hand, in the database update utility 21 on the general-purpose machine 2, the file transfer means 211 is
The operating environment is set (step S301), the line is opened (step S302), the update record file 13 transmitted from the UNIX machine 1 is received as the update record file 22 (step S303), and the response is sent through the communication line 3 It transmits to UNIX machine 1 via (step S304), and a line is closed (step S305).

Next, the code converting means 212 includes the update record file 22 and the code converted record file 2
The 5, 1-byte code conversion master file 23 and the 2-byte code conversion master file 24 are opened (step S401), and data is input from the update record file 22 in 1-byte units (step S402). Next, the code conversion means 212 uses the update record file 2
It is determined whether or not 2 is the end (step S403), and if not, it is determined whether or not the shift start code is "!" (Step S404). If the shift start code is "!", The code converting means 212 turns on the shift flag (step S405) and returns the control to step S402. If it is not the shift start code "!", The code conversion means 212 determines whether it is the shift end code "?" (Step S406), and the shift end code "?".
If so, the shift flag is turned off (step S40
7), control is returned to step S402.

If the shift end code is not "?" In step S406, the code converting means 212 determines whether the shift flag is on or off (step S408). If it is off, the 1-byte code conversion master file 23 is stored. The 1-byte code conversion is performed by referring to (step S40).
9). If the shift flag is on, the code conversion means 2
12 further inputs 1 byte from the update record file 22 (step S410) and refers to the 2-byte code conversion master file 24 to perform 2-byte code conversion (step S411). Next, the code conversion means 212
Outputs the conversion code to the code-converted record file 25 (step S412), and returns the control to step S402. Then, when the update record file 22 is finished in step S403, the code converting means 212 finishes the process.

Subsequently, the record format conversion means 213
The code converted record file 25 and the format converted record file 26 are opened (step S50).
1), one record is input from the code-converted record file 25 (step S502), and it is determined whether or not it is completed (step S503). If the code-converted record file 25 is not completed, the record format conversion means 21
3 divides the input record into 1-byte units, counts the number of delimiters “,” (step S504), and determines whether the input record number + 1 matches the output record item number (step S505). Number of input records +
If 1 is equal to the number of output record items, the record format conversion means 213 edits the output record as shown in FIG. 10 (step S506) and writes it in the format converted record file 26 (step S50).
7) The control is returned to step S502. Step S50
If the number of input records + 1 does not match the number of output record items in 5, the record format conversion means 213 aborts. When the process is finished in step S503, the record format conversion means 213 finishes the process.

FIG. 10 is a diagram for explaining an example of record format conversion processing by the record format conversion means 213.
The output record definition is 9 (5), X (5), N (4),
9 (6) 4 items, input record is 100, ABC,
!! Yamada? , 930824 and 70, CCC ,! Saito? ，
In the case of 930824, since the number of delimiters “,” is 3 and the number of output record items is 4, the number of input records + 1 is equal to the number of output record items. Therefore, the record format conversion means 213 edits the output record,
The output record is written to the format-converted record file 26.

Finally, the database updating means 214 is
The format-converted update record is read from the format-converted record file 26 and the database 27 is updated.

In the above embodiment, the present invention is applied to UNIX.
The case where the machine and the general-purpose machine are applied to the computer system connected via the communication line has been described, but the present invention is not limited to the computer system in which the machines having different code systems are connected via the communication line. It goes without saying that the same can be applied.

[0032]

As described above, according to the present invention, code conversion and record format conversion can be performed as a series of operations on a general-purpose machine, so that data conversion processing of files can be collectively performed and operation of a computer system can be performed. There is an effect that it becomes easy and there is no need to create one application program for one record format, which reduces the number of preparation steps.

Further, since it is not necessary to have a master file for code conversion for each UNIX machine, there is an effect that the file structure on the UNIX machine can be simplified.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a computer system to which a data format conversion method between different types of machines according to an embodiment of the present invention is applied.

FIG. 2 is a flow chart showing a process of an update record extracting means in FIG.

FIG. 3 is a flowchart showing a process of a file transfer means in FIG.

FIG. 4 is a flowchart showing the processing of the file transfer means in FIG.

5 is a flowchart showing the processing of the code converting means in FIG. 1. FIG.

FIG. 6 is a flow chart showing a process of a record format conversion means in FIG.

7 is a diagram showing an example of the contents of a 1-byte code conversion master file in FIG.

FIG. 8 is a diagram showing an example of the contents of a 2-byte code conversion master file in FIG.

9 is a diagram illustrating an example of update record extraction processing by update record extraction means in FIG.

10 is a diagram illustrating an example of record format conversion processing by the record format conversion means in FIG.

[Explanation of symbols]

 1 UNIX machine 2 General-purpose machine 11 Update record extraction utility 12 Database 13 Update record file 21 Database update utility 22 Update record file 23 1 byte code conversion master file 24 2 byte code conversion machine file 25 Code converted record file 26 Format converted record File 27 Database 111 Update record extraction means 112 File transfer means 211 File transfer means 212 Code conversion means 213 Record format conversion means 214 Database update means

Claims (2)

[Claims] 1. In a computer system in which a machine of a certain model and a machine of another model are connected via a communication line, the machine of the other model stores files transferred from the machine of the certain model. Data format conversion method between different types of machines characterized by having a code conversion means for inputting and converting the code and a record format conversion means for generally converting the record format of the file code-converted by the code conversion means. . 2. The machine of one model is a UNIX machine, and the machine of the other model is a general-purpose machine.
Data format conversion method between different machines described.