In this section: |
The Adapter for UniVerse provides several parameters for customizing the environment and optimizing performance. This topic provides an overview of customization options.
How to: |
The OPENMODE NNF setting determines how tables with multivalued columns are treated. For the Adapter for Universe to function properly, OPENMODE must be set to NNF in edasprof.prf.
ENGINE SQLUV SET OPENMODE NNF
where:
Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
Allows the user application to see UniVerse tables the way they actually exist, including any multi-valued columns.
How to: |
PASSRECS returns the number of rows affected by a successfully executed SQL Passthru INSERT, UPDATE, or DELETE command.
Tip: You can change this setting manually or from the Web Console by clicking Data Adapters on the menu bar, clicking a configured adapter, and choosing Change Settings from the menu. The Change Settings pane opens.
ENGINE SQLUV SET PASSRECS {ON|OFF}
where:
Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
Provides the number of rows affected in the application program SCB count member after the successful execution of an SQL Passthru INSERT, UPDATE, or DELETE command. ON is the default value.
Provides no information after the successful execution of an SQL Passthru INSERT, UPDATE, or DELETE command.
How to: |
In order to perform Data Definition Language commands in UniVerse using the server, the TRANSACTION setting must be set to OFF.
WebFOCUS |