Parameter passing of data structures where API and corresponding stored procedure are different versions/releases

• US 7,467,386 B2
• Filed: 01/16/2004
• Issued: 12/16/2008
• Est. Priority Date: 01/16/2004
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ho, Mang-Rong, Gallagher, Edward Joseph
• Primary Examiner(s): An; Meng-Ai
• Assistant Examiner(s): Cao; Diem K
• Application Number:
  US10/759,661
• Publication Number:
  US 20050160432A1
• Time in Patent Office: 1,796 Days
• Field of Search: 719313-320, 719328-332
• US Class Current: 719/313
• CPC Class Codes: G06F 16/2443 Stored procedures
• CPC Class Codes: G06F 9/54 Interprogram communication

Abstract

A method for passing parameters of data structures where an API and corresponding stored procedures are at different version/release levels is provided. A received data structure is parsed for a version identifier of a caller. The parsed version identifier is compared to a stored procedure version identifier and a determination is made with regards to a data structure compatibility or a data structure incompatibility. If a data structure compatibility is determined, all received data structure elements are parsed. If, however, a data structure incompatibility is determined, only data structure elements known to both the caller and the stored procedures are parsed.

Claims

1. A method of parameter passing of data structures where an API and corresponding stored procedures are of version/release levels different from one another, the method comprising:

receiving from a calling program, a data structure having data structure elements used for communicating data between the stored procedures and the calling program;

parsing the data structure for a first version identifier of the data structure;

comparing the first version identifier of the parsed data structure to a second version identifier of the stored procedures, obtaining version control information from a library, and thereafter parsing data structure elements in accordance to an indication of data structure compatibility, wherein;

when the comparing of the first version identifier with the second version identifier indicates compatibility of a data structure between the calling program and the stored procedures, providing parsing all of the data structure elements of the data structure known to both of said calling program and said stored procedures; and

, when the comparing of the first version identifier with the second version identifier indicates incompatibility of a data structure between the calling program and the stored procedures, providing parsing of only data structure elements of the data structure that are known to either of the calling program or the stored procedures.

2. The method as set forth in claim 1, wherein the indication of a data structure compatibility results in a value of false between the calling program and the stored procedures when the first version identifier is absent.

3. The method as set forth in claim 1, wherein the indication of a data structure compatibility results in a value of true between the calling program and the stored procedures when the first version identifier matches the second version identifier.

4. The method as set forth in claim 1, wherein the indication of a data structure compatibility results in a value of false between the calling program and the stored procedures when the first version identifier is determined to be at least one of:

less than the second version identifier;

absent; and

greater than the second version identifier.

5. The method as set forth in claim 4, wherein the parsing of only the data structure elements of the data structure that are known to both of the calling program and the stored procedures includes:

parsing only the data structure elements of the data structure that are known to the calling program when the first version identifier is less than the second version identifier.

6. The method as set forth in claim 4, wherein the parsing of only the data structure elements of the data structure that are known to both of the calling program and the stored procedures includes:

parsing only the data structure elements of the data structure that are known to the stored procedures when the first version identifier is greater than the second version identifier.

7. The method as set forth in claim 1, wherein the data structure includes a BLOB/CLOB pair.

8. The method as set forth in claim 7, wherein:

the step of receiving the data structure including the BLOB/CLOB pair includes;

receiving a CLOB having at least one character data value; and

receiving a BLOB having a version identifier, a data element ID for each respective character data value, a data type for each respective character data value, and a data length for each respective character data value.

9. The method as set forth in claim 8, wherein the library further includes a library system control table, and the indication is based on the version control information obtained from the library system control table.