SYSTEM, COMPUTER PROGRAM PRODUCT AND METHOD OF SIMPLIFYING COMMANDS FOR RETRIEVING DATA FROM A DATABASE SYSTEM WITHOUT LEADING AND TRAILING SPACE CHARACTERS

• US 20070282820A1
• Filed: 05/31/2006
• Published: 12/06/2007
• Est. Priority Date: 05/31/2006
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: HU, TENG, DINH, HUNG T., PHAM, PHONG A.
• Application Number:
  US11/421,123
• Publication Number:
  US 20070282820A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2445 Data retrieval commands; View definitions
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

A system, computer program product and computer Implemented method of simplifying commands for retrieving data from a database system without leading and trailing space characters are provided. The system, computer program product and computer Implemented method allow a user to use only one function to remove any leading and/or trailing space characters that a piece of data may include before the piece of data is presented to the user.

Claims

1. A computer implemented method of simplifying commands for retrieving data from a database system without leading and trailing space characters comprising the steps of:

enabling a user to use a command to retrieve data from the database system, the command being simplified by using only one instance of a function, the function for removing leading and trailing space characters from the data being retrieved; and

enabling the user to send the command to the database system to retrieve the data.

2. The computer implemented method of claim 1 wherein the one instance of the function is used to remove leading and trailing space characters from all parts of the data when the data is made of a plurality of parts.

3. The computer implemented method of claim 2 wherein the leading and trailing space characters are removed from data defined as characters.

4. The computer implemented method of claim 3 wherein the function is a TRIMALL function.

5. The computer implemented method of claim 4 wherein the TRIMALL function operates on every parameter of the command associated with character data.

6. The computer implemented method of claim 5 wherein the function, as a parameter of the command, is placed after the command and before all other parameters of the command.

7. A computer program product on a computer usable medium for simplifying commands for retrieving data from a database system without leading and trailing space characters comprising:

code means for enabling a user to use a command to retrieve data from the database system, the command being simplified by using only one instance of a function, the function for removing leading and trailing space characters from the data being retrieved; and

code means for enabling the user to send the command to the database system to retrieve the data.

8. The computer program product of claim 7 wherein the one instance of the function is used to remove leading and trailing space characters from all parts of the data when the data is made of a plurality of parts.

9. The computer program product of claim 8 wherein the leading and trailing space characters are removed from data defined as characters.

10. The computer program product of claim 9 wherein the function is a TRIMALL function.

11. The computer program product of claim 10 wherein the TRIMALL function operates on every parameter of the command associated with character data.

12. The computer program product of claim 11 wherein the function, as a parameter of the command, is placed after the command and before all other parameters of the command.

13. A computer system for simplifying commands for retrieving data from a database system without leading and trailing space characters comprising:

at least one storage system for storing code data; and

at least one processor for processing the code data to enable a user to use a command to retrieve data from the database system, the command being simplified by using only one instance of a function, the function for removing leading and trailing space characters from the data being retrieved, and to further enable the user to send the command to the database system to retrieve the data.

14. The computer system of claim 13 wherein the one instance of the function is used to remove leading and trailing space characters from all parts of the data when the data is made of a plurality of parts.

15. The computer system of claim 14 wherein the leading and trailing space characters are removed from data defined as characters.

16. The computer system of claim 15 wherein the function is a TRIMALL function.

17. The computer system of claim 16 wherein the TRIMALL function operates on every parameter of the command associated with character data.

18. The computer system of claim 17 wherein the function, as a parameter of the command, is placed after the command and before all other parameters of the command.