SQLSTT command (X'2414')

The distributed data management (DDM) architecture SQL Statement Row Description (SQLSTT) command contains one SQL statement.

Format

Parameters

DSSHDR

The 6-byte header field containing information about the DSS.

LL

A 2-byte field that has the length of the SQLSTT command.

CP(X'2414')

The 2-byte codepoint of the SQLSTT command.

SQLSTTGRP

SQL Statement Group Description.

Format:

Parameters:

SQLSTATEMENT_m: A variable length string containing the SQL statement.
SQLSTATEMENT_s: A variable length string containing the SQL statement.

SQLSTT examples

The following example shows SQLSTT that is part of the request to an OPNQRY call.

SQLSTT for Special Registry:
[ibm][ims][drda][t4]        SEND BUFFER: SQLSTT                 (ASCII)           (EBCDIC)
[ibm][ims][drda][t4] 0000   0032D0430001002C  2414002453455420  .2.C...,$..$SET   ..}.............
[ibm][ims][drda][t4] 0010   434C49454E542057  524B53544E4E414D  CLIENT WRKSTNNAM  .<..+.......++.(
[ibm][ims][drda][t4] 0020   452027392E36352E  3135302E32313827  E '9.65.150.218'  ................
[ibm][ims][drda][t4] 0030   0000                                ..                ..              

SQLSTT for Select Statement:
[ibm][ims][drda][t4]        SEND BUFFER: SQLSTT                 (ASCII)           (EBCDIC)
[ibm][ims][drda][t4] 0000   0029D04300020023  2414001B53656C65  .).C...#$...Sele  ..}...........%.
[ibm][ims][drda][t4] 0010   6374202A2066726F  6D20504844414D56  ct * from PHDAMV  .......?_.&...(.
[ibm][ims][drda][t4] 0020   41522E7761726400  00                AR.ward..         ..../....