USER_SELECT_EDIT

Read syntax diagramSkip visual syntax diagram
                      .-Y-.   
>>-USER_SELECT_EDIT=--+-N-+------------------------------------><

USER_SELECT_EDIT
Specifies whether a user can select the Edit option for the "Arbitrary SQL SELECT Statements" system option.
Y
Specifies that a user may select the Edit option for the "Arbitrary SQL SELECT Statements" system option. The default is USER_SELECT_EDIT=Y.
N
Specifies that a user may not select the Edit option for the "Arbitrary SQL SELECT Statements" system option.

Specify USER_SELECT_EDIT=N when it considered necessary to prevent users accessing the ZDT/Db2 editor - in edit mode - when processing the result table for any user-specified SELECT statements. The ZDT/Db2 editor - in either browse or view mode - is still used to display the result table from any user-specified SELECT statement. Since browse and view modes do not allow changes to be saved to Db2®, users are unable to make changes to Db2 data.

Note that this setting is applied when connecting to the local Db2 system only. Consider the following example:

In the HFM2POPT,

An ZDT/Db2 user locally connected to Db2 system DSNA can issue a statement like:

SELECT * FROM DSN81010.EMP,

but can only browse or view the result table.

The same user at DSNA can issue a statement like:

SELECT * FROM LOCN_B.DSN81010.EMP,

but can only view or browse the result table.

An ZDT/Db2 user locally connected to Db2 system DSNB can issue a statement like:

SELECT * FROM DSN81010.EMP,

and can browse, view or edit the result table.

The same user at DSNB can issue a statement like:

SELECT * FROM LOCN_A.DSN81010.EMP

and can browse, view or edit the result table.