DSNT274I ERROR USING SQLDDNAME(ddname): error-text

Explanation

Db2 could not open or read the data set or file assigned to the ddname DD statement in the JCL for the BIND SERVICE subcommand because one or more of the conditions specified in error-text occurred.

.
ddname
Name of a data set or file that is specified for the SQLDDNAME parameter of the BIND SERVICE subcommand.
error-text
Description of any of the following conditions that can cause the error:
DDNAME CANNOT BE OPENED
The DD job card is not provided in the JCL or an error prevents the opening of the data set or file. Review all job messages.
INVALID DSORG OR RECFM SPECIFICATION
The data set, the fully-qualified member of a PDS/PDSE library, or the zFS or UNIX file has invalid characteristics. The organization of the data set or file must be sequential. The format must be F (fixed-length records, unblocked), FB (fixed-length records, blocked), V (variable-length records, unblocked), or VB (variable-length records, blocked). Make sure that RECFM=VB is specified with the DD statement when it refers to a zFS or UNIX file.
EMPTY DATASET OR FILE
The end of file is reached before any data is read in.
I/O ERROR DETECTED - error-desc
When the ddname data set or file is read, an I/O error with error-desc is detected. One possible cause for the I/O error "WRNG.LEN.RECORD" is that a member name is not specified along with the PDS or PDSE library name for the ddname DD statement. See "SYNADAF Error Descriptions" in the z/OS documentation for more information.

System action

The BIND SERVICE subcommand operation is not performed.

System programmer response

If an I/O error is detected, verify that the data set or file specified for the DD statement is a supported DSORG or RECFM and that the data set or file exists and can be opened.

User response

Verify that the BIND SERVICE job JCL contains a valid ddname DD specification. Make sure that the data set or file actually exists, contains a valid SQL statement, and can be opened and read.

Severity

8 (error)