ODBC Edition 4.

51
OLE DB Edition 2.0
Java Edition 2.0

DataDirect ®
®

SequeLink Server

Progress Supplement

Progress 7.3x, 8.x, and 9.0x

© 1999 MERANT. All rights reserved. Printed in the U.S.A.

INTERSOLV, DataDirect, APS, Maintenance Workbench, PVCS, TechGnosis,

SequeLink, and Middleware are registered trademarks of MERANT. PVCS
SiteSync, INTERSOLV Messaging, DataDirect Connect ODBC, DataDirect
Connect OLE DB, DataDirect Reflector, WebDBLink, Client/Server MiddleWare,
PVCS VM Server, PVCS Dimensions, PVCS Process Manager, PVCS Version
Manager, PVCS Tracker, and PVCS TrackerLink are trademarks of MERANT.
Micro Focus is a registered trademark and Net Express is a trademark of
MERANT International Limited. Other company or product names mentioned
herein may be trademarks or registered trademarks of their respective
companies.

No part of this publication, with the exception of the software product user
documentation contained on a CD-ROM, may be copied, photocopied,
reproduced, transmitted, transcribed, or reduced to any electronic medium or
machine-readable form without prior written consent of MERANT.

Licensees may duplicate the software product user documentation contained

on a CD-ROM, but only to the extent necessary to support the users
authorized access to the software under the license agreement. Any
reproduction of the documentation, regardless of whether the
documentation is reproduced in whole or in part, must be accompanied by
this copyright statement in its entirety, without modification.

U.S. GOVERNMENT RESTRICTED RIGHTS. It is acknowledged that the Software

and the Documentation were developed at private expense, that no part is in
the public domain, and that the Software and Documentation are Commercial
Computer Software provided with RESTRICTED RIGHTS under Federal
Acquisition Regulations and agency supplements to them. Use, duplication or
disclosure by the U.S. Government is subject to restrictions as set forth in
subparagraph (c)(1)(ii) of The Rights in Technical Data and Computer Software
clause at DFAR 252.227-7013 et. seq. or subparagraphs (c)(1) and (2) of the
Commercial Computer Software Restricted Rights at FAR 52.227-19, as
applicable. Contractor is MERANT, 701 East Middlefield Road, Mountain View,
California 94043. Rights are reserved under copyright laws of the United
States with respect to unpublished portions of the Software.

MERANT
701 East Middlefield Road
Mountain View, California 94043
 3

Table of Contents

Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
What Is DataDirect SequeLink? . . . . . . . . . . . . . . . . . . . . . . . . 5
Using This Supplement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
Other Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Conventions Used in This Supplement . . . . . . . . . . . . . . . . . . . 9
Typographical Conventions . . . . . . . . . . . . . . . . . . . . . . . . . 9
Mouse Conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Keyboard Conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

Contacting Technical Support . . . . . . . . . . . . . . . . . . . . . . . . . . 11

1 Before You Begin . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15

Read the READ.ME File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Test Your Network . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Test Your Database Access. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
MERANT Product Registration . . . . . . . . . . . . . . . . . . . . . . . . . 17

2 Installing SequeLink Server for Progress . . . . . . . . . 19

Installing SequeLink Server for Progress on Windows NT. . . . 20
Installing SequeLink Server for Progress on UNIX . . . . . . . . . . 22
Installing SequeLink Server for Progress on
UNIX (Non-linking) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
Installing SequeLink Server for Progress on
UNIX (Linking) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30

SequeLink Server Progress Supplement

4

3 Administering SequeLink Server for Progress. . . . . 39

SequeLink Functionality with Progress Databases . . . . . . . . . 40
Using Progress-specific Settings. . . . . . . . . . . . . . . . . . . . . . . . 41
Data Types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48
Using Hyphenated Table and Column Names . . . . . . . . . . . . 49
Using Views. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50
Using Dates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51
Date Input Using Literals . . . . . . . . . . . . . . . . . . . . . . . . . . 51
Date Input Using Literals and the SequeLink
Translator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52

Using the SequeLink CAT with Progress . . . . . . . . . . . . . . . . . 53

Service Parameters for Progress . . . . . . . . . . . . . . . . . . . . 53

Using the SequeLink Dictionary Manager . . . . . . . . . . . . . . . 56

SQL Scripts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56
SSDD Location. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56
Schemas and Catalogs . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57
DataDictionaryOwner and DataDictionaryQualifier . . . . 57

Using Multiple Progress Databases . . . . . . . . . . . . . . . . . . . . . 58

Using Multiple Progress Databases with SQL . . . . . . . . . . 59
Data Dictionary Statements and Multiple
Connections . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60

Using Array Columns (Extents) . . . . . . . . . . . . . . . . . . . . . . . . 61

Data Dictionary Statements and Array Columns . . . . . . . 61

4 Using the SequeLink JDBC Driver. . . . . . . . . . . . . . . 63

Specifying Connection URLs . . . . . . . . . . . . . . . . . . . . . . . . . . 63
Service Attributes for Progress . . . . . . . . . . . . . . . . . . . . . . . . 64

SequeLink Server Progress Supplement

 5

Preface

This supplement is your guide to installing and administering the

MERANT™ DataDirect® SequeLink® Server for Progress. Read on
to find out more about SequeLink and how to use this
supplement.

What Is DataDirect SequeLink?

DataDirect SequeLink is a series of standards-based client/server
middleware products that allow clients to access databases on
multiple servers using existing operating systems and network
infrastructures.

The following SequeLink editions are available:

■ SequeLink ODBC Edition supports Open Database

Connectivity (ODBC) applications.

■ SequeLink OLE DB Edition supports OLE DB applications.

■ SequeLink Java Edition supports Java Database Connectivity

(JDBC) applications.

SequeLink Server Progress Supplement

6 Preface

Using This Supplement

Audience and This supplement includes information which is specific to
prerequisite SequeLink Server for Progress and was not included in the other
knowledge SequeLink installation and reference guides.

This supplement assumes that you are familiar with your

operating system and its commands; the definition of directories;
the management of user accounts and security access; and your
network protocol and its configuration.
How this This supplement contains the following information:
supplement is
organized ■ Chapter 1, “Before You Begin” describes tasks you should
perform before you install SequeLink Server for Progress.

■ Chapter 2, “Installing SequeLink Server for Progress” provides

installation instructions for SequeLink Server for Progress on
Windows NT and UNIX.

■ Chapter 3, “Administering SequeLink Server for Progress”

provides administration information specific to the Progress
environment.

■ Chapter 4, “Using the SequeLink JDBC Driver” provides

information for using SequeLink Server for Progress with the
JDBC Driver.

SequeLink Server Progress Supplement

 Other Documentation 7

Other Documentation
SequeLink ODBC Edition:
■ SequeLink ODBC Edition Client Installation Guide
■ SequeLink Server Installation Guide
■ SequeLink ODBC Driver Reference for Windows 3.1x
■ SequeLink ODBC Driver Reference for Windows 9x,
Windows NT, UNIX, and Macintosh
■ SequeLink Administrator’s Guide
■ SequeLink Error Codes and Messages Reference

SequeLink OLE DB Edition:

■ SequeLink OLE DB Edition Client Installation Guide
■ SequeLink Server Installation Guide
■ SequeLink OLE DB Provider Reference
■ SequeLink Administrator’s Guide
■ SequeLink Error Codes and Messages Reference

Note: Getting Started with DataDirect for OLE DB is also

available.

SequeLink Java Edition:

■ SequeLink Java Edition Client Installation Guide
■ SequeLink Server Installation Guide
■ SequeLink JDBC Driver Reference
■ SequeLink Administrator’s Guide
■ SequeLink Error Codes and Messages Reference

SequeLink Server Progress Supplement

8 Preface

The following table provides a guide for finding the information

you need about SequeLink.

For information about… Go to…

Installing SequeLink Server SequeLink Server Progress Supplement
SequeLink Server Installation Guide
Installing SequeLink Clients SequeLink ODBC Edition Client Installation Guide
SequeLink OLE DB Edition Client Installation Guide
SequeLink Java Edition Client Installation Guide

Installing the SequeLink Online Instructions are available on the DataDirect CD

Documents Insert and on the Web site.

Planning, configuring, and SequeLink Server Progress Supplement

administering your system and SequeLink Administrator’s Guide
network for SequeLink; creating
and managing data sources; using
SequeLink with your database

Troubleshooting problems and SequeLink Error Codes and Messages Reference

referencing error codes

Using the SequeLink ODBC Drivers SequeLink ODBC Driver Reference for Windows 3.1x
SequeLink ODBC Driver Reference for Windows 9x,
Windows NT, UNIX, and Macintosh

Using the SequeLink OLE DB SequeLink OLE DB Provider Reference

Provider Getting Started with DataDirect for OLE DB

