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
db_cmd_timeout	n	All	Session	Differs	Set resource timeout to n seconds.
db_cmd_singlepid	yes\|no	Sybase	Session	No	Use a single PID within a transaction.
db_cmd_usedb	dbname	Sybase	Session	N/A	Use database dbname.
db_cmd_language	language	Oracle	Session	See oparse() or StmtPrepare	Set SQL syntax and datatypes.
db_cmd_raw_datatype	yes\|no	All	Session	no	Return raw datetime.
db_cmd_char	dty	Oracle	Session	1	Map VORTEX char type to Oracle type dty.
db_cmd_lock	N/A	All	Call	N/A	Lock VORTEXaccelerator slave on next call.
db_cmd_onebyte	yes\|no	Sybase	Session	No	Return single blanbk varchar as blank instead of null.
db_cmd_multistmt	yes\|no	Sybase	Session	No	Batch INSERT, UPDATE, and DELETE statements.
db_cmd_autocommit	on\|off	GENESIS	Session	off	Automatically commit after every SQL statement.
db_cmd_dormant	N/A	Informix	Until next use	N/A	Sets the current connection to dormant.
db_cmd_getlda	N/A	Oracle	Call	N/A	Returns the address of the LDA on Oracle 7 only.
db_cmd_raise	value	TRIMrpc	Call	N/A	Cause a raise(value) error condition.
db_cmd_error	message	TRIMrpc	Call	N/A	Return the message as an error.
db_cmd_tmp_release	N/A	VORTEXwebd	Call	N/A	Execute a temporary release.
db_cmd_worm_auth	value	GENESIS/SDMS	Session	N/A	Call sdms2_initx() using value.
db_cmd_timeout_query	n	GENESIS	Session	2	Set query timeout to n seconds
db_cmd_timeout_fetch	n	GENESIS/SDMS	Session	2	Set fetch timeout to n seconds
db_cmd_dyn_cursor	yes\|no	ODBC	Session	connection default	Use dynamic cursors.
db_cmd_syntax_level	N/A	GENESIS	Session	N/A	Return GENESIS syntax level.
db_cmd_return_rowid	yes\|no	All	Session	yes	Return ROWID on insert.
db_cmd_new_blobs	yes\|no	Oracle	Session	no	Use BLOB/CLOB instead of LONG RAW/LONG.
db_cmd_ro_cursor	yes\|no	ODBC	Session	no	Use read-only cursors.
db_cmd_cursor_type	cursor type	ODBC	Session	SQL_CURSOR_TYPE_DEFAULT	Set the ODBC cursor type to one of: SQL_CURSOR_STATIC SQL_CURSOR_KEYSET_DRIVER SQL_CURSOR_DYNAMIC SQL_CURSOR_FORWARD_ONLY.
db_cmd_txn_isolevel	isolation type	ODBC	Session	N/A	Set the ODBC isolation type to one of: SQL_TXN_READ_UNCOMMITTED SQL_TXN_READ_COMMITTED SQL_TXN_REPEATABLE_READ SQL_TXN_SERIALIZABLE.
db_cmd_scroll	scroll option	Oracle Informix DB2 AdabasD ODBC	Cursor	N/A	Set the scrolling direction or position of a scrollable cursor (see VTXOPEN). Scroll options are defined in vortex.h as TDB_SMD_SCROLL_xx.
db_cmd_hostname	N/A	All	N/A	N/A	Return the hostname of the machine where the DBMS driver is running.
db_cmd_fqcolname	yes\|no	All	Session	no	Return fully qualified column names.
db_cmd_free_locks	N/A	ODBC	Cursor	N/A	Free the locks held by the cursor.
db_cmd_nounichar	yes\|no	ODBC SQL Server	Session	no	Describe W[VAR]CHAR columns as CHAR.
db_cmd_zerolen_null	yes\|no	ODBC SQL Server	Session	no	Force zero length parameter strings to be bound as NULL.
db_cmd_exio_rs	yes\|no	DB2	Session	no	Process stored procedure cursors with EXIO.
db_cmd_drv_config	N/A	N/A	N/A	N/A	Internal use only.
db_cmd_bld_min	n	PostgreSQL	Session	10	Minimum numbers of rows for bulk insert.
db_cmd_max_col_len	n	PostgreSQL	Session	65535	maximum column length.
db_cmd_set_con_attr	attr value	ODBC DB2 SQL Server	Session	N/A	Set the connection attribute to value.
db_cmd_get_con_attr	attr	ODBC DB2 SQL Server	Session	N/A	Retrieve the value for the connection attribute.
db_cmd_desc_parms	yes\|no	SQL Server	Session	no	Use SQLDescribeParam for parameters.
db_cmd_desc_lobs	yes\|no	All	Session	no	Describe LOB select list columns as BLOB/CLOB; otherwise max 65k BINARY/CHAR.

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");