#MICROSTATION WORKSPACE MANAGER FULL#

For example, it may be necessary to clean up a temporary view after creating it. This parameter allows for the execution of SQL statements after a set of tables has been read. If the specified statement is preceded by a hyphen (“-”), such errors are ignored. Multiple delimiters are not allowed and the delimiter character will be stripped before being sent to the database.Īny errors occurring during the execution of these SQL statements will normally terminate the reader or writer (depending on where the SQL statement is executed) with an error. WHERE LastName='Doe' AND FirstName='John'

Note: Include a space before the character. The single character following this directive will be used to split the SQL block into SQL statements, which will then be sent to the database for execution. Multiple SQL commands can be delimited by a character specified using the FME_SQL_DELIMITER directive, embedded at the beginning of the SQL block.

Īvailable menu options depend on the format. For example, it may be necessary to create a temporary view before attempting to read from it.įor detailed information about SQL functions, click the corresponding menu item in the SQL to Run editor help. This parameter allows for the execution of SQL statements before opening a table for reading. This is to ensure that the reader will find the correct table. Navigate to the dgnlib folder of the MicroStation workspace and select BorderFilters.dgnlib. Note: Even when this parameter is selected, if the table is ownedīy a user other than the current user, the prefix will Is expecting feature types with different names). Not change this parameter after generating the workspace, because it is possibleįor no features to be successfully passed onto the writer (since the writer When this parameter is selected during workspace generation, the sourceįeature types will be the table names without any prefix otherwise, they Will be passed on to another organization using the same table names, or performing a translation to another database format but with a different user name. This is useful, for example, when creating a workspace that Selecting this parameter indicates that the reader should return the table name withoutĪny prefixes.

#MICROSTATION WORKSPACE MANAGER FULL#

The full name of a table in a database is of the format:ĭepending on the database format, the prefix can be.

Specifies whether to keep the table qualifier.

Microstation workspace manager