When creating a data configuration with copied SQL or typed in SQL, Statistica Enterprise Manager asks if the user wants to turn on the use of fully qualified column/table names. What are the implications of this dialog ? Selection affects SQL information of all fields of a data configuration and can be changed later on. 

Statistica Enterprise Manager stores SQL information for every field in a data configuration.  When Statistica query builder is used to build the SQL, Statistica knows the names of the table and the schema information that it stores in SQL information of every field of the query. The option to use fully qualified column name and table name will determine how the field is being added to the where clause of the query as you set filtering options or ordering options via Statistica Enterprise.

So when the user manually defines the query (called text mode in Statistica ) Statistica prompts the user to know, if it should use the fully qualified column names or not. Depending on if the query is joining several tables , using an alias, and so on, the user will have to select if they want to use the fully qualified names or not.

An example is  : If the query uses SQL Server 'With' clause to define an alias, the option to fully qualify column names probably needs to be turned off so that the filters and orders on the column are use the alias instead of the table name whereas if the typed in SQL has a couple of joins and Statistica needs to keep track of which table the column is from in order to avoid ambiguity in the where clause, the option needs to be turned on.

The SQL information can also be changed, if the user is unsure of if they want to keep the fully qualified names or not at the time of saving the data configuration.