1.1

------------------------
40 |Forty
protocol
Specifies the protocol, as a String, for establishing connections and automatically loads the appropriate driver.
Syntax
PROTOCOL
String
[ AS
Identifier
]
Description
Specifies the protocol, as a String, for establishing connections and automatically loads the appropriate driver.
protocol is the part of the database connection URL syntax appropriate for your environment, including the
JDBC protocol to connect to an external database.
Providing a protocol allows you to use a shortened database connection URL for connections. You can provide
only the database name (and a subsubprotocol name if needed) instead of the full protocol. In addition, you do
not need to use the driver on page 430 command or specify a driver at start-up, since the driver is loaded
automatically.
If you name the protocol, you can refer to the protocol name in the connect on page 427 command.
Example
sqlf> protocol 'jdbc:derby:';
sqlf> connect '//armenia:29303/myDB;create=true';
sqlf> connect '//armenia:29303/myDB2;create=true';
sqlf(CONNECTION1)>
relative
Moves the cursor to the row that is int number of rows relative to the current row, then fetches the row.
Syntax
RELATIVE
int Identifier
Description
After the cursor is created with the get scroll insensitive cursor on page 434 command, moves the cursor to the
row that is int number of rows relative to the current row, then fetches the row. It displays a banner and the
values of the row.
441
sqlf Interactive Commands