Using the SequeLink JDBC Driver SequeLink Server Progress Supplement

SequeLink JDBC Driver Reference

SequeLink Server Progress Supplement

 Conventions Used in This Supplement 9

Conventions Used in This Supplement

The following sections describe the typography, terminology,
and other conventions used in this supplement.

Typographical Conventions
This supplement uses the following typographical conventions:

Convention Explanation
italics Introduces new terms with which you may not be
familiar, and is used occasionally for emphasis.
bold Emphasizes important information. Also indicates
button, menu, and icon names on which you can
act. For example, click Next.
UPPERCASE Indicates the name of a file. For operating
environments that use case-sensitive filenames, the
correct capitalization is used in information specific
to those environments.
Also indicates keys or key combinations that you
can use. For example, press the ENTER key.
monospace Indicates syntax examples, values that you specify,
or results that you receive.
monospaced Indicates names that are placeholders for values
italics that you specify. For example, filename.
forward slash / Separates menus and their associated commands.
For example, Select File / Copy means that you
should select Copy from the File menu.
The slash also separates directory levels when
specifying locations under UNIX.
vertical rule | Indicates an “OR” separator used to delineate
items.

SequeLink Server Progress Supplement

10 Preface

Convention Explanation
brackets [ ] Indicates optional items. For example, in the
following statement: SELECT [DISTINCT], DISTINCT
is an optional keyword.
Also indicates sections of the Windows Registry.
braces { } Indicates that you must select one item. For
example, {yes | no} means that you must specify
either yes or no.
ellipsis . . . Indicates that the immediately preceding item can
be repeated any number of times in succession. An
ellipsis following a closing bracket indicates that all
information in that unit can be repeated.

Mouse Conventions
This action… Means to…
Click Point to an object with the mouse pointer and
momentarily press the left mouse button.
Double-click Press the left mouse button twice.
Right-click Momentarily press the right mouse button.
Drag Press and hold the left mouse button while
dragging item(s) to another part of the screen.
SHIFT+Click Click an object to select it; then, press and hold
the SHIFT key. Click another object to select the
intervening series of objects.
CTRL+Click Press and hold the CTRL key; then, click a
selection. This lets you select or deselect any
combination of objects.

Keyboard Conventions
Select menu items by using the mouse or pressing ALT+ the key
letter of the menu name or item.

SequeLink Server Progress Supplement

 Contacting Technical Support 11

Contacting Technical Support

MERANT provides technical support for all registered users of
SequeLink, including limited installation support, for the first 30
days. For support after that time, contact us using one of the
following methods or purchase further support by enrolling in
the SupportNet program. For more information about
SupportNet, contact your sales representative.

World Wide http://www.merant.com/datadirect/support

Web
The MERANT Web site provides the latest support information
through SupportNet Online, our global service network that
provides access to valuable tools and information. Our
SupportNet users access information using the Web, automatic
email notification, newsgroups, and regional user groups.
SupportNet Online includes a knowledge base that allows you to
search on keywords for technical bulletins and other
information. You also can download product fixes for your
DataDirect products.

Internet

Australia and New australia.answerline@merant.com

Zealand
EMEA int.datadirect.answerline@merant.com
Japan jpn.answerline@merant.co.jp
USA and Canada datadirect.answerline@merant.com

Telephone

Australia 1 800 335 664 or 8:30-5:30 p.m. Local Melbourne Time (LMT)
9816 9977 for
Melbourne Metro
Belgium 0800 724 61 9:00-6:30 p.m. CET
France 0800 91 56 07 9:00-6:30 p.m. CET

SequeLink Server Progress Supplement

12 Preface

Germany 0130 822 496 or 9:00-6:30 p.m. CET

+44 1727 812898
Japan 81-3-5401-9660 9:00-12:00, 1:00-5:00 p.m. JST
The Netherlands 0800 022 1609 9:00-6:30 p.m. CET
New Zealand 1 800 335 664 8:30-5:30 p.m. LMT
United Kingdom +44 1727 811881 8:00-5:30 p.m. GMT
and Ireland
USA and Canada 1 800 443 1601 8:30-8:00 p.m. EST

Fax and Mail

Information

Fax US 1 919 461 4527

Fax International +32-15-320919
Mail 1500 Perimeter Park Drive, Suite 100, Morrisville, NC 27560 USA

When you contact us, make sure that you can provide the
following information:

■ The product serial number located on the Product

Registration Information card or on a product serial number
card in your package. The number will be checked to verify
your support eligibility. If you do not have a SupportNet
contract, we will ask you to speak with a sales representative.

■ Your name and organization. For a first-time call, you may be

asked for full customer information, including location and
contact details.

■ The version number of your DataDirect product.

■ The type and version of your operating system.

■ Any third-party software or other environment information

required to understand the problem.

■ A brief description of the problem, including any error

messages that you have received, and the steps preceding the
occurrence of the problem. Depending on the complexity of

SequeLink Server Progress Supplement

 Contacting Technical Support 13

the problem, you may be asked to submit an example so that

we can recreate the problem.

■ An assessment of the severity level of the problem.

SequeLink Server Progress Supplement

14 Preface

SequeLink Server Progress Supplement

 15

1 Before You Begin

DataDirect SequeLink Server for Progress is a SequeLink Server

for accessing a Progress database through any of the SequeLink
Clients. The Progress database is a relational database
management system running on either Windows NT or UNIX
operating systems.

SequeLink Server for Progress uses the Progress ESQL/C-89

interface to interact with the Progress database. The statements
passed through this interface are Progress SQL statements.

This chapter describes the tasks you should perform before you
install SequeLink Server for Progress. For additional information
about tasks performed prior to installation, refer to the
SequeLink Server Installation Guide.

Read the READ.ME File

Read the SequeLink READ.ME text file on your CD or other
distribution media. The READ.ME file can be found in the
directory sequelnk.

Note: The READ.ME file is also available from the Web site.

SequeLink Server Progress Supplement

16 Chapter 1 Before You Begin

Test Your Network

Make sure that your communications network is installed and
running. For example, if you are using a TCP/IP network in your
SequeLink environment, you can test your network by using the
ping command. For more information about testing your
network, refer to your networking product documentation.

Test Your Database Access

Before you install SequeLink, your Progress database
environment must be up and running. The following items must
be verified:

■ A Progress Server must be installed on Windows NT or UNIX.

■ For every Progress database you want to access, a Progress

database server must be started using the Proserve command.
The database servers must be started after every reboot of
Windows NT or UNIX.

For example:

■ To start a Progress database server on UNIX for a database

called demo in the /users/data directory, enter the
following command:

proserve /users/data/demo
■ To start a Progress database server on Windows NT for a
database called Demo in the C:\PROGRESS directory, enter
the following command:

proserve C:\PROGRESS\DEMO
The ProControl NT Service Program can also be used to
start a database.

SequeLink Server Progress Supplement

 MERANT Product Registration 17

Important: By default, access to shared memory on

Windows NT is only allowed to the user who created it. In
addition, only the user who started the database server
can connect to it using shared memory. You can override
this default by setting the Progress ACCESS environment
variable. You can give specific users or groups access to
shared memory.
For example, to allow all users to get access to a database
using shared memory, set the environment variable as
follows:
ACCESS=Everyone
This environment variable must be set before running the
Proserve command.

MERANT Product Registration

During installation, you will be prompted for your Serial Number
and Key to register the product. You can find the Serial Number
and Key printed on the Product Registration Information card
that is shipped with the product.

If you want to access software for which you do not have a

license, contact MERANT DataDirect.

SequeLink Server Progress Supplement

18 Chapter 1 Before You Begin

SequeLink Server Progress Supplement

 19

2 Installing SequeLink Server for

Progress

This chapter provides the following installation information that

is specific to Progress:

■ “Installing SequeLink Server for Progress on Windows NT” on

page 20.

■ “Installing SequeLink Server for Progress on UNIX” on

page 22.

For additional information about installing SequeLink Server,

including mounting the CD on Windows NT and UNIX, refer to
the SequeLink Server Installation Guide.

SequeLink Server Progress Supplement

20 Chapter 2 Installing SequeLink Server for Progress

Installing SequeLink Server for Progress on

Windows NT
The following procedure guides you through installing SequeLink
Server for Progress on Windows NT:

1 Log on to Windows NT as a user with administration rights.

2 Insert the CD-ROM.

3 Start the Product Setup.

Note: On Windows NT, the Product Setup starts automatically

if AutoPlay for CDs is enabled (the default) when the CD is
mounted. If AutoPlay for CDs has been disabled, navigate to
the root directory on the CD; then, double-click
setupw32.exe.

4 Select the following item from the product menu:

SequeLink Server for Progress on Windows NT

5 Click Run Setup.

The Welcome window appears.

