# US 7,467,386 B2 · Parameter passing of data structures where API and corresponding stored procedure are different versions/releases

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 7,467,386 B2
- Document ID: US7467386B2
- Status: Granted
- Kind: B2
- Application number: 10/759,661
- Filed: 2004-01-16
- Published: 2005-07-21
- Granted: 2008-12-16
- Earliest claimed: 2004-01-16
- Assignees: International Business Machines Corporation
- Inventors: Edward Joseph Gallagher; Mang-Rong Ho
- Web page: https://patentgrep.com/patent/US7467386B2

## CPC

- G06F 9/54: Interprogram communication
- G06F 16/2443: {Stored procedures}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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

### Claim 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.

### Claim 2 (depends on 1)

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.

### Claim 3 (depends on 1)

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.

### Claim 4 (depends on 1)

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.

### Claim 5 (depends on 4)

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.

### Claim 6 (depends on 4)

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.

### Claim 7 (depends on 1)

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

### Claim 8 (depends on 7)

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.

### Claim 9 (depends on 8)

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.