Method and computer program product for implementing translatable text in user modifiable SQL scripts

• US 6,374,239 B1
• Filed: 02/09/1999
• Issued: 04/16/2002
• Est. Priority Date: 02/09/1999
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Pfeifer, Michael Donald, Johnson, Peter John, Baldes, David Allan, Anderson, Mark John
• Primary Examiner(s): Choules, Jack M.
• Assistant Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US09/248,526
• Time in Patent Office: 1,162 Days
• Field of Search: 707/4, 707/2, 707/3, 707/5, 707/203, 709/106, 709/201
• US Class Current: 707/760
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 9/454 Multi-language systems; Localisation; Internationalisation
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

A method and computer program product are provided for implementing translatable text in user modifiable standard query language (SQL) scripts. A set of multiple queries are generated including comments and associated delimited names. The comments and associated delimited names are translated into multiple language versions. A user selected national language is identified. The user selected national language version of the translated comments and associated delimited names are utilized for generating a query. In accordance with features of the invention, the user is given the option to view the query and to make any desired modifications.

Claims

1. A method for implementing translatable text in user modifiable standard query language (SQL) scripts in a computer system comprising the steps of:

providing a set of multiple queries;

said set of multiple queries including comments and associated delimited names;

translating said comments and associated delimited names into multiple language versions;

storing said translated comments and associated delimited names separately from each select statement defining said set of multiple queries;

identifying a user selected national language;

receiving a user selected option that maps to said set of multiple queries or selects an option to dynamically generate a select statement for generating a query;

retrieving said translated comments and associated delimited names in said identified user selected national language;

merging said retrieved translated comments and associated delimited names with each said select statement defining said set of multiple queries or said select statement for defining said query; and

utilizing said query with said user selected national language of said translated comments and associated delimited name.

2. The method for implementing translatable text in user modifiable standard query language (SQL) scripts as recited in claim 1 includes the steps of identifying a user selection to modify said query and presenting said merged select statement to the user.

3. The method for implementing translatable text in user modifiable standard query language (SQL) scripts as recited in claim 2 includes the steps of receiving user selected modifications to said merged select statement.

4. A computer program product for implementing translatable text in user modifiable standard query language (SQL) scripts in a computer system comprising:

a recording medium;

means, recorded on the recording medium, for providing a set of multiple queries;

said set of multiple queries including comments and associated delimited names;

means, recorded on the recording medium, for translating said comments and associated delimited names into multiple language versions;

means, recorded on the recording medium, for storing said translated comments and associated delimited names separately from each statement defining said set of multiple queries;

means, recorded on the recording medium, for identifying a user selected national language;

means, recorded on the recording medium, for receiving a user selected option that maps to said set of multiple queries or selects an option to dynamically generate a select statement for generating a query;

means, recorded on the recording medium, for retrieving comments and associated delimited names in said user selected national language and for merging said retrieved comments and associated delimited names with said statement defining said query; and

means, recorded on the recording medium, for utilizing said query with said user selected national language of said translated comments and associated delimited names.

5. A computer program product as recited in claim 4 includes means, recorded on the recording medium, for identifying a user selection to modify said query and for presenting said merged select statement to the user.

6. A computer program product as recited in claim 5 includes said means, recorded on the recording medium, for receiving user selected modifications to said merged select statement.

7. A computer system comprising:

a processor,

a memory coupled to the processor for storing a computer program product for implementing translatable text in user modifiable standard query language (SQL) scripts;

said computer program product including a plurality of computer executable instructions stored on a computer readable medium, wherein said instructions, when executed by said computer, cause the computer to perform the steps of;

providing a set of multiple queries, each including comments and associated delimited names;

translating said comments and associated delimited names into multiple language versions;

storing said translated comments and associated delimited names separately from each statement defining said set of multiple queries;

identifying a user selected national language;

receiving a user selected option that maps to said set of multiple queries or selects an option to dynamically generate a select statement;

retrieving said translated comments and associated delimited names in said identified user selected national language;

merging said retrieved translated comments and associated delimited names with each said statement defining said set of multiple queries or said select statement for generating a query; and

utilizing said generated query with said user selected national language of said translated comments and associated delimited names.