6 Click Next.

The Installation Directory window appears.

7 Enter the target directory for the software.

The Program Folder Selection window appears.

8 Type the program folder name in the program folder field, or

select an existing folder name from the Existing Folders list by
clicking on a name.

The Product Registration window appears.

SequeLink Server Progress Supplement

 Installing SequeLink Server for Progress on Windows NT 21

9 Enter your name, company, serial number and IPE key. The
serial number and key are on the Product Registration
Information card shipped with the product. If you are
installing an evaluation copy, leave the key field empty.

The Registration Confirmation window appears, showing the

information you entered in the Product Registration window.

10 Confirm that the registration information is correct.

After confirmation, the Product License Agreement window

appears. The text on this screen refers you to a printed
version of the software license agreement. If you accept the
agreement, the installation continues. If not, the installation
stops and no software is installed.

The Progress Environment window appears.

11 Enter the information for your Progress DLC environment

and PROMSGS environment variables.

A final confirmation of your settings appears.

12 Verify that the settings are correct; then, click OK to start the
installation.

The Add Service window appears.

13 Click OK to add the service and complete the installation.

For additional information about the Add Service window,

refer to the SequeLink Server Installation Guide.

SequeLink Server Progress Supplement

22 Chapter 2 Installing SequeLink Server for Progress

Installing SequeLink Server for Progress on

UNIX
Installing SequeLink Server for Progress on UNIX requires:

■ Transferring files to your UNIX server

■ Extracting the files
■ Running the installation script

In addition, there are two types of installations on UNIX, which

are described in the following sections:

■ “Installing SequeLink Server for Progress on UNIX

(Non-linking)”on this page.

■ “Installing SequeLink Server for Progress on UNIX (Linking)”

on page 30. Linking is required if the correct SequeLink Server
for Progress executable is not present in the distribution files.

Note: For information about mounting your CD on UNIX

platforms, refer to the SequeLink Server Installation Guide.

Installing SequeLink Server for Progress

on UNIX (Non-linking)
Use the following procedure to install SequeLink Server for
Progress (Non-linking) on UNIX. To view a sample installation
script, see “Sample Installation Script (Non-linking UNIX)” on
page 26.

Transferring the SequeLink Server File

1 Log on to your UNIX server as root.

SequeLink Server Progress Supplement

 Installing SequeLink Server for Progress on UNIX 23

2 Create a temporary directory to contain the installation files.

For example, to create an installation directory called sqlnk in
the tmp directory, enter:

mkdir /tmp/sqlnk
3 Transfer the SequeLink Server file.

The SequeLink server is delivered in a UNIX tar file called

SLPRO.TAR. Copy or transfer this file from the distribution
media to the temporary installation directory on your UNIX
server.

Important: Transfer the file in binary format. If you transfer

the file in the wrong format, the installation will fail.

Extracting the SequeLink Server File

On the UNIX server, access the tar file you transferred to the
SequeLink installation directory and extract it. Type:

tar -xvf SLPRO.TAR

Note: On Solaris, using the -xvf argument with the tar command
may cause warnings to appear; use the -xof argument instead.
For example, type:

tar -xof SLPRO.TAR

Running the Installation Script

When you run the installation script, it prompts you for choices
you need to make and information you need to supply. Default
answers to questions are enclosed within square brackets [ ]. To
accept the default, press the Enter key.

1 On the server, change to the temporary installation directory.

For example, enter:

cd /tmp/sqlnk

SequeLink Server Progress Supplement

24 Chapter 2 Installing SequeLink Server for Progress

2 Issue the following command:

ksh install.sh SSPPRO.tar

The product information summary appears (this example

shows the information that is displayed when SequeLink
Server for Progress is installed on AIX):
----------------------------------------------------
You are installing the product:

DataDirect SequeLink Server for Progress 7.3x or

higher
Version 4.5 on AIX 4.x
----------------------------------------------------
Do you want to continue (Y/N) ? [Y]
----------------------------------------------------

3 Press Enter to continue the installation.

4 Enter the target directory for SequeLink. If the directory you

enter does not exist, it is created for you.

5 Enter the full path for your Progress DLC directory. The
version of Progress and the presence of the proper executable
in the tar file are verified. If the executable cannot be found,
a warning is given that another version will be installed. A
correct version can be made by restarting the installer with
the Linking option.

A screen appears with the installation information you

supplied.

6 Review the installation information. You can choose to

continue with the installation using these settings, change
any settings, or end the installation.

7 Enter the appropriate choice. The files are now extracted.

The product registration message appears.

SequeLink Server Progress Supplement

 Installing SequeLink Server for Progress on UNIX 25

8 Enter your name, company name, serial number, and key. The
serial number and key are printed on the Product
Registration Information card that is shipped with the
product. If you are installing an evaluation copy of SequeLink
Server for Progress, leave the Key field empty.

A MERANT Product License Agreement screen appears. The

text on this screen points you to a printed version of the
software license agreement.

9 Enter YES to accept the agreement and continue the

installation.

10 Enter a unique SequeLink service name and an available TCP

port number.

Note: Refer to the SequeLink Server Installation Guide for

information about using port numbers.

A message appears when the installation is complete.

SequeLink Server Progress Supplement

26 Chapter 2 Installing SequeLink Server for Progress

Sample Installation Script (Non-linking UNIX)

The following sample installation script shows SequeLink Server
for Progress installing on AIX using Progress version 8.2B.
# ksh install.sh SSPPRO.tar

DataDirect SequeLink Server installer is uncompressing now.

Please wait...

------------------------------------------------------------------------
You are installing the product:

DataDirect SequeLink Server for Progress 7.3x or higher

Version 4.5 on AIX 4.x
------------------------------------------------------------------------
Do you want to continue (Y/N) ? [Y] y
------------------------------------------------------------------------
Enter the target directory where you want to install SequeLink.
If this directory does not exist, it will be created for you.
------------------------------------------------------------------------
Enter target directory ? [/usr/sqlnk] : /usr/sqlnk

Enter the full path of your Progress

DLC directory [/usr/dlc] :
/progress/pro82B/dlc

Detecting Progress version...

echo PROGRESS Version 8.2B as of Wed Aug 27 19:00:12 EDT 1997
Detecting if the executable slpro_82B is present in the tar file ...
slpro_82B
Executable slpro_82B found
------------------------------------------------------------------------
Ready to start installation with the following settings:

SequeLink home directory : /usr/sqlnk

Progress DLC directory : /progress/pro82B/dlc
Progress version : 82B
Link service executables : No

You will need approx. 5500 kBytes free diskspace in your SequeLink home
directory (depending on your platform and configuration).
------------------------------------------------------------------------
1) Start installation with these settings

SequeLink Server Progress Supplement

 Installing SequeLink Server for Progress on UNIX 27

2) Change SequeLink home directory

3) Change Progress DLC directory
4) Change Progress version
9) Abort installation
Enter your choice [1] ? 1
Extracting file: ./srvcpro.cfg

Extracting files...
Extracting file: /usr/sqlnk/slsrvcfg
Extracting file: /usr/sqlnk/slsrvcfg.msg
Extracting file: /usr/sqlnk/toolkit.sh
Extracting file: /usr/sqlnk/4_50_00/msg/lediag.msg
Extracting file: /usr/sqlnk/4_50_00/msg/rldiag.msg
Extracting file: /usr/sqlnk/4_50_00/msg/prodiag.msg
Extracting file: /usr/sqlnk/4_50_00/admin/dmprogr.sql
Extracting file: ./iperegister
Extracting file: ./ipemerge
Extracting file: ./ipemsg.msg
Copying file: rscshell to /usr/sqlnk/rscshell
Extracting file: /usr/sqlnk/4_50_00/bin/slpro_82B
Extracting file: /usr/sqlnk/4_50_00/bin/slpro_82C

------------------------------------------------------------------------
The software you are installing will now be registered.
If you are installing an evaluation copy, leave the IPE key blank when
asked for.
------------------------------------------------------------------------

INTERSOLV Product Registration

Please enter the following information for proper registration.

Name :
-----------------
YourName

Company :
-----------------
YourCompanyName

Serial Number :
-----------------
YourSerialNr

SequeLink Server Progress Supplement

28 Chapter 2 Installing SequeLink Server for Progress

IPE Key :
-----------------
YourIPEKey

-------------------------------------------
--------- Information entered -------------
-------------------------------------------
Name: YourName
Organization: YourCompanyName
Serial Number: YourSerialNr
IPE Key: YourIPEKey
-------------------------------------------

To change this information enter C. Otherwise select Enter to continue.

------------------------------------------------------------------------

THE USE OF THIS SOFTWARE IS GOVERNED BY THE LICENSE AGREEMENT

