EasyManuals Logo
Home>Siemens>Control Systems>SIMATIC OpenPCS 7

Siemens SIMATIC OpenPCS 7 User Manual

Siemens SIMATIC OpenPCS 7
96 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #92 background imageLoading...
Page #92 background image
Parameter Description
ViewName Name of the database table.
The table must be specified in the required language. The "ViewName" for the five
European languages is, for example:
ALGVIEWDEU: German message archive data
ALGVIEWENU: English message archive data
ALGVIEWESP: Spanish message archive data
ALGVIEWFRA: French message archive data
ALGVIEWITA: Italian message archive data
Note
The languages that are installed on the PCS 7 OS or configured in the PCS 7 OS Text
Library are supported. Information on the possible query languages and the
corresponding "ViewName" in the SQL server is available in the connected message
archives in "Views". Here, all languages and their identifications, such as
"ALGVIEWENU", are displayed that are supported in the particular archive.
Condition Filter criterion e.g.:
DateTime>'2003-06-01' AND DateTime<'2003-07-01'
DateTime>'2003-06-01 17:30:00'
MsgNo = 5
MsgNo in (4, 5)
State = 2
With DateTime, the time can only be specified in absolute format.
Example 1:
Reads all entries of message number 5 that were recorded after July 05, 2003.
"ALARMVIEW:SELECT * FROM ALGVIEWENU WHERE MsgNo = 5 AND
DateTime>'2003-07-05'"
Example 2:
Reads all messages with the time stamp between July 03, 2003 and July 05, 2003.
"ALARMVIEW:SELECT * FROM ALGVIEWENU WHERE DateTime>'2003-07-03' AND
DateTime<'2003-07-05'"
OpenPCS 7 interface
6.7 OLE DB
OpenPCS 7
92 Function Manual, 05/2012, A5E02780178-02

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the Siemens SIMATIC OpenPCS 7 and is the answer not in the manual?

Siemens SIMATIC OpenPCS 7 Specifications

General IconGeneral
BrandSiemens
ModelSIMATIC OpenPCS 7
CategoryControl Systems
LanguageEnglish

Related product manuals