USER_SELECT_EDIT


1 USER_SELECT_EDIT=
1! Y
1 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 FM/Db2 editor - in edit mode - when processing the result table for any user-specified SELECT statements. The FM/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 FMN2POPT,

  • FMN2SSDM for Db2® system DSNA has USER_SELECT_EDIT=N, the CURRENT SERVER special register for DSNA is LOCN_A.
  • FMN2SSDM for Db2® system DSNB has USER_SELECT_EDIT=Y, the CURRENT SERVER special register for DSNB is LOCN_B.

An FM/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 FM/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.