US 7,322,022 B2 | ||
Method for creating wrapper XML stored procedure | ||
Abdul Al-Azzawe, Pleasant Hill, Calif. (US); and Steffen Siegmund, San Jose, Calif. (US) | ||
Assigned to International Business Machines Corporation, Armonk, N.Y. (US) | ||
Filed on Sep. 05, 2002, as Appl. No. 10/236,890. | ||
Prior Publication US 2004/0049736 A1, Mar. 11, 2004 | ||
Int. Cl. G06F 9/44 (2006.01); G06F 9/45 (2006.01) |
U.S. Cl. 717—106 [717/117; 717/118; 715/513; 707/102] | 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.
|