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. Note that in version 6.00.1300386000 20110317 and later, the stringformat() SQL function can be used to format dates (and other values) without needing to set a global property.

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 and Texis version 5 or earlier; see textsearchmode for UTF-8/Unicode and version 6 or later 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.

varchartostrlstsep

  The separator character or mode to use when converting a varchar string into a strlst list of strings in Texis. The default is set by the conf/texis.ini setting [Texis] Varchar To Strlst Sep (here); if that is not set, the default is lastchar, which indicates that the last character in the string should be the separator; eg. " a,b,c," would be split on the comma and result in a strlst of 3 values: "a", "b" and "c".

varchartostrlstsep may also be create, which indicates that a separator should be created. The entire string is taken as one value for the strlst, and a separator is created that is not present in the string, for future use or re-conversion to varchar. This can be used in conjunction with Vortex's <sqlcp arrayconvert> setting to ensure that single-value as well as multi-value Vortex variables are converted consistently when inserted into a strlst column: single-value vars by varchartostrlstsep, multi-value by arrayconvert.

varchartostrlstsep may also be a single byte character, in which case that character is used as the separator. This is useful for converting CSV-type strings eg. "a,b,c" without having to modify the string and append the separator character first.

varchartostrlstsep may also be set to default to restore the default (conf/texis.ini) setting, or builtindefault to restore the factory built-in default (ie. lastchar); these values were added in version 5.01.1231553000 20090109.

varchartostrlstsep was added in version 5.01.1226978000 20081117. See also the metamorphstrlstmode setting (here), which affects conversion of strlst values into Metamorph queries.

multivaluetomultirow

  Whether to split multi-value fields (eg. strlst) into multiple rows (eg. of varchar) when appropriate, ie. during GROUP BY or DISTINCT on such a field. If nonzero/true (the default), a GROUP BY or DISTINCT on a strlst field will split the field into its varchar members for processing. For example, consider the following table:

    create table test(Colors strlst);
    insert into test(Colors) values('red,green,blue,');
    insert into test(Colors) values('blue,orange,green,');

With multivaluetomultirow set true, the statement:

    select count(Colors) Count, Colors from test group by Colors;

generates the following output:

          Count       Colors
    ------------+------------+
               2 blue
               2 green
               1 orange
               1 red

Note that the strlst values have been split, allowing the two blue and green values to be counted individually. Note also that merely SELECTing a strlst will not cause it to be split: it must be specified in the GROUP BY or DISTINCT clause.

The multivaluetomultirow was added in version 5.01.1243980000 20090602. It currently only applies to strlst values and only to single-column GROUP BY or DISTINCT clauses. A system-wide default for this SQL setting can be set in conf/texis.ini with the [Texis] Multi Value To Multi Row setting.