f2s_table_letter_casing¶

Applies to: Oracle, MS SQL, MySql/MariaDB, PostgreSQL Drivers

Syntax

set_attribute f2s_table_letter_casing of {FileNumber} to {FILE_CASING_KEEP|FILE_CASING_LOWER|FILE_CASING_UPPER}
get_attribute f2s_table_letter_casing of {FileNumber} to {variable}

Parameter

Description

FileNumber

Number of the file (filename.File_Number)

variable

An integer value which will be FILE_CASING_KEEP (keep the original casing), FILE_CASING_LOWER (force to lowercase) or FILE_CASING_UPPER (force to uppercase)

Description

This attribute controls the filename and column name casing of the table. Getting the attribute can be done anywhere in the code, however, setting the attribute must be done within a Structure_Start/Structure_End block.

Examples

get_attribute

<EXAMPLE>

set_attribute

<EXAMPLE>

Related Attributes

  • reference

  • reference 2

ESQL Equivalents

Replaces: DF_FILE_CASING