SQLDDNAME bind option

Option descriptions for SQLDDNAME

SQLDDNAME(ddname)

The name of a JCL DD statement. The DD statement specifies the file or data set that contains a single SQL statement to be included in a REST service. If the SQLDDNAME parameter is not provided, DSNSTMT is used as the default name.

The JCL for the BIND SERVICE subcommand must provide a valid DD specification for ddname. The DSNAME parameter of the DD specification must be either a valid DSORG=PS data set or a member-qualified library, such as library.name(member). If the SQL statement text is provided via a zFS or UNIX file, the PATH parameter, which is mutually exclusive with the DSNAME parameter, must specify a fully qualified name to the zFS or UNIX file.

Db2 opens and reads the data set or file referenced by the DD specification for input only. The maximum amount of data read is 2097152 bytes. The organization of the data set or file must be sequential. Db2 also checks the data set or file to determine if it has a valid record format (RECFM). A valid RECFM is F (fixed-length records, unblocked), FB (fixed-length records, blocked), V (variable-length records, unblocked), or VB (variable-length records, blocked).

zFS or UNIX files are normally not defined with RECFM. Make sure that you specify RECFM=VB in the DD statement when it refers to a zFS or UNIX file as shown in the following example:

//DSNSTMT DD PATH='/file_path',
// PATHOPTS=ORDONLY,
// RECFM=VB,LRECL=32756,BLKSIZE=32760

If the DD specification refers to a temporary data set created within the job, make sure that you specify the DCB parameter with all the options, including RECFM, as in DCB=(RECFM=[V|VB|F|FB],LRECL=nnnnn,BLKSIZE=mmmmm).

Default values for SQLDDNAME