ACCOMPANYING THE PRODUCT. YOU SHOULD READ THE AGREEMENT CAREFULLY. IF
YOU AGREE TO ACCEPT THE TERMS OF THIS AGREEMENT, INDICATE YOUR
ACCEPTANCE BY TYPING YES AT THE PROMPT BELOW, AND THE SOFTWARE WILL
CONTINUE ITS INSTALLATION. IF YOU DO NOT ACCEPT THE TERMS OF THE
AGREEMENT, TYPE NO AT THE PROMPT BELOW, AND THE INSTALLATION WILL
TERMINATE. IF YOU DO NOT ACCEPT THE TERMS OF THE AGREEMENT, PROMPTLY
RETURN THE PRODUCT TO INTERSOLV AND YOUR MONEY WILL BE REFUNDED. PLEASE
NOTE THAT CERTAIN COMPANIES MAY HAVE A SIGNED LICENSE AGREEMENT WITH
INTERSOLV GOVERNING THE USE OF THIS SOFTWARE. IN THAT INSTANCE, THE
LICENSE AGREEMENT ACCOMPANYING THE PRODUCT SHALL BE SUPERSEDED BY THE
SIGNED LICENSE AGREEMENT. FINALLY, PLEASE NOTE THAT INTERSOLV SOFTWARE
IS LICENSED ON AN AUTHORIZED USER BASIS. THIS MEANS A LICENSE FEE MUST
BE PAID FOR EACH PERSON THAT ACCESSES THE SOFTWARE, REGARDLESS OF
WHETHER SUCH ACCESS IS SIMULTANEOUS OR CONCURRENT WITH OTHER USERS.

------------------------------------------------------------------------
Enter YES to accept the above agreement:
YES
The registration file has been updated.
Registration process was successful.

Configuring syslog...

Creating service template...

Adding service...

SequeLink Server Progress Supplement

 Installing SequeLink Server for Progress on UNIX 29

Enter SequeLink service name ? [SLProgress] :

Enter TCP port number ? [4008] :
SequeLink Server Administrator for UNIX
Version 1.7

NewService ended successfully

Press Enter to continue...

------------------------------------------------------------------------
DataDirect SequeLink Server installer:
Installation successfully completed.
------------------------------------------------------------------------

SequeLink Server Progress Supplement

30 Chapter 2 Installing SequeLink Server for Progress

Installing SequeLink Server for Progress

on UNIX (Linking)
Use the following procedure to install SequeLink Server for
Progress (Linking) on UNIX. To view a sample installation script,
see “Sample Installation Script (Linking UNIX)” on page 33.

Transferring the SequeLink Server File

1 Log on to your UNIX server as root.

2 Create a temporary directory to contain the installation files.

For example, to create an installation directory called sqlnk in
the tmp directory, enter:

mkdir /tmp/sqlnk
3 Transfer the SequeLink Server file.

The SequeLink server is delivered in a UNIX tar file called

SLPRO.TAR. Copy or transfer this file from the distribution
media to the temporary installation directory on your UNIX
server.

Important: Transfer the file in binary format. If you transfer

the file in the wrong format, the installation will fail.

Extracting the SequeLink Server File

On the UNIX server, access the tar file you transferred to the
SequeLink installation directory and extract it. Type:

tar -xvf SLPRO.TAR

Note: On Solaris, using the -xvf argument with the tar command
may cause warnings to appear; use the -xof argument instead.
For example, type:

tar -xof SLPRO.TAR

SequeLink Server Progress Supplement

 Installing SequeLink Server for Progress on UNIX 31

Running the Installation Script

When you run the installation script, it prompts you for choices
you need to make and information you need to supply. Default
answers to questions are enclosed within square brackets [ ]. To
accept the default, press the Enter key.

1 On the server, change to the SequeLink temporary

installation directory. For example, enter:

cd /tmp/sqlnk
2 Issue the following command:

ksh install.sh -l SSPPRO.tar

The product information summary appears (this example

shows the information that is displayed when SequeLink
Server for Progress is installed on AIX):
----------------------------------------------------
You are installing the product:

DataDirect SequeLink Server for Progress 7.3x or

higher
Version 4.5 on AIX 4.x
----------------------------------------------------
Do you want to continue (Y/N) ? [Y]
----------------------------------------------------

3 Press Enter to continue the installation.

4 Enter the target directory for SequeLink. If the directory you

enter does not exist, it is created for you.

5 Enter the full path for your Progress DLC directory. The
version of Progress you are running is verified.

A screen appears with the installation information you

supplied.

6 Review the installation information. You can choose to

continue with the installation using these settings, change
any settings, or end the installation.

SequeLink Server Progress Supplement

32 Chapter 2 Installing SequeLink Server for Progress

7 Enter the appropriate choice. The files are extracted and

linked with your Progress Libraries.

The product registration message appears.

8 Enter your name, company name, serial number, and key. The
serial number and key are printed on the Product Registration
Information card that is shipped with the product. If you are
installing an evaluation copy of SequeLink Server for Progress,
leave the Key field empty.

A MERANT Product License Agreement screen appears. The

text on this screen points you to a printed version of the
software license agreement.

9 Enter YES to accept the agreement and continue the

installation.

10 Enter a unique SequeLink service name and an available TCP

port number.

Note: Refer to the SequeLink Server Installation Guide for

information about using port numbers.

A message appears when the installation is complete.

SequeLink Server Progress Supplement

 Installing SequeLink Server for Progress on UNIX 33

Sample Installation Script (Linking UNIX)

The following sample installation script shows SequeLink Server
for Progress installing on AIX using Progress version 7.3D.
# ksh install.sh -l SSPPRO.tar

DataDirect SequeLink Server installer is uncompressing now.

------------------------------------------------------------------------
You are installing the product:

DataDirect SequeLink Server for Progress 7.3x or higher

Version 4.5 on AIX 4.x
------------------------------------------------------------------------
Do you want to continue (Y/N) ? [Y]
------------------------------------------------------------------------
Enter the target directory where you want to install SequeLink.
If this directory does not exist, it will be created for you.
------------------------------------------------------------------------
Enter target directory ? [/usr/sqlnk] : /progress/sqlnk45

Enter the full path of your Progress

DLC directory [/usr/dlc] :
/progress/pro73D/dlc

Detecting Progress version...

echo PROGRESS Version 7.3D01 as of Fri May 24 14:15:10 EST 1996
------------------------------------------------------------------------
Ready to start installation with the following settings:

SequeLink home directory : /progress/sqlnk45

Progress DLC directory : /progress/pro73D/dlc
Progress version : 73D
Link service executables : Yes

You will need approx. 5500 kBytes free diskspace in your SequeLink home
directory (depending on your platform and configuration).
------------------------------------------------------------------------
1) Start installation with these settings
2) Change SequeLink home directory
3) Change Progress DLC directory
4) Change Progress version
9) Abort installation

SequeLink Server Progress Supplement

34 Chapter 2 Installing SequeLink Server for Progress

Enter your choice [1] ?

Extracting file: ./srvcpro.cfg

