Appendix D. Client Environment Variables

Descriptions for each environment variable specified by a client are as follows:

Environment VariableDescription
TB_NLS_LANG

Character set of the client.

For more information, refer to "Appendix C. Supported Character Sets" in Tibero Installation Guide.

    TB_NLS_DATE_FORMAT

    DATE expression.

    The following are the valid DATE masks:

    • YYYY/MM/DD (Default value)

    • MM/DD/YYYY

    • DD RM YYYY

    • RR/MM/DD

    TB_NLS_TIMESTAMP_FORMAT

    TIMESTAMP expression.

    The following are the valid TIMESTAMP masks:

    • YYYY-MM-DD HH:MI:SS.FF

    • YYYY/MM/DD HH24:MI:SS

    • RR/MM/DD HH24:MISSXFF (Default value)

    TB_NLS_NCHAR

    National character set of the client.

    One of:

    • JA16SJISFIXED

    TBCLI_LOG_LVL

    Log level of tbCLI.

    One of the following can be specified (default value: DEBUG):

    • FATAL: Used when an application needs to be terminated due to a fatal error.

    • ERROR: An application continues to function.

    • WARN: Not an error, but can cause a problem.

    • INFO: Information used to trace an application's operations. In general, it records coarse-grained logs, for example, API calls.

    • DEBUG: Records fine-grained logs used to debug applications. For example, it logs parameters and temporary values used during calculations.

    • TRACE: Records more detailed information than DEBUG. For example, it records extended logs related to unconventional binary data dumps or memory dumps.

    • INTERNAL: Records the most detailed information. This is used only for internal debugging. For example, lock information.

    TBXA_LOG_LVL

    Log level of tbxa.

    • WINDOWS: C:\tbxa_datetime.log

    • UNIX: /tmp/tbxa_datetime.log

    The available values are the same as those in TBCLI_LOG_LVL.

    TB_DSN_FILE

    DSN file path.

    Used if DSN file path cannot be referenced through TB_HOME because only the client is installed without the server.

    TB_DSN_FILE takes priority over TB_HOME.