home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware 1 2 the Maxx
/
sw_1.zip
/
sw_1
/
TEXT
/
PDX_ALL.ZIP
/
TI628.ASC
< prev
next >
Wrap
Text File
|
1991-09-11
|
4KB
|
133 lines
PRODUCT : Paradox NUMBER : 628
VERSION : All
OS : DOS
DATE : September 11, 1991 PAGE : 1/2
TITLE : Overview and abilities of Paradox SQL-Link
OVERVIEW
Paradox SQL Link is an add-in product that allows you to use
Paradox 3.5 as a front end for accessing data from a SQL database
server. You can use Paradox's interactive menus or the PAL
language for accessing this information, without having to learn
SQL programming.
SQL (Structured Query Language) is an internationally established
database language for managing relational data. To use the data
the SQL language statements must be used. Paradox SQL Link
operates as a layer between Paradox 3.5 and the SQL server,
translating a Paradox operations into the appropriate SQL
commands and then forwarding them to the server. The commands
are then executed and any result is returned to Paradox as a
normal answer table. Paradox can simultaneously work with remote
tables and conventional paradox tables.
SQL is usually implemented in a client-server architecture.
There is a database server (commonly a mainframe, mini or high-
end PC.) with clients (generally PC's) connected through a
network. Paradox is run on the PC workstations of the network.
Since the data is stored and directly manipulated on the central
server, having a powerful server machine can yield good
performance without high machine requirements for the client
workstations (80286 or higher CPU, RAM requirements below).
Using Paradox as the front end, allows access to larger amounts
of data without learning a new software package. Data security
and maintenance can also be simplified by having the data stored
on one central machine.
The SQL servers currently supported are: RAM Req'd:
(megabytes)
DEC VAX Rdb/VMS 3.1B 1.0
IBM Extended Edition Database Manager 1.2 or higher 1.0
Microsoft SQL Server 1.x 1.0
Oracle Server 6.0 or higher 1.5
Sybase SQL Server 4.x 1.0
PRODUCT : Paradox NUMBER : 628
VERSION : All
OS : DOS
DATE : September 11, 1991 PAGE : 2/2
TITLE : Overview and abilities of Paradox SQL-Link
ABILITIES
Some of the capabilities of Paradox 3.5 with SQL Link are:
1)Queries on database tables
a)for manipulating data on the server or
b)retrieving data from the server.
2)Table creation and access of existing tables.
3)Table manipulation (add, copy, delete, empty, etc.).
4)Reporting of information existing on the server.
5)Added PAL commands and functions for programming access to the
server.
6)Application of transaction processing techniques for data
integrity.
REQUIREMENTS
The database server and appropriate network must be running. The
workstations must be running Paradox 3.5 in protected mode to
utilize SQL Link. (See your User's Guide, Chapter 14 - Advanced
Topics/"How Paradox manages memory" for additional information on
protected mode.)