Filter
Top Products
Preface
Purpose
This manual is a beginner's guide for the SymfoWARE Server Structured Query Language (SQL). The purpose of this
manual is to help readers write programs for a variety of different data operations using SymfoWARE/RDB databases.
SymfoWARE is a database system supporting a client-server application configuration. In this manual, the
SymfoWARE client function is called SymfoWARE client, and the SymfoWARE server function is called SymfoWARE
server.
Intended Readers
This manual is intended for users who develop application programs for processing SymfoWARE/RDB databases.
Users should have the following skills and knowledge before reading this manual.
· Familiarity with SymfoWARE/RDB functions and a general understanding of databases
· Familiarity with applications that use SymfoWARE/RDB
· Ability to develop application programs using C or COBOL
· Ability to use the Solaris system or Windows N
· Ability to use Windows
Organization of This Manual
This manual is organized as follows:
Chapter 1 Overview of SQL
Describes the types of SQL and explains the rules common to SQL statements in this manual.
Chapter 2 Retrieving Data
Explains how to use the single-row SELECT statement to retrieve data.
Chapter 3 Modifying Data
Explains how to use the INSERT statement, UPDATE statement (search), and DELETE statement (search) to modify
data.
Chapter 4 Using a Cursor to Manipulate Data
Explains how to manipulate data using a cursor.
Chapter 5 Joining Multiple Tables and Manipulating Data
Explains how to join and manipulate data in multiple tables.
Chapter 6 Methods of Manipulating Data
Describes the methods used to manipulate data.
Chapter 7 Executing Dynamic SQL Statements while Application Programs Are Running
Explains how to execute dynamic SQL statements while application programs are running.
Appendix A SQL Data Types and Equivalent Host Variable Data Types
Describes SQL data types and their equivalent host variable data types.
Appendix B Handling RDB Messages
Explains how to reference user responses to messages displayed by SymfoWARE/RDB.
Appendix C SQLSTATE Values
Explains the SQLSTATE values reported to application programs as processing results.
Glossary
The glossary contains definitions of the terms used in this manual.
i