Browse Prior Art Database

Row Null Indicator in SQLJRA Remote Protocol

IP.com Disclosure Number: IPCOM000110603D
Original Publication Date: 1992-Dec-01
Included in the Prior Art Database: 2005-Mar-25
Document File: 2 page(s) / 66K

Publishing Venue

IBM

Related People

Jordan, LE: AUTHOR [+4]

Abstract

Remote Data Service is a set of functions for OS/2* Extended Edition (EE) that allowed users to access databases not only on their local workstations but also on remote workstations. SQLJRA remote protocol (an application layer protocol) is designed to pass the database engine control structures from client to server and vice versa. The design of SQLJRA remote protocol takes advantage of the fact that the data structures built on the client or the server in a homogeneous environment are the same. Therefore, the underlying engine data structures are passed directly, without the conversion step being necessary. On the client, a data stream constructor will take the engine data structures as input and put data in the data structures into a data stream.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 52% of the total text.

Row Null Indicator in SQLJRA Remote Protocol

       Remote Data Service is a set of functions for OS/2*
Extended Edition (EE) that allowed users to access databases not only
on their local workstations but also on remote workstations.  SQLJRA
remote protocol (an application layer protocol) is designed to pass
the database engine control structures from client to server and vice
versa.  The design of SQLJRA remote protocol takes advantage of the
fact that the data structures built on the client or the server in a
homogeneous environment are the same.  Therefore, the underlying
engine data structures are passed directly, without the conversion
step being necessary.  On the client, a data stream constructor will
take the engine data structures as input and put data in the data
structures into a data stream.  If the data structure contains
pointers, the actual data pointed to by those pointers will be put
into the data stream.  The data structure reconstructor on the server
builds the engine data structures back according to the data string
received from the requester.  The reconstructed engine data
structures will be sent to the engine for processing.  The results
will be sent back to the client.

      One of the results sent back to the client is the output data.
This article presents a feature in SQLJRA remote protocol so that the
client can know whether the server has sent over any output data.

      Database Manager (DBM) defines a two-byte Row Null Indicator in
the data stre...