This section describes On-line Structured Query Language (OSQL) commands that can be used for all DB-MACH2 and RMS tables. OSQL serves as an on-line, window-based tool for accessing data bases. Oracle data bases can also be accessed with OSQL (see separate manuals for the SQLgateway to Oracle). The DEFINE PM or CM clause in commands allows for quick prototyping of applications. OSQL commands may be used at the Interactive Command Language (ICL) level or embedded in Command Modules (CM’s). All OSQL commands are implemented using ACCENT R and will generate modifiable ACCENT R statements.
OSQL features the ability of one command to generate an entire maintenance application with INSERT, SELECT, and UPDATE screens tied together by a menu. The maintenance application can be built for selected tables/Data Sets or for all the tables/Data Sets (DS) in a given Data Base Library (DBL) at once. Separate commands can be used to build the INSERT, SELECT, or UPDATE screens individually.
OSQL offers a command buffer which can process ICL commands in batch. Commands are saved in the buffer for editing and/or repetitive use during the session. The command buffer uses the default editor specified in @EDITOR system field. The editor can be used to store the commands in the buffer permanently in a CM.
OSQL allows data to be moved between a DB-MACH2, RMS, and Oracle table. A user may design a customized menu with a single OSQL command. Users can also get help with OSQL command descriptions and syntax. A syntax summary is provided at the end of this OSQL section.
OSQL commands do not support subfields or arrays. More details on OSQL commands and Open SQL statements can be found in the Oracle SQLgateway Reference Manual. ACCENT R allows up to 8192 characters for an SQL statement. This allows more complex coding to be passed to the server.
OSQL BUILD
OSQL EDIT
OSQL EXPORT
OSQL HELP
OSQL IMPORT
OSQL INSERT
OSQL MENU
OSQL SELECT
OSQL UPDATE
OSQL USE