db_command

Sends a DBMS driver command.

Available in:

Apps (win)	Apps (char)	Reportwriter	RPC	Standalone PL
X	X	X	X	X

Syntax

void db_command(command,spec)
int             command
string          spec

Description

Sends the specified command to the DBMS driver. The command values are defined in the trim.h file. The spec string contains the values appropriate for the command.

command

specifies the DBMS driver command.

Cmd	Parms	DBMS	Duration	Default	Description
0	n	All	Session	Differs	Set resource timeout to n seconds.
1	yes\|no	Sybase	Session	No	Use a single PID within a transaction.
3	dbname	Sybase	Session	N/A	Use database dbname.
4	language	Oracle	Session	See oparse() or StmtPrepare	Set SQL syntax and datatypes.
5	yes\|no	All	Session	no	Return raw datetime.
7	dty	Oracle	Session	1	Map VORTEX char type to Oracle type dty.
8	N/A	All	Call	N/A	Lock VORTEXaccelerator slave on next call.
9	yes\|no	Sybase	Session	No	Return single blank varchar as blank instead of null.
10	yes\|no	Sybase	Session	No	Batch INSERT, UPDATE, and DELETE statements.
11	on\|off	GENESIS	Session	off	Automatically commit after every SQL statement.
12	N/A	Informix	Until next use	N/A	Sets the current connection to dormant.
13	N/A	Oracle	Call	N/A	Returns the address of the LDA on Oralce 7 only.
14	value	TRIMrpc	Call	N/A	Cause a raise(value) error condition.
15	message	TRIMrpc	Call	N/A	Return the message as an error.
16	N/A	VORTEXwebd	Call	N/A	Execute a temporary release.
17	value	GENESIS/SDMS	Session	N/A	Call sdms2_initx() using value.
18	n	GENESIS	Session	2	Set query timeout to n seconds
19	n	GENESIS/SDMS	Session	2	Set fetch timeout to n seconds
20	yes\|no	ODBC	Session	connection default	Use dynamic cursors.
21	N/A	GENESIS	Session	N/A	Return GENESIS syntax level.
22	yes\|no	All	Session	yes	Return ROWID on insert.

spec

specifies the command modifiers.

Examples

Notify the DBMS to not return the inserted row's ROWID value.

db_command(db_cmd_return_rowid,"NO");
exec_sql("insert into staff values(:1,:2,:3,:4,:5,:6,:7)",ll);
db_command(db_cmd_return_rowid,"YES");