1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
<HTML><HEAD>
<TITLE>Tcl API Reference -- ns_ext</TITLE>
<LINK rel=Previous href="tapi-c53.htm">
<LINK rel=ToC href="toc.htm">
<LINK rel=Index href="master.htm">
<LINK rel=Next href="tapi-c55.htm">
</HEAD><BODY BGCOLOR="#ffffff"><A NAME="topofpage"></A>
<TABLE WIDTH=100%>
<TR>
<TD ALIGN=LEFT>
<A NAME="topofpage"></A> <IMG SRC="as-c-sm.gif">
</TD>
<TD ALIGN=RIGHT>
<A href="tapi-c53.htm"><IMG BORDER="0" src=navbprev.gif alt="[ Previous ]"></A>
<A href=toc.htm> <IMG BORDER="0" src=navbhome.gif alt="[ Contents ]"></A>
<A href=master.htm> <IMG BORDER="0" src=navbhelp.gif alt="[ Index ]"></A>
<A href="tapi-c55.htm"> <IMG BORDER="0" src=navbnext.gif alt="[ Next ]"></A>
<A name="7983"> </A>
</TD>
</TR>
</TABLE>
<a name="82709">
</a><h3>ns_ext</h3>
<a name="82710">
</a><h4>Overview</h4>
<p><a name="82711">
</a>Perform external database driver operations</p>
<a name="82712">
</a><h4>Syntax</h4>
<p><a name="83381">
</a><b>ns_ext cpfrom</b> <i>dbhandle file1 file2</i></p>
<p><a name="83385">
</a><b>ns_ext cpto</b> <i>dbhandle file1 file2</i></p>
<p><a name="82783">
</a><b>ns_ext dbtype </b><i>dbhandle</i></p>
<p><a name="83351">
</a><b>ns_ext gettypes </b><i>dbhandle</i></p>
<p><a name="83355">
</a><b>ns_ext identify</b> <i>dbhandle</i></p>
<p><a name="121210">
</a><b>ns_ext isremote</b> <i>dbhandle</i></p>
<p><a name="83373">
</a><b>ns_ext mktemp</b> <i>dbhandle</i></p>
<p><a name="83363">
</a><b>ns_ext number</b> <i>dbhandle</i></p>
<p><a name="83289">
</a><b>ns_ext ping</b> <i>dbhandle</i></p>
<p><a name="83367">
</a><b>ns_ext resultid</b> <i>dbhandle</i></p>
<p><a name="83368">
</a><b>ns_ext resultrows</b> <i>dbhandle</i></p>
<p><a name="83377">
</a><b>ns_ext rm</b> <i>dbhandle file</i></p>
<p><a name="83369">
</a><b>ns_ext setmaxrows</b> <i>dbhandle limit</i></p>
<p><a name="83359">
</a><b>ns_ext traceoff</b> <i>dbhandle</i></p>
<p><a name="82946">
</a><b>ns_ext traceon</b> <i>dbhandle file</i></p>
<a name="82714">
</a><h4>Description</h4>
<p><a name="83327">
</a>The <b>ns_ext</b> functions are described below. They are only available if an external database driver is loaded. The <i>dbhandle</i> argument for all of the functions is a database handle (obtained with <b>ns_db gethandle</b><i> poolname</i>).</p>
<p><a name="83436">
</a><b>ns_ext cpfrom </b>copies a local file (<i>file1</i>) from the remote proxy daemon file space (<i>file2</i>). This function (along with <b>mktemp</b>, <b>rm</b>, and <b>cpto</b>) 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.</p>
<p><a name="82766">
</a><b>ns_ext cpto </b>copies a local file (<i>file1</i>) to the remote proxy daemon file space (<i>file2</i>). This function (along with <b>mktemp</b>, <b>rm</b>, and <b>cpfrom</b>) 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.</p>
<p><a name="83428">
</a><b>ns_ext dbtype</b> returns the database type, such as "Sybase".</p>
<p><a name="83422">
</a><b>ns_ext gettypes </b>returns a Tcl list containing the data types for the database.</p>
<p><a name="83423">
</a><b>ns_ext identify </b>returns the proxy daemon identity and version string.</p>
<p><a name="121211">
</a><b>ns_ext isremote</b> returns a boolean value indicating whether or not the database is remote.</p>
<p><a name="83424">
</a><b>ns_ext mktemp </b>creates a unique temporary file in the proxy daemon's file space. This function (along with <b>rm</b>, <b>cpto</b>, and <b>cpfrom</b>) 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.</p>
<p><a name="83414">
</a><b>ns_ext number </b>returns the connection number.</p>
<p><a name="83410">
</a><b>ns_ext ping </b>verifies that the proxy daemon process is running.</p>
<p><a name="83405">
</a><b>ns_ext resultid </b>returns the id of the last object affected by an exec command.</p>
<p><a name="83406">
</a><b>ns_ext resultrows </b>returns the number of rows affected by the last exec command.</p>
<p><a name="83401">
</a><b>ns_ext rm </b>removes a file (<i>file</i>) in the proxy daemon's file space. This function (along with <b>mktemp</b>, <b>cpto</b>, and <b>cpfrom</b>) 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.</p>
<p><a name="83397">
</a><b>ns_ext setmaxrows </b>specifies the limit on the number of rows to be returned.</p>
<p><a name="83389">
</a><b>ns_ext traceoff </b>disables message tracing in the proxy daemon.</p>
<p><a name="83393">
</a><b>ns_ext traceon </b>enables message tracing in the proxy daemon. Trace output is written to the specified file path (<i>file</i>).</p>
<TABLE BORDER="2" CELLPADDING="1" width="100%">
<TR><TD COLSPAN=3><P ALIGN=Center>
<IMG SRC="bluebult.gif">
<A HREF="#topofpage">
<FONT SIZE=-1>Top of Page</FONT></A>
<IMG SRC="bluebult.gif">
</TD></TR>
<TR><TD COLSPAN=3><P ALIGN=Center>
<A href="tapi-c53.htm">
<IMG BORDER="0" src=navbprev.gif alt="[ Previous ]"></A>
<A href=toc.htm>
<IMG BORDER="0" src=navbhome.gif alt="[ Contents ]"></A>
<A href=master.htm>
<IMG BORDER="0" src=navbhelp.gif alt="[ Index ]"></A>
<A href="tapi-c55.htm">
<IMG BORDER="0" src=navbnext.gif alt="[ Next ]"></A>
<BR align=center>
<FONT size=-1>Copyright © 1998-99 America Online,
Inc.</FONT>
</TD></TR></TABLE></BODY></HTML>
|
