Method for creating wrapper XML stored procedure
First Claim
1. A computer-implemented method for automatically generating code for converting data from stored procedures to an XML format, comprising the steps of:
- (a) providing a wizard for generating code for a wrapper method, wherein the wizard;
(a1) receives a selection of a stored procedure, wherein the wizard receives a selection of a stored procedure including;
(a1i) obtaining existing stored procedures base upon search criteria;
the search criteria comprising;
which database schemas to consider, what the stored procedure name may be, and what the stored procedure is;
(a2) determines an output data format for the selected stored procedure, and(a3) obtains a definition of an Extended Markup Language (XML) document, wherein the definition comprises which portions of the output data format to include in the XML document; and
(b) generating the code for the wrapper method by the wizard for calling the selected stored procedure and the selected stored procedure returns SQL data to the wrapper method, the wrapper method converts the returned SQL into the defined XML document.
4 Assignments
0 Petitions
Accused Products
Abstract
A method for automatically generating code for converting data from stored procedures to an XML format is performed by a wizard with which a client interfaces. The wizard receives a selection of a stored procedure, determines an output data format for the selected stored procedure, obtains a definition of an XML document which contains which portions of the output data format to include in the XML document, and generates code for a wrapper. The wrapper would call the stored procedure and generate the defined XML document. The XML document is then returned by the wrapper. In this manner, the code for converting data to the XML format need not be manually generated. The data also need not be manually converted to the XML format.
36 Citations
28 Claims
-
1. A computer-implemented method for automatically generating code for converting data from stored procedures to an XML format, comprising the steps of:
-
(a) providing a wizard for generating code for a wrapper method, wherein the wizard; (a1) receives a selection of a stored procedure, wherein the wizard receives a selection of a stored procedure including; (a1i) obtaining existing stored procedures base upon search criteria;
the search criteria comprising;
which database schemas to consider, what the stored procedure name may be, and what the stored procedure is;(a2) determines an output data format for the selected stored procedure, and (a3) obtains a definition of an Extended Markup Language (XML) document, wherein the definition comprises which portions of the output data format to include in the XML document; and (b) generating the code for the wrapper method by the wizard for calling the selected stored procedure and the selected stored procedure returns SQL data to the wrapper method, the wrapper method converts the returned SQL into the defined XML document. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. A computer readable medium with program instructions tangibly stored thereon, the program instructions for automatically generating code for converting data from stored procedures to an XML format, the program instructions comprising instructions for:
-
(a) providing a wizard for generating code for a wrapper method, wherein the wizard; (a1) receives a selection of a stored procedure, wherein the wizard receives a selection of a stored procedure including; (a1i) obtaining existing stored procedures base upon search criteria;
the search criteria comprising;
which database schemas to consider, what the stored procedure name may be, and what the stored procedure is;(a2) determines an output data format for the selected stored procedure, and (a3) obtains a definition of an Extended Markup Language (XML) document, wherein the definition comprises which portions of the output data format to include in the XML document; and (b) generating the code for the wrapper method by the wizard for calling the selected stored procedure and the selected stored procedure returns SQL data to the wrapper method, the wrapper method converts the returned SQL into the defined XML document. - View Dependent Claims (16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28)
-
Specification