Abstract: A method and system for efficient allocation of memory in database retrieval employs a technique which allocates a memory portion of a first size which may or may not be smaller than a data item to be retrieved from the database (such as a column which may be of indeterminate length). In that circumstance, a first FETCH, for example, an SQL FETCH, is followed by a new syntactical instruction, a FETCH CONTINUE, until all of the data item is retrieved. The FETCH CONTINUE may involve allocating memory portions of similar or different sizes to accommodate additional fetched portions, and may involve varying numbers of fetches.

Abstract: A method and system for efficient allocation of memory in database retrieval employs a technique which allocates a memory portion of a first size which may or may not be smaller than a data item to be retrieved from the database (such as a column which may be of indeterminate length). In that circumstance, a first FETCH, for example, an SQL FETCH, is followed by a new syntactical instruction, a FETCH CONTINUE, until all of the data item is retrieved. The FETCH CONTINUE may involve allocating memory portions of similar or different sizes to accommodate additional fetched portions, and may involve varying numbers of fetches.

Abstract: The present invention discloses a method, apparatus, and article of manufacture for transmitting data having non-standard data types between computers. A query is executed to retrieve data from a database. The database comprises data having standard data types and data having non-standard data types and is stored on a data storage device connected to a server computer. At the server computer, data having standard data types, small non-standard data types, and large non-standard data types is retrieved. An answer set is generated that comprises data having standard data types, small non-standard data types, and one or more placeholders representing data having the large non-standard data types. The generated answer set is transmitted to a client computer. After transmitting the generated answer set, data represented by each placeholder in the answer set is transmitted to the client computer.

Abstract: The present invention discloses a method, apparatus, and article of manufacture for transmitting data having non-standard data types between computers. A query is executed to retrieve data from a database. The database comprises data having standard data types and data having non-standard data types and is stored on a data storage device connected to a server computer. At the server computer, data having standard data types, small non-standard data types, and large non-standard data types is retrieved. An answer set is generated that comprises data having standard data types, small non-standard data types, and one or more placeholders representing data having the large non-standard data types. The generated answer set is transmitted to a client computer. After transmitting the generated answer set, data represented by each placeholder in the answer set is transmitted to the client computer.

Abstract: The present invention discloses a method, apparatus, and article of manufacture for transmitting data having non-standard data types between computers. A query is executed to retrieve data from a database. The database comprises data having standard data types and data having non-standard data types and is stored on a data storage device connected to a server computer. At the server computer, data having standard and non-standard data types is retrieved. An answer set is generated that comprises data having standard data types and one or more placeholders, wherein each placeholder represents data having a non-standard data type. The generated answer set is transmitted to a client computer. After transmitting the generated answer set, data represented by each placeholder in the answer set is transmitted to the client computer.