Release 10.1A: OpenEdge Data Management:
SQL Development

> ## Connecting using SQL Explorer

> SQL Explorer is a Java-based tool you can use to execute OpenEdge SQL statements, shell commands, and client control commands.

> | To start the SQL Explorer tool and connect to an OpenEdge database, execute a command using one of the following syntax examples:

>     sqlexp -db database-name -S port | service-name -H host -user userid -password
>     password

>     sqlexp –url jdbc:datadirect:openedge://host:port;databaseName=db_name;
>     servicename=service_name -user userid -password password

> Notes: The `–db` preceding the `database-name` is optional.
> `host` is optional and defaults to `localhost`, which is valid only for nonremote databases.
> The `user` is optional and defaults to the current user. The user’s password is also optional and defaults to null.
> The current user, when using the default, must be the user who created the OpenEdge database.
> In Windows and on UNIX, a user and password are optional until the first user is created in the OpenEdge database.
> Once the `CREATE USER` statement is executed, a user and password must be provided.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095