However, using this system stored procedure alone does not provide a way to set the Allow In Process and Level Zero Only options. You can use the sp_addlinkedserver system stored procedure from Microsoft SQL Server to programmatically configure a linked server definition. Configuring the Historian OLE DB Provider as a Linked Server For example, a client tool such as Microsoft Query Analyzer can be used to retrieve Historian product data over the network on a computer with no Historian software installed. The data is simply returned as part of a query, just as any other query on a SQL Server database would return data.Īnother benefit of using the Historian OLE DB Provider as a linked server is that clients do not need any Historian software installed.
Data is not duplicated because nothing is imported or stored in SQL Server. With linked servers, when you query data from Historian, the SQL Server fetches the requested data from Historian at the time the query is executed. You can also use the OLE DB Provider as a linked server if you do not want to duplicate data with an import. If you require the ability to relate Historian data with other data in SQL Server tables such as batch events, iFIX alarms and events, iDownTimedata, and any other information that is available in a relational database, you can use the Historian OLE DB Provider as a linked server in Microsoft SQL Server. Consult your Proficy Real Time Information Portal documentation for more information. You cannot create multiple parameters with the same name. When you define a parameter in the SQL Statement Builder, you can specify a default value for the parameter from the Parameters tab. However, you can select int, date, num, or char as the type of database column. By default, the data type is set to char. The data type determines the kind of data the parameter can hold. You also have the option to select a data type for the parameter. For example, the parameter temperature becomes. When you enter a name, the Statement Builder adds a question mark to the end of the name and encloses the entire string in curly brackets.
You can define a parameter by entering the name of the parameter in the Parameter field of the Specify Selected Item Wizard or the Specify Criterion Wizard. Parameterized queries are built in the Proficy Real Time Information Portal SQL Query Builder application. Parameterized SQL queries are driven by Proficy Real Time Information Portal components such as list boxes, combo boxes or grids. In the place of a constant value in a SQL query, you can instead place a parameter, which takes a value at execution time. Parameters are used within the Proficy Real Time Information Portal to build SQL queries that can be reused with different values.
0 kommentar(er)
