f2s_int_output_schema_name_state¶

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

Syntax

set_attribute f2s_int_output_schema_name_state of {FileNumber} to {variable}
get_attribute f2s_int_output_schema_name_state of {FileNumber} to {variable}

Description

This attribute is used to specify whether the SCHEMA_NAME option will be included in the .INT file for the specified table. For more information about .INT files, please see Intermediate Files in the DataFlex documentation.

If set to true, the database name will be included in the .INT file (SCHEMA_NAME schema name). If set to false, the database name will NOT be included in the .INT file.

Getting the attribute does not require a Structure_Start/Structure_End block, it can be used anywhere.

Setting the attribute can be used when creating a table or to make a modified copy of the table’s .INT file. When creating a table, this attribute must be set within the Structure_Start/Structure_End block. When making a modified copy, this can be called anywhere. However, to actually create the new .INT file, the command f2s_write_int_file NEED LINK FOR THIS must be called after setting the attribute.

Examples

get_attribute

//find out whether the database name is included in the .INT file
boolean bHasSchemaName

get_attribute f2s_int_output_schema_name_state of Customer.File_Number to bHasSchemaName

set_attribute

//this will add the SCHEMA_NAME field to the Customer_copy.INT

Set_Attribute f2s_int_output_schema_name_state of Customer.File_Number to true
f2s_write_int_file Customer.File_Number to "C:\temp\customer_copy.int"

The Customer.INT file in the data directory of the workspace will begin:

DRIVER_NAME f2s_ms
DATABASE_NAME Customer

However, the C:\temp\customer_copy.INT file will begin:

DRIVER_NAME f2s_ms
DATABASE_NAME Customer
SCHEMA_NAME schema_name

Related Attributes

• f2s_int_output_db_name_state

• f2s_int_output_server_state

Replaces: DF_FILE_SUPRESS_SCHEMANAME_OUTPUT

NOTE - The logic on f2s_int_output_schema_name_state is reversed from DF_FILE_SUPPRESS_SCHEMANAME_OUTPUT.

DF_FILE_SUPPRESS_SCHEMANAME_OUTPUT = false SAME AS f2s_int_output_schema_name_state=true.