3. DRDA Changes
DRDA Volume 1 Revisions :
Chapter 1 The DRDA Specification
What it means to implement DRDA Level 6
Miscellaneous Added DRDA Types
The following additional DRDA types are supported as of SQLAM 8. Support for a new DRDA type
involves supporting two new early environment LIDs.
Boolean - support for new DRDA types (LIDs 'BE'X, and 'BF'X). A Boolean is a one-byte quantity with two legal distinguished values: the distinguished value 1 represents TRUE and the distinguished value 0 represents FALSE.
There is no compatible data conversion defined for Boolean when communicating with partners at
SQLAM 7 or lower. Attempts to send Boolean values to partners at SQLAM 7 or lower should fail.
Part Part1: Database Access Protocol
Chapter 2 Introduction to DRDA
No changes.
Chapter 3 Using DRDA - Overall Flows
No changes.
Chapter 4 The DRDA Processing Model and Command Flows
No changes.
Chapter 5 Data Definition and Exchange
5.6.5.43 Boolean
Meta Data (Environment-independent)
|
Length 0 |
Type 1 |
Identity 2 |
Class 3 |
MD Type 4 |
MD Ref Type 5 |
DRDA Type 6 |
|---|---|---|---|---|---|---|
|
7 |
X'78' |
0 |
X'05' |
X'01' |
X'02' |
X'BE' (BL) X'BF' (NBL) |
QTDSQL370 (System/370 Processors)
|
Length 0 |
SDA 1 |
LID 2 |
Type 3 |
Reserved 4 5 6 7 |
Reserved 8 |
Reserved 9 |
Fld Length 10 11 |
|
12 12 |
X'70' X'70' |
X'BE' X'BF' |
X'23' X'A3' |
0 0 |
0 0 |
0 0 |
1 1 |
QTDSQL400 (AS/400 Processors)
|
Length 0 |
SDA 1 |
LID 2 |
Type 3 |
Reserved 4 5 6 7 |
Reserved 8 |
Reserved 9 |
Fld Length 10 11 |
|
12 12 |
X'70' X'70' |
X'BE' X'BF' |
X'23' X'A3' |
0 0 |
0 0 |
0 0 |
1 1 |
QTDSQLX86 (Intel 80x86 Processors)
|
Length 0 |
SDA 1 |
LID 2 |
Type 3 |
Reserved 4 5 6 7 |
Reserved 8 |
Reserved 9 |
Fld Length 10 11 |
|
12 12 |
X'70' X'70' |
X'BE' X'BF' |
X'24' X'A4' |
0 0 |
0 0 |
0 0 |
1 1 |
QTDSQLASC (IEEE ASCII Processors)
|
Length 0 |
SDA 1 |
LID 2 |
Type 3 |
Reserved 4 5 6 7 |
Reserved 8 |
Reserved 9 |
Fld Length 10 11 |
|
12 12 |
X'70' X'70' |
X'BE' X'BF' |
X'23' X'A3' |
0 0 |
0 0 |
0 0 |
1 1 |
QTDSQLVAX (VAX Processors)
|
Length 0 |
SDA 1 |
LID 2 |
Type 3 |
Reserved 4 5 6 7 |
Reserved 8 |
Reserved 9 |
Fld Length 10 11 |
|
12 12 |
X'70' X'70' |
X'BE' X'BF' |
X'24' X'A4' |
0 0 |
0 0 |
0 0 |
1 1 |
Example Descriptor in Hex 07780005 0102BF
(QTDSQL370 nullable form) 0C70BFA3 00000000 00000001
Figure 5-52 DRDA Type X’06,07’ SQL Type 2436, 2437 BOOLEAN
FD:OCA Meta Data Summary
Update "Table 5-11 MDD References Used in Early Environmental Descriptors " to include new types
defined.
|
Application Class |
Meta Data Type |
Meta Data Reference DRDA-Type and Name |
SQL Data Type |
Description |
|---|---|---|---|---|
|
X'05' |
X'02' |
X'BE' (BL) |
2436 |
Boolean |
|
X'05' |
X'02' |
X'BF' (NBL) |
2437 |
Nullable Boolean |
Late Environmental Descriptors
Update "Table 5-20 Complete Set of Late Environmental Descriptors for QTDSQL 370" with new types
defined:
|
DRDA Type |
MDD Descriptor--HEX |
SDA, GDA, CPT, or RLO Descriptor--HEX |
|---|---|---|
|
BL |
07780005 0101BE |
0C70BE23 00000000 00000001 |
|
NBL |
07780005 0101BF |
0C70BFA3 00000000 00000001 |
Chapter 6, 7 Names and DRDA Rules
Conversion of Data Types (DC Rules )
DC3
<Add Boolean to the conversion table>
|
Source Type (X) |
Mapped Type (Y) |
Minimum SQLAM Level |
|---|---|---|
|
Boolean |
One-Byte Integer |
8 |
DC4
<Add Boolean to the conversion table>
|
Source Type (X) |
Mapped Type (Y) |
Minimum SQLAM Level |
|---|---|---|
|
Boolean |
One-Byte Integer |
8 |
Data Representation Transformation (DT Rules )
<Add a new data transformation rule>
DT22
An error with SQLState 56084 is raised when attempting to send Boolean data from a system which supports SQLAM Level 8 or higher to a system at Level 7 or lower.
Chapter 8 SQLSTATE Usage
No changes.
Part Part2: Environmental Support
Chapter 9 Enrironmental Support
No changes.
Chapter 10 Security
No changes.
Chapter 11 Problem Determination
No changes.
Chapter 12 Data Staging Area
No changes.
Part Part3: Network Protocols
Chapter 13 SNA
No changes.
Chapter 14 TCP/IP
No changes.
Appendix A: Building Statement-Level SQLCAs for Multi-Row Fetches
No changes.
Appendix B: DDM Managers, Commands, and Reply Messages
No changes.
______________________________________________________________________