Extracting files...
Extracting file: /progress/sqlnk45/slsrvcfg
Extracting file: /progress/sqlnk45/slsrvcfg.msg
Extracting file: /progress/sqlnk45/toolkit.sh
Extracting file: /progress/sqlnk45/4_50_00/msg/lediag.msg
Extracting file: /progress/sqlnk45/4_50_00/msg/rldiag.msg
Extracting file: /progress/sqlnk45/4_50_00/msg/prodiag.msg
Extracting file: /progress/sqlnk45/4_50_00/admin/dmprogr.sql
Extracting file: ./iperegister
Extracting file: ./ipemerge
Extracting file: ./ipemsg.msg
Copying file: rscshell to /progress/sqlnk45/rscshell
Extracting file: /progress/sqlnk45/4_50_00/bin/sbld
Extracting file: /progress/sqlnk45/4_50_00/bin/libsetcp.a
Extracting file: /progress/sqlnk45/4_50_00/bin/libslpro.a
Linking services...
ld /lib/crt0.o -s -o slpro_73D /progress/sqlnk45/4_50_00/bin/libslpro.a
/progress/sqlnk45/4_50_00/bin/libsetcp.a /progress/sqlnk45/4_50_00/bin/
libslpro.a /progress/sqlnk45/4_50_00/bin/libsetcp.a -L$ /progress/
pro73D/dlc/probuild/4gl/bklk.o/progress/pro73D/dlc/probuild/4gl/bkset.o
/progress/pro73D/dlc/probuild/4gl/dblg.o /progress/pro73D/dlc/probuild/
4gl/drargs.o /progress/pro73D/dlc/probuild/4gl/drcon.o /progress/pro73D/
dlc/probuild/4gl/drdb.o /progress/pro73D/dlc/probuild/4gl/drdbctl.o /
progress/pro73D/dlc/probuild/4gl/drdbset.o /progress/pro73D/dlc/
probuild/4gl/drmsg.o /progress/pro73D/dlc/probuild/4gl/drmsgw.o /
progress/pro73D/dlc/probuild/4gl/drpfile.o /progress/pro73D/dlc/
probuild/4gl/drppath.o /progress/pro73D/dlc/probuild/4gl/drsetup.o /
progress/pro73D/dlc/probuild/4gl/drsig.o /progress/pro73D/dlc/probuild/
4gl/fd.o /progress/pro73D/dlc/probuild/4gl/fdlist.o /progress/pro73D/
dlc/probuild/4gl/fmeval.o /progress/pro73D/dlc/probuild/4gl/hl.o/
progress/pro73D/dlc/probuild/4gl/hlidynlx.o /progress/pro73D/dlc/
probuild/4gl/hlinocpp.o /progress/pro73D/dlc/probuild/4gl/hlprodsp.o /
progress/pro73D/dlc/probuild/4gl/n1noora.o /progress/pro73D/dlc/
probuild/4gl/n1norms.o /progress/pro73D/dlc/probuild/4gl/n1nosilk.o /
progress/pro73D/dlc/probuild/4gl/nca.o /progress/pro73D/dlc/probuild/
4gl/ncs.o /progress/pro73D/dlc/probuild/4gl/ncsbsd.o /progress/pro73D/
dlc/probuild/4gl/ncslist.o /progress/pro73D/dlc/probuild/4gl/nsutil.o /
progress/pro73D/dlc/probuild/4gl/profcomp.o /progress/pro73D/dlc/
probuild/4gl/profldls.o /progress/pro73D/dlc/probuild/4gl/rlset.o /
progress/pro73D/dlc/probuild/4gl/rntmpio.o /progress/pro73D/dlc/
probuild/4gl/rtfullp.o /progress/pro73D/dlc/probuild/4gl/sldb.o /

SequeLink Server Progress Supplement

 Installing SequeLink Server for Progress on UNIX 35

progress/pro73D/dlc/probuild/4gl/snlkup.o /progress/pro73D/dlc/probuild/
4gl/sqlsmlpi.o /progress/pro73D/dlc/probuild/4gl/sqlsmscv.o /progress/
pro73D/dlc/probuild/4gl/svtstlk.o /progress/pro73D/dlc/probuild/4gl/
tstset.o /progress/pro73D/dlc/probuild/4gl/hliclang.o /progress/pro73D/
dlc/probuild/4gl/dblp.o /progress/pro73D/dlc/probuild/4gl/dbmanb.o /
progress/pro73D/dlc/probuild/4gl/fmsrt.o /progress/pro73D/dlc/probuild/
4gl/bfx.o /progress/pro73D/dlc/probuild/4gl/n2fulhli.o /progress/pro73D/
dlc/probuild/4gl/ncsplain.o /progress/pro73D/dlc/probuild/4gl/hlidyn.o /
progress/pro73D/dlc/probuild/4gl/dbusr.o /progress/pro73D/dlc/probuild/
4gl/dblang.o /progress/pro73D/dlc/probuild/4gl/dblksch.o /progress/
pro73D/dlc/probuild/4gl/dbflushm.o /progress/pro73D/dlc/probuild/4gl/
n1nordb.o /progress/pro73D/dlc/probuild/4gl/n1nocis.o /progress/pro73D/
dlc/probuild/4gl/n1nonis.o /progress/pro73D/dlc/probuild/4gl/n1nowi.o /
progress/pro73D/dlc/probuild/4gl/n1udsf.o /progress/pro73D/dlc/probuild/
4gl/n1nosyb.o /progress/pro73D/dlc/probuild/4gl/n1nobti.o /progress/
pro73D/dlc/probuild/4gl/n1noserv.o /progress/pro73D/dlc/probuild/4gl/
ncspip.o /progress/pro73D/dlc/probuild/4gl/n1vv.o /progress/pro73D/dlc/
probuild/4gl/n1noas4.o /progress/pro73D/dlc/probuild/4gl/sysglb.o /
progress/pro73D/dlc/probuild/4gl/ncsbstrn.o /progress/pro73D/dlc/
probuild/4gl/drdbctrn.o /progress/pro73D/dlc/probuild/4gl/ncstrn.o /
progress/pro73D/dlc/probuild/4gl/nsutltrn.o /progress/pro73D/dlc/
probuild/4gl/upprodbb.o /progress/pro73D/dlc/probuild/4gl/hlsmpat.o /
progress/pro73D/dlc/probuild/4gl/n1nodde.o /progress/pro73D/dlc/
probuild/4gl/n1nodt.o /progress/pro73D/dlc/probuild/4gl/ccread.o /
progress/pro73D/dlc/probuild/4gl/ccxlate.o /progress/pro73D/dlc/
probuild/4gl/fmebase.o /progress/pro73D/dlc/probuild/4gl/n1nosyt.o /
progress/pro73D/dlc/probuild/4gl/n1noodbc.o /progress/pro73D/dlc/
probuild/4gl/n1noas4t.o /progress/pro73D/dlc/probuild/4gl/dbsys.o /
progress/pro73D/dlc/probuild/4gl/mtsys.o /progress/pro73D/dlc/probuild/
4gl/musys.o /progress/pro73D/dlc/probuild/4gl/prsys.o /progress/pro73D/
dlc/probuild/4gl/sfsys.o /progress/pro73D/dlc/probuild/4gl/ncasys.o /
progress/pro73D/dlc/probuild/4gl/qrsys.o /progress/pro73D/dlc/probuild/
4gl/runtime.o /progress/pro73D/dlc/probuild/4gl/dbmgr.o /progress/
pro73D/dlc/probuild/4gl/compiler.o /progress/pro73D/dlc/probuild/4gl/
hlilib.o /progress/pro73D/dlc/probuild/4gl/stlib.o /progress/pro73D/dlc/
probuild/4gl/ut.o -lm -lg -ls -lc -lc
Link of slpro_73D completed

------------------------------------------------------------------------
The software you are installing will now be registered.
If you are installing an evaluation copy, leave the IPE key blank
when asked for.
------------------------------------------------------------------------

SequeLink Server Progress Supplement

36 Chapter 2 Installing SequeLink Server for Progress

INTERSOLV Product Registration

Please enter the following information for proper registration.

Name :
-----------------
YourName

Company :
-----------------
YourCompanyName

Serial Number :
-----------------
YourSerialNr

IPE Key :
-----------------
YourIPEKey

-------------------------------------------
--------- Information entered -------------
-------------------------------------------
Name: YourName
Organization: YourCompanyName
Serial Number: YourSerialNr
IPE Key: YourIPEKey
-------------------------------------------

To change this information enter C. Otherwise select Enter to continue.

------------------------------------------------------------------------

THE USE OF THIS SOFTWARE IS GOVERNED BY THE LICENSE AGREEMENT

ACCOMPANYING THE PRODUCT. YOU SHOULD READ THE AGREEMENT CAREFULLY. IF
YOU AGREE TO ACCEPT THE TERMS OF THIS AGREEMENT, INDICATE YOUR
ACCEPTANCE BY TYPING YES AT THE PROMPT BELOW, AND THE SOFTWARE WILL
CONTINUE ITS INSTALLATION. IF YOU DO NOT ACCEPT THE TERMS OF THE
AGREEMENT, TYPE NO AT THE PROMPT BELOW, AND THE INSTALLATION WILL
TERMINATE. IF YOU DO NOT ACCEPT THE TERMS OF THE AGREEMENT, PROMPTLY
RETURN THE PRODUCT TO INTERSOLV AND YOUR MONEY WILL BE REFUNDED. PLEASE
NOTE THAT CERTAIN COMPANIES MAY HAVE A SIGNED LICENSE AGREEMENT WITH
INTERSOLV GOVERNING THE USE OF THIS SOFTWARE. IN THAT INSTANCE, THE
LICENSE AGREEMENT ACCOMPANYING THE PRODUCT SHALL BE SUPERSEDED BY THE

SequeLink Server Progress Supplement

 Installing SequeLink Server for Progress on UNIX 37

SIGNED LICENSE AGREEMENT. FINALLY, PLEASE NOTE THAT INTERSOLV SOFTWARE

IS LICENSED ON AN AUTHORIZED USER BASIS. THIS MEANS A LICENSE FEE MUST
BE PAID FOR EACH PERSON THAT ACCESSES THE SOFTWARE, REGARDLESS OF
WHETHER SUCH ACCESS IS SIMULTANEOUS OR CONCURRENT WITH OTHER USERS.

------------------------------------------------------------------------
Enter YES to accept the above agreement:
YES
The registration file has been updated.
Registration process was successful.

Configuring syslog...

Creating service template...

