SQLATTR command (X'2450')

The distributed data management (DDM) architecture SQL Statement Attributes command (SQLATTR) specifies the SQL statement attributes being prepared.

Format

Read syntax diagramSkip visual syntax diagramDSSHDRLLCPSQLSTTGRP

Parameters

DSSHDR
The six byte header field containing information about the DSS.
LL
A two byte field that has the length of the SQLATTR command.
CP(X'2450')
The 2-byte codepoint of the SQLATTR command.
SQLSTTGRP
SQL Statement Group Description.

Format:

Read syntax diagramSkip visual syntax diagramSQLSTATEMENT_mSQLSTATEMENT_s

Parameters:

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

SQLATTR examples

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

[ibm][ims][drda][t4]        SEND BUFFER: SQLATTR                (ASCII)           (EBCDIC)
[ibm][ims][drda][t4] 0000   001CD05300020016  2450000E464F5220  ...S....$P..FOR   ..}......&...|..
[ibm][ims][drda][t4] 0010   52454144204F4E4C  59200000          READ ONLY ..      .....|+<....