ns_ext

Overview

Perform external database driver operations

Syntax

ns_ext cpfrom dbhandle file1 file2

ns_ext cpto dbhandle file1 file2

ns_ext dbtype dbhandle

ns_ext gettypes dbhandle

ns_ext identify dbhandle

ns_ext isremote dbhandle

ns_ext mktemp dbhandle

ns_ext number dbhandle

ns_ext ping dbhandle

ns_ext resultid dbhandle

ns_ext resultrows dbhandle

ns_ext rm dbhandle file

ns_ext setmaxrows dbhandle limit

ns_ext traceoff dbhandle

ns_ext traceon dbhandle file

Description

The ns_ext functions are described below. They are only available if an external database driver is loaded. The dbhandle argument for all of the functions is a database handle (obtained with ns_db gethandle poolname).

ns_ext cpfrom copies a local file (file1) from the remote proxy daemon file space (file2). This function (along with mktemp, rm, and cpto) is provided to support environments where the proxy daemon does not share a common file system with the server, allowing SQL statements to reference local temporary files, which can then be copied to the server's local file space.

ns_ext cpto copies a local file (file1) to the remote proxy daemon file space (file2). This function (along with mktemp, rm, and cpfrom) is provided to support environments where the proxy daemon does not share a common file system with the server, allowing SQL statements to reference local temporary files, which can then be copied to the server's local file space.

ns_ext dbtype returns the database type, such as "Sybase".

ns_ext gettypes returns a Tcl list containing the data types for the database.

ns_ext identify returns the proxy daemon identity and version string.

ns_ext isremote returns a boolean value indicating whether or not the database is remote.

ns_ext mktemp creates a unique temporary file in the proxy daemon's file space. This function (along with rm, cpto, and cpfrom) is provided to support environments where the proxy daemon does not share a common file system with the server, allowing SQL statements to reference local temporary files, which can then be copied to the server's local file space.

ns_ext number returns the connection number.

ns_ext ping verifies that the proxy daemon process is running.

ns_ext resultid returns the id of the last object affected by an exec command.

ns_ext resultrows returns the number of rows affected by the last exec command.

ns_ext rm removes a file (file) in the proxy daemon's file space. This function (along with mktemp, cpto, and cpfrom) is provided to support environments where the proxy daemon does not share a common file system with the server, allowing SQL statements to reference local temporary files, which can then be copied to the server's local file space.

ns_ext setmaxrows specifies the limit on the number of rows to be returned.

ns_ext traceoff disables message tracing in the proxy daemon.

ns_ext traceon enables message tracing in the proxy daemon. Trace output is written to the specified file path (file).