Adding service...
Enter SequeLink service name ? [SLProgress] :
Enter TCP port number ? [4008] :
SequeLink Server Administrator for UNIX
Version 1.7

NewService ended successfully

Press Enter to continue...

------------------------------------------------------------------------
DataDirect SequeLink Server installer:
Installation successfully completed.
------------------------------------------------------------------------

SequeLink Server Progress Supplement

38 Chapter 2 Installing SequeLink Server for Progress

SequeLink Server Progress Supplement

 39

3 Administering SequeLink
Server for Progress

This chapter contains the following sections that are specific to

administering SequeLink Server for Progress:

■ “SequeLink Functionality with Progress Databases” on

page 40

■ “Using Progress-specific Settings” on page 41

■ “Data Types” on page 48

■ “Using Hyphenated Table and Column Names” on page 49

■ “Using Views” on page 50

■ “Using Dates” on page 51

■ “Using the SequeLink CAT with Progress” on page 53

■ “Using the SequeLink Dictionary Manager” on page 56

■ “Using Multiple Progress Databases” on page 58

■ “Using Array Columns (Extents)” on page 61

For additional information, refer to the SequeLink

Administrator’s Guide.

SequeLink Server Progress Supplement

40 Chapter 3 Administering SequeLink Server for Progress

SequeLink Functionality with Progress

Databases
Table 3-1 outlines the functionality available to the SequeLink
ODBC Driver, SequeLink OLE DB Provider, and SequeLink JDBC
Driver with Progress databases.

Table 3-1. SequeLink Functionality with Progress

Support Description
Binary large object support None
Character large object support None
Cursor commit behavior Close
Cursor rollback behavior Close
Cursor types Read, read/write, no-hold
Maximum number of concurrent
open statements 30
Catalog support None
Stored procedure support None
Transaction isolation levels Read uncommitted, read
committed
Convert functions None
Date/Time functions CURDATE, DAYOFMONTH,
DAYOFWEEK, MONTH, YEAR
Numeric functions ABS, LOG, LOG10, RAND,
ROUND, SQRT
String functions ASCII, CHAR, CONCAT, LEFT,
LTRIM, LENGTH, LCASE, REPEAT,
REPLACE, RTRIM, SPACE,
SUBSTRING, UCASE

SequeLink Server Progress Supplement

 Using Progress-specific Settings 41

Table 3-1. SequeLink Functionality with Progress (cont.)

Support Description
System functions DBNAME, USERNAME
Outer join support Progress 7: no support
Progress 8 and higher: Support
provided in addition to native
Progress out join syntax
Note: Progress 8 and 9 SQL does
not allow users to combine
equi-joins and outer joins. The
Progress native syntax must be
used for mixing inner and outer
joins.

Using Progress-specific Settings

The following settings are specific to Progress. Their default
values are listed as they appear in the SequeLink Server
Configuration Resource. The setting name is always prefixed by
PRO_.

For more information about settings, refer to the SequeLink

Administrator’s Guide.

PRO_ReadOnly = NO

If set to YES, only SQL commands starting with the following

parameters are accepted. All other statements are refused:

■ Select
■ Connect
■ Disconnect

SequeLink Server Progress Supplement

42 Chapter 3 Administering SequeLink Server for Progress

PRO_NotNull = NO

If set to YES, the Create Table statement is changed so that all

columns for that table are created with the Not Null option. This
option is useful when you want to add unique indexes to tables
exported from client applications. A unique index can only be
created if the columns in that index are all created with the Not
Null option.

If you do not want to have the Not Null option automatically

added, use the default value NO.

PRO_ShowIndexes = YES

If set to NO, no index information is returned when using data

dictionary statements.

PRO_ShowViews = NO

If set to YES, information about views is returned when using

data dictionary statements. This setting increases the complexity
of the SQL statement and the response of the data dictionary
calls SQLTables and SQLColumns. It is recommended that this
setting be set to NO unless view support is necessary.

For more information about views, see “Using Views” on page 50

PRO_ShowTables = ALL

If set to ALL, every table and view defined in the database are
returned when using the data dictionary call for returning tables.

If set to USER, only the tables and views the user can access are
returned when using the data dictionary call for returning tables.

PRO_ShowHiddenTables = YES

If set to YES, all tables (including hidden ones) are returned when
using the data dictionary call for returning tables.

If set to NO, hidden tables are not returned.

SequeLink Server Progress Supplement

 Using Progress-specific Settings 43

PRO_ShowRECID = NO

If set to NO, the SpecialColumns data dictionary call returns the

primary setting for the table.

If set to YES, the RECID pseudocolumn is returned.

PRO_DBExcludeList =

Use this setting to specify a comma-separated list of Progress

databases that you do not want data dictionary information
from.

Note: Do not specify your default Progress database. The default

Progress database is normally the first database accessed.

PRO_MultipleErrors = YES

If set to YES, the application uses multiple error message calls to

retrieve all the error messages.

If set to NO, multiple Progress error messages are returned as one

error message by the SequeLink server.

PRO_OuterJoins = YES

If set to NO, SequeLink Server for Progress reports that outer

joins are not supported. This allows some tools to join data
locally, thereby avoiding the Progress limitation of mixing
equi-joins and outer joins.

PRO_DecimalFunction_Precision = 30
PRO_DecimalFunction_Scale = 10

These settings are defined as follows:

■ Precision: The maximum number of significant digits

displayed.

■ Scale: The number of digits displayed to the right of the

decimal point.

SequeLink Server Progress Supplement

44 Chapter 3 Administering SequeLink Server for Progress

Using these settings, the scale and precision used by SequeLink

for functions on numeric columns (for example: SUM, division) is
configured. By default, Progress returns a precision of 7 and scale
of 2. In many cases, this is not sufficient and must be amended.

PRO_Character_Length_Fix = 240

If an operation is done on a string, the resulting string is

described by Progress as having a length of 8 characters. Using
this setting, the described value can be increased or decreased to
the specified setting value.

PRO_RowCount_Report1 = YES

Progress is unable to determine how many records are updated

or deleted with an SQL statement. Returning the unknown count
of -1 results in problems with some programs. If this setting is set
to YES, 1 is reported as the rowcount if Progress returns the
unknown count.

PRO_ReturnUsername = YES

If set to YES, the SQLGetInfo(SQL_USER_NAME) returns the user

name used to connect to Progress. However, some programs use
this user name to qualify table names (for example, user.table). In
this case, set the value to NO and no user name is returned.

PRO_TransClose_Level = 0
PRO_TransClose_Direction = RollBack

When using a query program against a Progress database, the

before image (bi) file can grow quite large. This occurs when
query programs do not end transactions by sending a commit or
rollback, thereby consuming large amounts of bi space.

SequeLink Server Progress Supplement

 Using Progress-specific Settings 45

A solution for this extensive bi growth is provided with these

two settings. SequeLink Server issues a Rollback or Commit
(depending on the setting for PRO_TransClose_Direction) in the
following two situations:

■ PRO_TransClose_Level is set to 1 with the following

conditions:

• No Update, Insert, or Delete statements have been

sent since the last commit/rollback.
• The cursor is closed.
• No other cursors remain open.
■ PRO_TransClose_Level is set to 2 with the following
conditions:

• The cursor is closed.

• No other cursors remain open.
PRO_RecordLock_Default = NO

This setting governs the default record locking when executing

select statements. The possible values are:

■ NO: No locks are used when retrieving data. Rows that are
locked by other users are read, and data from uncommitted
transactions is visible.

The SequeLink Server adds For Read Only to the SQL select
statements.

■ Shared: Shared locks are used when retrieving data. A row is

not read if another application holds an exclusive lock on it,
and data from uncommitted transactions is not visible.

The SequeLink Server does not alter the SQL select

statements.

SequeLink Server Progress Supplement

46 Chapter 3 Administering SequeLink Server for Progress

■ Exclusive: Exclusive locks are used when retrieving data. A

row is not read if another application holds an exclusive lock
on it. Data from uncommitted transactions is not visible.

The SequeLink Server adds For Update to the SQL select

statements.

In addition to setting these values, you can force the record

locking option manually by specifying the For Read Only clause or
the For Update clause in the SQL statements. Records being
inserted, updated, or deleted are always locked exclusively.

Note: You can encounter large numbers of records being locked

when using Shared or Exclusive locks. In this case, you can
increase the -L Progress parameter on the server and the client.

PRO_RecordLock_Maximum = NO

This setting governs the maximum allowed record locking an

application can ask for using ODBC, OLE DB, or JDBC calls.

The settings are the same as those for the

PRO_RecordLock_Default setting listed above.

PRO_DataBaseConnection =

When this setting is empty, the SequeLink client must specify the
database connection parameters. If this setting is not empty, it
must contain the Progress database connection parameters,
which will overrule any client database connection parameters.

