FDLIDLST structures for early descriptors

Several FDLIDLST structures retrieve objects that are described by Late Descriptors.

SQLCARD

The SQLCARD is described as a row, consisting of all elements of the nullable group SQLCAGRP. The SQLCAGRP contains three nonterminal SDAs, SQLSTATE, SQLCODE, and SQLERRPROC and the nullable group SQLCAXGRP, which itself contains 20 SDAs. The FDLIDLST to retrieve an SQLCARD:
  1. Parent FDLIDLST containing one entry with DRDA type (LIDENTTY) of X'54'. This is the parent and the value of LIDENTO1 is the offset to the child FDLIDLST.
  2. The child FDLIDLST contains four entries, one each for SQLCODE, SQLSTATE, SQLERRPROC, and SQLCAXGRP. The value of LIDENTTY for SQLCODE, SQLSTATE, and SQLERRPROC are DRDA data types (less than X'50'). The data must be retrieved exactly as defined by the LIDENT lengths and representation. The value of LIDENTTY for the fourth entry is X'52' and this is the DRDA type of SQLCAXGRP, an FDOCA group. Thus, the LIDENTO1 points to a third FDLIDLST structure.
  3. The SQLCAXGRP FDLIDLST structure contains 20 entries all of which are terminal nodes (SDAs). These entries describe the representations and lengths of the data, which is retrieved from the data stream.

SQLDARD

The content and structure of the SQLDARD depends on the DDM Levels of the AR and AT. If both AR and AT are both at DDM Level 6 and higher:

The SQLDARD is described as an open array, such that row 1 is an SQLCARD, row 2 is an SQLNUMROW, and rows 3 through (N+2) are SQLDAROW instances. The SQLDARD thus couples an SQLCA with an SQLDA. The number of SQLDAROW instances, N, is given by row 2, SQLNUMROW. This row contains the only element from the nonnullable SQLNUMGRP, an SDA of type Integer 2. The SQLDAROW consists of all elements of the nonnullable SQLDAGRP group. Because data retrieval is at the row level, the FDLIDLSTs required to retrieve the SQLDARD consist of one FDLIDLST to process the SQLCARD, one FDLIDLST to retrieve the SQLNUMROW and one FDLIDLST to retrieve each of the N SQLDAROW instances.
  1. The FDLIDLST to retrieve an SQLCARD has been described previously as a parent FDLIDLST, child FDLIDLST containing three terminal SDAs, and one subordinate FDLIDLST describing the 20 terminal SDAs comprising the SQLCAXGRP
  2. The FDLIDLST to retrieve an SQLNUMROW contains a single entry, defining the terminal SDA of type integer 2.
  3. The FDLIDLST to retrieve an SQLDAROW contains 11 entries, each defining terminal SDAs, and one subordinate FDLIDLST describing the two terminal SDAs comprising the SQLUDTGRP. NOTE: the definitions of the terminal SDAs are dependent on the DDM levels of the AR and the AT. Check the DRDA reference for the contents at DDM Level 6.
The following information is true if either or both of the AR or AT has a DDM Level less than 6:
The SQLDARD is described as an open array, such that row 1 is an SQLCARD, row 2 is an SQLNUMROW, and rows 3 through (N+2) are SQLDAROW instances. The SQLDARD thus couples an SQLCA with an SQLDA. The number of SQLDAROW instances, N, is given by row 2, SQLNUMROW. This row contains the only element from the nonnullable SQLNUMGRP, an SDA of type Integer 2. The SQLDAROW consists of all elements of the nonnullable SQLDAGRP group. Because data retrieval is at the row level, the FDLIDLSTs required to retrieve the SQLDARD consist of one FDLIDLST to process the SQLCARD, one FDLIDLST to retrieve the SQLNUMROW and one FDLIDLST to retrieve each of the N SQLDAROW instances.
  1. The FDLIDLST to retrieve an SQLCARD is described as a parent FDLIDLST, child FDLIDLST containing three terminal SDAs, and one subordinate FDLIDLST describing the 20 terminal SDAs comprising the SQLCAXGRP.
  2. The FDLIDLST to retrieve an SQLNUMROW contains a single entry, defining the terminal SDA of type integer 2.
  3. The FDLIDLST to retrieve an SQLDAROW contains 11 entries, each defining terminal SDAs.

    NOTE: the definitions of the terminal SDAs are dependent on the DDM levels of the AR and the AT. Check the DRDA reference for the contents at DDM Level less than 6.

SQLSTT

The SQLSTT row consists of all occurrences of the SQLSTTGRP. The SQLSTTGRP is a nonnullable group that contains two SDAs: a variable SBCS character string and a variable Mixed character string. The FDLIDLST contains two entries, one each for the two SDAs and retrieval of the SQLSTT row must always retrieve both an SBCS variable character string and a Mixed variable character string. Only one of these strings can have a positive length.

SQLOBKNAM

The SQLOBKNAM row consists of all occurrences of the SQLOBJGRP. The SQLOBJGRP is a nonnullable group that contains two SDAs: a variable SBCS character string and a variable Mixed character string. The FDLIDLST contains two entries, one each for the two SDAs and retrieval of the SQLSTT row must always retrieve both an SBCS variable character string and a Mixed variable character string. Only one of these two strings can have a positive length.

SQLSTTVRB

The SQLSTTVRB is described as an open array, such that row 1 is an SQLNUMROW row and rows 2 through (N+1) are SQLVRBROW instances. The SQLNUMROW consists of the single element of the nonnullable SQLNUMGRP. The SQLVRBROW consists of the nine occurrences of the nonnullable SQLVRBGRP group.

  1. Because SQLNUMGRP is not nullable, the FDLIDLST structure to retrieve the SQLNUMROW contains a single LIDENT, defining a 2-byte integer, the contents of which is the number of SQLVRBROW instances.
  2. Since SQLVRBGRP is not nullable, the FDLIDLST structure to retrieve an SQLVRBROW instance contains nine terminal SDAs.

    NOTE: the definitions of the terminal SDAs are dependent on the DDM levels of the AR and the AT. Check the DRDA reference for the contents at DDM Level less than 6.