dblimits()
Description: returns information
about the limits applied for identifiers and clauses in SQL statements.
Syntax: dblimits(f)
Parameters:
-
f: ODBC file previously opened
with dbopen()
The return type is a record with the following
fields:
-
"maxbinlitlen": maximum length
of a binary literal in an SQL statement. if there is no maximum length
or the length is unknown, this value is set to zero.
-
"maxcharlitlen": maximum length
of a character literal in an SQL statement. if there is no maximum length
or the length is unknown, this value is set to zero.
-
"maxcolnamelen": maximum length
of a column name in the data source. if there is no maximum length or the
length is unknown, this value is set to zero.
-
"maxgroupbycols": maximum number
of columns allowed in a GROUP BY clause. If there is no specified limit
or the limit is unknown, this value is set to zero.
-
"maxorderbycols": maximum number
of columns allowed in a ORDER BY clause. If there is no specified limit
or the limit is unknown, this value is set to zero.
-
"maxindexcols": maximum number
of columns allowed in an index. If there is no specified limit or the limit
is unknown, this value is set to zero.
-
"maxselectcols": maximum number
of columns allowed in a SELECT list. If there is no specified limit or
the limit is unknown, this value is set to zero.
-
"maxtblcols"": maximum number of
columns allowed in a table. If there is no specified limit or the limit
is unknown, this value is set to zero.
-
"maxcursnamelen": maximum name
length of a cursor name in the data source. If there is no specified limit
or the limit is unknown, this value is set to zero.
-
"maxindexsize": maximum number
of bytes allowed in the combined fields of an index. If there is no specified
limit or the limit is unknown, this value is set to zero.
-
"maxownnamelen": maximum length
of an owner name in the data source. If there is no specified limit or
the limit is unknown, this value is set to zero.
-
"maxprocnamelen": maximum length
of a procedure name in the data source. If there is no specified limit
or the limit is unknown, this value is set to zero.
-
"maxqualnamelen": maximum length
of a qualifier name in the data source. If there is no specified limit
or the limit is unknown, this value is set to zero.
-
"maxrowsize": maximum length of
a single row in a table. If there is no specified limit or the limit is
unknown, this value is set to zero.
-
"maxrowsizelong": a character string:
"Y" if the maximum row size returned for the "maxrowize" information type
includes the length of all SQL_LONGVARCHAR and SQL_LONGVARBINARY columns
in the row; "N" otherwise.
-
"maxstmtlen": maximum lenght (number
of characters, including white space) of an SQL statement. If there is
no maximum length or the length is unknown, this value is set to zero.
-
"maxtblnamelen": maximum length
of a table name in the data source. If there is no maximum length or the
length is unknown, this value is set to zero.
-
"maxselecttbls": maximum number
of tables allowed in the FROM clause of a SELECT statement. If there is
no maximum length or the length is unknown, this value is set to zero.
-
"maxusernamelen": maximum length
of a user name in the data source. If there is no maximum length or the
length is unknown, this value is set to zero.
Code Example
procedure main()
f:=dbopen("mydb","O","mytable","fbalbi","") # open mytable
dbl:=dblimits(f) # get DBMS limits information
every i:=(1 to *dbl) do write(dbl[i])
close(f) # close table
end