For more information on the supported database connection

parameters, see “Using the SequeLink CAT with Progress” on
page 53.

PRO_ESQLSettings =

When this setting is empty, the SequeLink client must specify any
ESQL/C settings. If this setting is not empty, it should contain the
Progress ESQL/C parameters. These parameters overrule any
client ESQL/C settings.

SequeLink Server Progress Supplement

 Using Progress-specific Settings 47

For more information on the possible settings, see “Using the

SequeLink CAT with Progress” on page 53.

PRO_UserListTable =

This setting allows you to configure additional user

authorization by validating the user against a list of users stored
in a Progress table.

To configure additional user authorization, follow these steps:

1 Create a table in your Progress database containing the

character column Sqlnkusers with a minimum size of 32
characters.

2 Insert the allowed users into the table.

3 Specify the tablename (or logical database.tablename) in the

PRO_UserListTable setting.

If this setting is not empty, SequeLink Server verifies upon

connection if the user (operating system or _user user) is present
in the table. If the user is not found, the SequeLink connection is
refused.

SequeLink Server Progress Supplement

48 Chapter 3 Administering SequeLink Server for Progress

Data Types
Table 3-2 shows how Progress SQL data types map to ODBC data
types.

Table 3-2. Data Types

Progress SQL Data Type ODBC Data Type

character SQL_VARCHAR
numeric SQL_NUMERIC
decimal SQL_DECIMAL
integer SQL_INTEGER
smallint SQL_SMALLINT
float SQL_FLOAT
real SQL_REAL
double SQL_DOUBLE
date SQL_DATE
logical SQL_BIT

SequeLink Server Progress Supplement

 Using Hyphenated Table and Column Names 49

Using Hyphenated Table and Column Names

Progress allows hyphens in table and column names. In SQL,
however, a hyphen is interpreted as a minus sign. Problems can
arise, therefore, if hyphenated table and column names are used
in Progress SQL.

To avoid these problems, use one of the following methods:

■ Escape the hyphens.

If you put the Progress escape character (backslash) before

the hyphen, the Progress SQL interpreter does not interpret
the hyphen as a minus sign. Instead, hyphens are considered
part of the table and/or column name. For example:

select order\-no from order\-line

■ Use double quotes with table and column names.

Put double quotes around table and column names. The

SequeLink translator removes the double quotes and inserts
the Progress escape character before any hyphens in table
and column names. For example:

select "order-no" from "order-line"

This SQL statement is changed by the SequeLink Progress
translator to the following:

select order\-no from order\-line

Since SequeLink Server for Progress returns a double quote
for the ODBC SQL_IDENTIFIER_QUOTE_CHAR, most ODBC
applications place double quotes around table and column
names allowing them to function correctly.

SequeLink Server Progress Supplement

50 Chapter 3 Administering SequeLink Server for Progress

■ Use the Progress ESQL No Padding parameter (-esqlnopad).

If you put the -esqlnopad parameter in the settings field in

the SequeLink CAT, the Progress SQL interpreter only
interprets hyphens as minus signs if they are surrounded by
two empty spaces (blank-padded). For example:

select order-no - order-amount from order-line

The hyphens in order-no, order-amount, and order-line
are not interpreted as minus signs. The hyphen between
order-no and order-amount is interpreted as a minus sign
since it is blank-padded.

Using Views
Progress allows the creation of views in a database. SequeLink
Server for Progress supports the use of these views, but it requires
some special considerations.

Configure the return of view information with the

PRO_ShowViews setting in the SequeLink Server Configuration
Resource.

It is recommended that you change this setting to YES only if

view information is essential. The reasons for this
recommendation are:

■ Many Progress databases do not contain views.

■ The queries for listing tables and columns are more complex
and, in turn, slower if information about views must be
displayed.

SequeLink Server Progress Supplement

 Using Dates 51

Using Dates
Progress dates are used by SequeLink Server for Progress in a
number of ways, as described in the following sections.

Date Input Using Literals

If you specify the date as literals, follow these guidelines:

■ Unlike most other SQL implementations, the date value must

not be surrounded by single quotes.

■ The date must be in the form mm/dd/yy.

■ Since a forward slash is interpreted by SQL as the divide by

operator, it must be preceded by the Progress escape
character (backslash).

For example, to select the records from table Emp where the hire
date is greater than 17 Dec 1980, use the following statement:

select *
from emp
where hiredate > 12\/17\/1980

If the -esqlnopad parameter is used, the following statement

produces the same result:

select *
from emp
where hiredate > 12/17/1980

Note: The -esqlnopad parameter in the CAT settings field can be

used as described in “Using Hyphenated Table and Column
Names” on page 49.

SequeLink Server Progress Supplement

52 Chapter 3 Administering SequeLink Server for Progress

Date Input Using Literals and the

SequeLink Translator
The Progress SequeLink SQL translator allows you to use a date
escaping method to specify date literals according to the ODBC
extended SQL method. To specify a date literal, use the following
syntax:

{d 'yyyy-mm-dd'}

For example, to select the records from table Emp where the hire
date is greater than 17 Dec 1980, use the following statement:

select *
from emp
where hiredate > {d '1980-12-17'}

The statement is translated into the following and passed to the

Progress database:

select *
from emp
where hiredate > 12\/17\/1980

This method is used by most ODBC, OLE DB, and JDBC

applications.

SequeLink Server Progress Supplement

 Using the SequeLink CAT with Progress 53

Using the SequeLink CAT with Progress

The SequeLink Connect Administration Tool (CAT) allows you to
create, modify, delete, and test SequeLink data sources.

For additional information about the SequeLink CAT, refer to the

SequeLink Administrator’s Guide.

Service Parameters for Progress

To use a Progress data source with SequeLink, a user must supply
the following parameters:

Field Req/Opt Prompt Value Description

Name Required <service> or SequeLink
<prompt> service name
Database Required <name> or Database
<prompt> connection
parameters
Username Optional <user> or <prompt> Database user
name
Password Optional <password> or Database
<prompt> password
Settings Optional <settings> or ESQL/C login
<prompt> parameters

SequeLink service name: This identifies the SequeLink service.

The default is SLProgress. Encryption and compression are
enabled through the SequeLink Service Name.

Database connection parameters: This allows you to specify

database connection parameters. Consult your Progress
documentation for a list of supported database connection
parameters and their definitions.

SequeLink Server Progress Supplement

54 Chapter 3 Administering SequeLink Server for Progress

To connect to Progress databases (called Demo and Sports in the

examples below), this specification can be one of the following:

■ To connect to one database, specify the name and location of

that database on the server. For example:
/usr/progress/dbs/demo

■ To connect to both databases simultaneously, specify the

names and locations of both databases on the server. For
example:
/usr/progress/dbs/demo -db /usr/progress/dbs/sports

Note: The default Progress database is normally the first

database accessed. In the example above, it is the Demo
database.

■ To connect to one of the databases using network

parameters, specify the name and location of the database on
the server as well as any additional Progress connection
parameters. For example:
usr/progress/dbs/demo -H localhost -S dbservice

■ If you maintain the connection settings in a Progress

parameter file, specify -pf followed by the name and
location of the parameter file on the server. For example:
-pf /usr/sqlnk/connect.pf

Note: The Progress parameter file must reside on the server.

Database user name: This is used to connect to a Progress

database with the Username parameter (-U); otherwise leave it
blank.

Note: This parameter is used only if you have specified one

database in the Database field.

Database password: This is used to connect to a Progress

database with the Password parameter (-P); otherwise leave it
blank.

SequeLink Server Progress Supplement

 Using the SequeLink CAT with Progress 55

Note: This parameter is used only if you have specified one

database in the Database field.

ESQL/C login parameters: This allows you to specify the Progress

ESQL/C parameters. Consult your Progress documentation for a
list of supported Progress ESQL/C parameters and their
definitions.

This parameter has the following values:

■ Null string: No additional ESQL/C parameters are specified.

■ ESQL/C Client Settings: Progress Client parameters can be

specified. Commonly used parameters include:

• ESQL no padding (-esqlnopad): This parameter is useful if

you have hyphens in column or table names. If used,
Progress SQL treats the hyphen as a minus sign only if it is
surrounded by one or more spaces. For more information,
see “Using Hyphenated Table and Column Names” on
page 49.

• ANSI SQL (-Q and -Q2 parameters): These parameters

provide ANSI SQL support for strings and decimals.

Important: The following parameters should not be used:

• Date Format (-d): SequeLink Server for Progress sets and

expects this parameter to be in the dmy format.

• European Numeric Format (-E): SequeLink Server for

Progress sets and expects this parameter to be in the
American Format, using a point as a decimal separator.

SequeLink Server Progress Supplement

56 Chapter 3 Administering SequeLink Server for Progress

