Preface
A
Technical Survey of ACCENT R
Introduction
General
Purpose DBL Objects
Data
Base Library
Schema
Definition
Data
Set
Command
Module
Process
Module
Code
Segment
Ancillary
Purpose DBL Objects
Control
File
Data
Index
Find
Subset
Global
Storage
Index
Definition
System
File
System
Information
Object
Interaction and Subordination
Parent
to Child Object Subordination
Overview
Introduction
The
SQLgateway to Oracle
Organization
of this Manual
Terminology
Data
Base Library Objects
Getting
Started with SQLgateway to Oracle
Prototyping
An Application
Generating
the Default Maintenance Screens
Exporting
RMS Files to Oracle
Getting
a Table Listing to Disk File
Defining
or Modifying a DBL Object
Customizing
your Development Environment
Oracle
Naming Convention
Accessing
Oracle’s SQL*Plus
Starting
an ACCENT R Session
Declaring
An Oracle Server
Creating
or using a Data Base library
CREATE
DBL
USE
DBL
Creating
an ACCENT R Schema Definition Object
Data
Types
Creating
and Removing an Oracle Table
Creating
New Table Or Attaching to an Existing Table
Removing
a Table
Schema
Definitions, Data Sets, and Tables
CREATE
DS Command
REMOVE
DS Command
ACCENT
R 4th Generation Tools
DataPaint
II - Window and Form Developer
Initialize
Menu
Reporter
- Report Generator
Display
the Initialize Menu
Enter
the Name of the Main Data Index
Other
Reporter Functions
Express
- Executive Information System
Library
Command Menu
Other
Express Functions
Manipulating
Oracle Tables Interactively from OSQL
Declaring
an Oracle Database (Server)
Declaring
an Oracle Table
Rapid
Application Prototyping with On-line SQL
Importing
Oracle Table Definitions
Deleting
Construct
On-line SQL Command Scripts
Exporting
Data
Obtaining
More Information About On-line SQL
Importing
Data
Adding
Designing
Menus with On-line SQL
Retrieving
Updating
Invoking
OSQL Menus
OSQL
BUILD Command
OSQL
CREATE DS Command
OSQL
DELETE Command
OSQL
EDIT Command
OSQL
EXPORT Command
OSQL
HELP Command
OSQL
IMPORT Command
OSQL
INSERT Command
OSQL
MENU Command
OSQL
SELECT Command
OSQL
UPDATE Command
OSQL
USE Command
Manipulating
Oracle tables from a Process Module
Declaring
an Oracle Database (Server)
Declaring
an Oracle Table
SQL
Transaction Processing
Deleting
Adding
Retrieving
Updating
@SQLCODE
System Field
Error
Messages
Command
Area Trace
Multiple
cursors
RELATE
Statement
SQL
COMMIT Work Statement
SQL
DELETE Statement
SQL
FETCH Statement
SQL
INSERT Statement
SQL
ROLLBACK WORK Statement
SQL
SELECT Statement
SQL
UPDATE Statement
Syntax
Summary
Embedded
SQL Statements
Interactive
Command Language (ICL) Commands
Structured
Programming Language (SPL) Statements
On-line
Structured Query Language (OSQL) Commands
Appendix
A: Books Sample Database
Appendix
B: A Comprehensive Example
Table
of Figures
Index
