Syntax Summary

Embedded SQL Statements

SQL COMMIT WORK

SQL DELETE /FROM/ table_name
     [WHERE str_exp,
     CURRENT ROW]
     [HUSH]

SQL INSERT /INTO/ table_name [(column_list)]
     {VALUES (\\constant_expression\\)
     select_str_exp}
     [HUSH]

SQL [FOR CURSOR cursor_name] FETCH NEXT ROW
     [HUSH]

SQL ROLLBACK  WORK

SQL [FOR CURSOR cursor_name] SELECT
     [DISTINCT] select_list
     FROM \\table_name\\
     [WHERE str_exp]
     [ORDER BY str_exp]
     [HUSH]
     SQL UPDATE table_name

SET str_exp
     [WHERE str_exp]
     [CURRENT ROW]
     [HUSH]

Interactive Command Language (ICL) Commands

CREATE DBL name

USE DBL name

USE NO DBL

USE NO ORACLE SERVER

USE ORACLE SERVER /AS/ user_name

CREATE DS table_name SD schema_definition_name
      [ATTACH, ENTRY /ONLY/ CREATE /IF MISSING/]

REMOVE [ENTRY FOR] DS \\table_name\\

ORACLE

For a complete list of ICL commands, see the ACCENT R Quick Reference Guide or Volume I of the ACCENT R Professional Desk Reference Set.

Structured Programming Language (SPL) Statements

RELATE DS table_name {AS, TO, WITH} designator
      FOR {GET, PUT, DELETE, /CREATE/ APPEND, UPDATE}

For a complete list of SPL statements, see the ACCENT R Quick Reference Guide or Volume II of the ACCENT R Professional Desk Reference Set.

On-line Structured Query Language (OSQL) Commands

OSQL BUILD FOR {TABLE \\table_name [,...]\\; ALL TABLES}
     DEFINE CM command_module_name ONLY

OSQL CREATE DS; FOR
     {ALL TABLES, TABLE \\table_name}
     [HUSH]

OSQL DELETE  /FROM/ table_name
     [WHERE str_exp]
     [DEFINE PM process_module_name [ONLY]]

OSQL EDIT [NEW]

OSQL EXPORT FROM source_table_name
      TO destination_table_name
     [DEFINE PM process_module_name [ONLY]]

OSQL [HELP; ?; SYNTAX] [command_name]

OSQL IMPORT FROM source_table_name
     TO destination_table_name
     [DEFINE PM process_module_name [ONLY]]

OSQL INSERT /INTO/table_name
     [(column_list)]
     {WITH WINDOW
     VALUES (\\constant_expression\\)
     select_str_exp}
     [DEFINE PM process_module_name [ONLY]]

OSQL MENU menu_title_str
     [HORIZONTAL; VERTICAL]
     \\ITEM item_title_str {USE {CM; PM; SF}
     object_name, DO command_str}\\
     DEFINE PM menu_name_MENU ONLY

OSQL SELECT [DISTINCT] select_list  FROM \\table_name\\
     [WHERE str_exp]
     [ORDER BY str_exp]
     [WITH WINDOW]
     [DEFINE PM process_module_name [ONLY]]

OSQL UPDATE table_name
     {SET str_exp
     WITH WINDOW}
     [WHERE str_exp]
     [DEFINE PM process_module_name [ONLY]]

OSQL USE object_type object_name