Using the SequeLink Dictionary Manager

The SequeLink Shadow Data Dictionary (SSDD) is supported with
SequeLink Server for Progress. Maintenance of the SSDD is done
with the SequeLink Dictionary Manager. The following sections
contain Progress-specific information. For more information
about the SequeLink Dictionary Manager, refer to the SequeLink
Administrator’s Guide.

SQL Scripts
The file containing the SQL scripts for the SSDD creation is named
DMPROGR.SQL. It can be found in the /etc directory on your
distribution CD.

SSDD Location
The shadow dictionary is created in your default Progress
database.

Note: The default Progress database is normally the first database

accessed.

Because tables are created in your database at the time you run
the SSDD, the following must be considered:

■ Whether you are the only user connected to the database

■ Whether your Progress 4GL programs need recompiling

because the database CRC changed

SequeLink Server Progress Supplement

 Using the SequeLink Dictionary Manager 57

Schemas and Catalogs

When using SequeLink Server for Progress and the SequeLink
Dictionary Manager, the SCHEMA field must contain the
Progress logical database name containing the SSDD tables. The
CATALOG field is not used and must be left empty.

DataDictionaryOwner and
DataDictionaryQualifier
When using the SSDD with SequeLink Server for Progress, the
DataDictionaryOwner field in the SequeLink Server
Configuration Resource is used for the Progress logical database
name containing the SSDD. The DataDictionaryQualifier field is
not used and must be left blank.

SequeLink Server Progress Supplement

58 Chapter 3 Administering SequeLink Server for Progress

Using Multiple Progress Databases

Progress allows connections to multiple databases at the same
time. SequeLink Server for Progress supports this functionality.

Only one SequeLink connection is used when connecting to

multiple Progress databases. Database connection parameters are
specified in:

■ The CAT database field for ODBC and OLE DB clients

■ The database attribute in the URL for JDBC clients

■ The PRO_DatabaseConnection setting in the SequeLink Server

Configuration Resource for server-side maintenance

Connecting to multiple Progress databases using SequeLink

Server for Progress is done in the following ways:

■ Specifying multiple databases as database connection

parameters

If you specify more than one Progress database as database

connection parameters, SequeLink Server for Progress
connects to the specified databases.

For example, using the following parameters connects you to

both the demo and sports databases:
/usr/progress/dbs/demo -db /usr/progress/dbs/sports

■ Specifying a Progress parameter file as a database connection

parameter

You can create a Progress parameter file on the server that

specifies connections to more than one Progress database. If
you then specify that parameter file as a database connection
parameter, SequeLink Server for Progress uses the parameter
file to connect to the databases. For example:
-pf /usr/sqlnk/params.pf

SequeLink Server Progress Supplement

 Using Multiple Progress Databases 59

■ Using Connect and Disconnect SQL statements

You can use the Connect and Disconnect SequeLink for

Progress keywords. Progress ESQL/C has functions to connect
and disconnect from a database. These functions can be used
with SequeLink Server for Progress through ODBC or JDBC
calls to execute an SQL statement. If the SQL statement used
in the call starts with the keywords Connect or Disconnect,
the Progress ESQL/C functions are called to connect or
disconnect from a database.

For example, using the following statement in an ODBC

program connects you to the Sports database at the given
location:
Connect /usr/progress/dbs/sports

Similarly, the following statement disconnects you from the

Sports database:
Disconnect sports

Using Multiple Progress Databases

with SQL
When connecting to multiple databases, qualify the table name
with the database name. For example, if you are connected to
both the Demo and Sports databases, the following statement
retrieves data from both:

select e.ename , d.dname

from demo.emp e , sports.dept d
where e.deptno = d.deptno

SequeLink Server Progress Supplement

60 Chapter 3 Administering SequeLink Server for Progress

Data Dictionary Statements and

Multiple Connections
SequeLink Server for Progress Data Dictionary statements return
information from a maximum of twenty connected databases.
The Schema/Owner field is used to store the Progress database
name.

If you want to exclude data dictionary information from certain

databases, specify those logical database names in the
PRO_DBExcludeList parameter in the Progress SequeLink
Initialization File. For more information on this parameter, see
“Using Progress-specific Settings” on page 41.

When using SequeLink Server for Progress, the SQLColumns call

does not allow for search patterns in the Schema/Owner field.
The application should supply the database name in the
Schema/Owner field with the SQLColumns call. If the table
Schema/Owner field is not supplied, only column information
from the default database is returned.

SequeLink Server Progress Supplement

 Using Array Columns (Extents) 61

Using Array Columns (Extents)

Progress supports array columns, referred to by Progress as
extents, in a table. When creating columns, you can create array
columns by specifying the number of arrays needed in the extent
field (using only non-SQL tools).

To select data from an array column, specify which array element

you need. For example, to select the fifth element from the
column Monthly, use the following statement from Demo.item:

select monthly[5] from demo.item

Note: SequeLink Server for Progress reads braces ({ }) as well as

square brackets.

Data Dictionary Statements and Array

Columns
SequeLink Server for Progress Data Dictionary statements return
information from array columns.

The SQLColumns call returns the elements from the array column
as separate columns with the array index appended between
braces.

Note: Braces are used instead of square brackets because some

ODBC applications return errors when square brackets are
encountered in column names.

SequeLink Server Progress Supplement

62 Chapter 3 Administering SequeLink Server for Progress

SequeLink Server Progress Supplement

 63

4 Using the SequeLink JDBC

Driver

This chapter describes the SequeLink JDBC Driver’s URL Syntax

and service attributes for Progress. For more information on
SequeLink Java Edition, refer to the SequeLink JDBC Driver
Reference.

Specifying Connection URLs

Use the following syntax:

■ Port: The default port number for SequeLink for Progress is

4008.

■ Type: The type for the Progress service is [Progress].

SequeLink Server Progress Supplement

64 Chapter 4 Using the SequeLink JDBC Driver

Service Attributes for Progress

The following table lists information about the service attributes
for Progress:

Attribute Req/Opt Description

User Required Host user name
Password Required Host password
Database Optional Database connection
parameters
DBMSUser Optional Database user name
DBMSPassword Optional Database password
Settings Optional ESQL/C login parameters

Host user name: This is used to specify the user’s host user name.

Host password: This is used to specify the user’s host password.

Database connection parameters: These allow you to specify the

database connection parameters. Consult your Progress
documentation for a list possible database connection
parameters and their definitions.

To connect to Progress databases (called Demo and Sports in the

example below), this attribute can be one of the following:

■ To connect to one database, specify the name and location of

that database on the server. For example:
/usr/progress/dbs/demo

■ To connect to both databases simultaneously, specify the

names and locations of both databases on the server. For
example:
/usr/progress/dbs/demo -db /usr/progress/dbs/sports

SequeLink Server Progress Supplement

 Service Attributes for Progress 65

Note: The default Progress database is normally the first

database accessed. In the example above, it is the Demo
database.

■ To connect to one of the databases with a user name,

password, and additional Progress connection parameters,
specify the name, location of the database on the server, and
any additional Progress connection parameters. For
example:
/usr/progress/dbs/demo -U demo -P demo

■ If you maintain the connection settings in a Progress

parameter file, specify -pf followed by the name and
location of the parameter file on the server. For example:
-pf /usr/sqlnk/connect.pf

Note: This Progress parameter file must reside on the server.

Database user name: This is used to connect to a Progress

database with the Username parameter (-U); otherwise leave it
blank.

Note: This is used only if you have specified one database in the
Database field.

Database password: This is used to connect to a Progress

database with the Password parameter (-P); otherwise leave it
blank.

Note: This is used only if you have specified one database in the
Database field.

ESQL/C login parameters: This allows you to specify the Progress

ESQL/C parameters. Consult your Progress documentation for a
list of supported Progress ESQL/C parameters and their
definitions.

SequeLink Server Progress Supplement

66 Chapter 4 Using the SequeLink JDBC Driver

This attribute has the following values:

■ Null string: No additional ESQL/C parameters are specified.

■ ESQL/C Client Settings: Progress Client parameters can be

specified. Commonly used parameters include:

• ESQL no padding (-esqlnopad): This parameter is useful if

you have hyphens in column or table names. If used,
Progress SQL treats the hyphen as a minus sign only if it is
surrounded by one or more spaces. For more information,
see “Using Hyphenated Table and Column Names” on
page 49.

• ANSI SQL (-Q and -Q2 parameters): These parameters

provide ANSI SQL support for strings and decimals.

Important: The following parameters should not be used:

• Date Format (-d): SequeLink Server for Progress sets and

expects this parameter to be in the dmy format.

• European Numeric Format (-E): SequeLink Server for

Progress sets and expects this parameter to be in the
American Format, using a point as a decimal separator.

SequeLink Server Progress Supplement