Row Null Indicator in SQLJRA Remote Protocol
Original Publication Date: 1992-Dec-01
Included in the Prior Art Database: 2005-Mar-25
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.
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...