ISQL : IQ539E: The requested library does not exist or is not a PDS.

Products

• Database Management for DB2 for z/OS - Administration Suite

Issue/Introduction

A user is trying to write SQL statements to an output dataset.

 

Environment

Release: R20
Component: ISQL

Cause

On the "ISQL Dataset I/O Specification" when specifying Option O (Write output dataset) the dataset must exist and be a partitioned dataset (PDS) if a member is specified.

Resolution

Specify an output data set name, including the member name. This dataset must exist.

If the dataset name provided does not exist or where a member is specified and the dataset is not a partitioned dataset then message IQ539E The requested library does not exist or is not a PDS. Try another. will be generated.

To specify a fully qualified name, enter the name in single quotation marks. Otherwise, your TSO ID will be prefixed to the data set name. If a member is specified that does not exist, ISQL will create it. If an existing member is specified, the current contents are deleted and the new SQL exported.

If the dataset name is left blank when the "O" option is used then the current SQL stored is written to the input dataset. The input dataset is a required field where the output dataset is not.

Additional Information

IQ539E: The requested library does not exist or is not a PDS.