db_stop_engine Function

Stops execution of the database server.

Syntax

unsigned int db_stop_engine( SQLCA * sqlca, char * parms );

Parameters

sqlca – A pointer to a SQLCA structure.
parms – A null-terminated string containing a semicolon-delimited list of parameter settings, each of the form KEYWORD=value. For example:
```
"UID=DBA;PWD=sql;DBF=c:\\db\\mydatabase.db"
```

Returns

Non-zero if successful; 0 otherwise.

Remarks

The steps carried out by this function are:

Look for a local database server that has a name that matches the ServerName (Server) parameter. If no ServerName is specified, look for the default local database server.
If no matching server is found, this function returns with success.
Send a request to the server to tell it to checkpoint and shut down all databases.
Unload the database server.

By default, this function does not stop a database server that has existing connections. If the Unconditional=yes connection parameter is specified, the database server is stopped regardless of existing connections.

A C program can use this function instead of spawning dbstop. A return value of TRUE indicates that there were no errors.

The use of db_stop_engine is subject to the privileges set with the -gk server option.