Skip to content

DF_FILE_RESTRUCTURE_INT_ONLY

See Also: Get_Attribute, Set_Attribute, DF_FILE_RESTRUCTURE

This attribute returns True if structural changes were made that require ONLY writing a new table INT file, but not restructuring the table itself in the back-end database. This attribute cannot be set.

Level

Table

Supported by

The DataFlex SQL Drivers (SQL Server, DB2, and ODBC), version 6.2 and higher.

Type

Boolean, temporary

Access

Read Only

Values

  • True
  • False

Syntax

Use cli.pkg
Get_Attribute DF_FILE_RESTRUCTURE_INT_ONLY of {tableNumber} to {BooleanVariable}

Remarks

The DF_FILE_RESTRUCTURE_INT_ONLY attribute provides additional information to the DF_FILE_RESTRUCTURE attribute.

If DF_FILE_RESTRUCTURE_INT_ONLY returns True, there will be no structural changes on the server; only the INT file will be changed. If DF_FILE_RESTRUCTURE_INT_ONLY returns False, the DF_FILE_RESTRUCTURE attribute will indicate if and what kind of restructure is needed.

DF_FILE_RESTRUCTURE_INT_ONLY will only return True if there are only INT file changes. If there are additional changes that do require server-side changes, DF_FILE_RESTRUCTURE_INT_ONLY will return False.

Examples of changes that will require only rewriting the INT file:

  • Adding/removing/changing client-side indexes
  • Changing DF_Length of varchar(max) and varbinary(max) columns
  • Changing the DataFlex type of SQL datetime column.