Manualsbrain.com
  1. Manuais
  2. Marcas
  3. Fujitsu
  4. J2X0-1634-01EN
  5. Manual Do Utilizador

Fujitsu J2X0-1634-01EN Manual Do Utilizador

Download
Página de 227
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