Tcl command "SQLr_select"

Remote SQL select


Index:


Input types

INSID
pointer

Id returned by open

INRowDesc
string

Description of a row
space (tab) separated

syntax:
i - integer
in - integer, do not check for NULL
n - natural
nn - natural, do not check for NULL
r - real
rn - real, do not check for NULL
t - timestamp {year month day hour min sec fraction}
tn - timestamp {year month day hour min sec fraction}, do not check for NULL
s - string
sn - string, do not check for NULL
b - binary (hex array)
bn - binary (hex array), do not associate the actual length

example:
"i rn sn15 b12 t" == return first and second column as integer,
the third column as string, up to 15 chars,
the fourth column as binary data, up to 12 bytes
the fifth column as timestamp

this will return something like (2 rows)
{ {{1 34} 3.14 "abc" {34 {79 fe 23 e1 00 32 01 00 12 6f a2 a1}}} {0}
{{0} 1.2345 "ef sedf" {-1 } {1 {1999 12 1 14 31 59 0}}}}


Output types

OUTSID
pointer

Dummy
integer

OUTGetList
string

It is a list of string


Commands

SQLr_select open DBnode [DBport]
Input:
DBnode
string

DBport
integer

default: -1

Output:
OUTSID

C function:
SQLr_select_tl_open

Open a connection to the remote DB server

SQLr_select close sid
Input:
sid
INSID

Output:
Dummy

C function:
SQLr_select_tl_close

Close the connection to the remote DB server

SQLr_select get sid rowdesc SQLstring [maxrows]
Input:
sid
INSID

rowdesc
INRowDesc

Description of the columns

SQLstring
string

Must start with SELECT

maxrows
integer

Default: -1
If !=-1 and more than maxrows are found, an error is raised

Output:
OUTGetList

C function:
SQLr_select_tl_get

Get some data from the remote DB server


Generated Thu 13. May 1999 09:56:04 from a tl file.
Do not modify by hand!