Miscellaneous Properties

These properties do not fit nicely into a group, and are presented here.

tablespace

Similar to indexspace above. Sets a directory into which tables created will be placed. This property does not stay set across invocations. Default is empty string, which means the database directory.

datefmt

This is a strftime format used to format dates for conversion to character format. This will affect tsql, as well as attempts to retrieve dates in ASCII format. Although the features supported by different operating systems will vary, some of the more common format codes are:

%%

Output %

%a

abbreviated weekday name

%A

full weekday name

%b

abbreviated month name

%B

full month name

%c

local date and time representation

%d

day of month (01 - 31)

%D

date as %m/%d/%y

%e

day of month ( 1 - 31)

%H

Hour (00 - 23)

%I

Hour (01 - 12)

%j

day of year (001 - 366)

%m

month (01 - 12)

%M

Minute (00 - 59)

%p

AM/PM

%S

Seconds (00 - 59)

%U

Week number (beginning Sunday) (00-53)

%w

Week day (0-6) (0 is Sunday)

%W

Week number (beginning Monday) (00-53)

%x

local date representation

%X

local time representation

%y

two digit year (00 - 99)

%Y

Year with century

%Z

Time zone name

Default %Y-%m-%d %H:%M:%S, which can be restored by setting datefmt to an empty string.

timezone

Change the default timezone that Texis will use. This should be formatted as for the TZ environment variable. For example for US Eastern time you should set timezone to EST5EDT. Some systems may allow alternate representations, such as US/Eastern, and if your operating system accepts them, so will Texis.

locale

Can be used to change the locale that Texis uses. This will impact the display of dates if using names, as well as the meaning of the character classes in REX expressions, so \alpha will be correct. Also with the correct locale set, Metamorph will work case insensitively correctly (with mono-byte character sets; see textsearchmode for UTF-8/Unicode support).

indirectcompat

Setting this to 1 sets compatibility with early versions of Texis as far as display of indirects go. If set to 1 a trailing @ is added to the end of the filename. Default 0.

indirectspace

Controls where indirects are created. The default location is a directory called indirects in the database directory. Texis will automatically create a directory structure under that directory to allow for efficient indirect access. At the top level there will be 16 directories, 0 through 9 and a through f. When you create the directory for indirects you can precreate these directories, or use them as mount points. You should make sure that the Texis user has permissions to the directories. Added in version 03.00.940520000

triggermode

This setting changes the way that the command is treated when creating a trigger. The default behavior is that the command will be executed with an extra arg, which is the filename of the table containing the records. If triggermode is set to 1 then the strings $db and $table are replaced by the database and table in that database containing the records. This allows any program which can access the database to retrieve the values in the table without custom coding.

paramchk

Enables or disables the checking of parameters in the SQL statement. By default it is enabled, which will cause any unset parameters to cause an error. If paramchk is set to 0 then unset parameters will not cause an error, and will be ignored. This lets a single complex query be given, yet parameter values need only be supplied for those clauses that should take effect on the query.

message,nomessage

Enable or disable messages from the SQL engine. The argument should be a comma separated list of messages that you want to enable or disable. The known messages are:

duplicate

Message Trying to insert duplicate value () in index when an attempt is made to insert a record which has a duplicate value and a unique index exists. The default is enabled.