This section describes the On-line Structured Query Language (OSQL) commands that are used to access Oracle tables. The user name on the Oracle Server to be used is declared before OSQL commands are issued. Data access is automatically committed as each command is executed. Retrieving, updating and adding rows to Oracle tables can be accomplished through the windows. The generated code for each command may be saved and defined in the current DBL to facilitate application prototyping.
The USE ORACLE SERVER AS user name command of ICL declares the current Oracle Server file name to be used for subsequent data access. This schema will be referenced by each OSQL command as the location of the desired Oracle table.
The Oracle table to be used is specified in the individual OSQL command.
The OSQL BUILD command will generate the OSQL commands necessary to construct the default application for this Data Base.
The OSQL CREATE DS command allows the creation of Oracle table definitions in the ACCENT R DBL environment.
The OSQL DELETE command may be used to remove rows from a table.
The OSQL EDIT command allows interactive and repetitive execution of OSQL and Interactive Command Language (ICL) commands from a command buffer.
Data may be exported into Oracle tables from DB-MACH2 tables or RMS files with the OSQL EXPORT command.
The OSQL HELP command provides assistance to the application designer about the characteristics and syntax of the On-line SQL (OSQL) facility.
Data may be imported into DB-MACH2 tables or RMS files from Oracle tables with the OSQL IMPORT command.
The OSQL INSERT command may be used to add rows to a table. Rows may be inserted into a table with the VALUES clause, a select expression, or the WITH WINDOW clause.
The OSQL MENU command creates either a horizontally or vertically-oriented menu for application prototyping.
The OSQL SELECT command may be used to identify and view a group of qualifying rows from a table or tables. Rows may be viewed as they are displayed on the terminal or through the WITH WINDOW clause.
The OSQL UPDATE command may be used to update the values of columns in a table. Columns can be affected with the SET clause or the WITH WINDOW clause.
The OSQL USE command invokes menus created with the OSQL MENU command.