Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
tdbc::tokenize(n)	   Tcl Database	Connectivity	     tdbc::tokenize(n)

______________________________________________________________________________

NAME
       tdbc::tokenize -	TDBC SQL tokenizer

SYNOPSIS
       package require tdbc 1.0

       tdbc::tokenize string
______________________________________________________________________________

DESCRIPTION
       As  a convenience to database drivers, Tcl Database Connectivity	(TDBC)
       provides	a command to break SQL code apart into tokens  so  that	 bound
       variables can readily be	identified and substituted.

       The  tdbc::tokenize  command  accepts as	its parameter a	string that is
       expected	to contain one or more SQL statements. It returns  a  list  of
       substrings;  concatenating  these  substrings  together	will yield the
       original	string.	Each substring is one of the following:

       [1]    A	bound variable,	which begins with one of the  characters  ':',
	      '@',  or	'$'.  The remainder of the string is the variable name
	      and will consist of  alphanumeric	 characters  and  underscores.
	      (The leading character will be be	non-numeric.)

       [2]    A	semicolon that separates two SQL statements.

       [3]    Something	 else  in  a SQL statement. The	tokenizer does not at-
	      tempt to parse SQL; it merely identifies bound  variables	 (dis-
	      tinguishing them from similar strings appearing inside quotes or
	      comments)	and statement delimiters.

SEE ALSO
       tdbc(n),	tdbc::connection(n), tdbc::statement(n), tdbc::resultset(n)

KEYWORDS
       TDBC, SQL, database, tokenize

COPYRIGHT
       Copyright (c) 2008 by Kevin B. Kenny.

Tcl				      8.6		     tdbc::tokenize(n)

NAME | SYNOPSIS | DESCRIPTION | SEE ALSO | KEYWORDS | COPYRIGHT

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=tdbc_tokenize&manpath=FreeBSD+12.0-RELEASE+and+Ports>

home | help