Proficy* HMI/SCADA - iFIX
I FIX D ATABASE R EFERENCE
Version 5.8
November 2013
Disclaimer of Warranties and Liability
The information contained in this manual is believed to be accurate and reliable. However, GE Intelligent Platforms, Inc.
assumes no responsibilities for any errors, omissions or inaccuracies whatsoever. Without limiting the foregoing, GE
Intelligent Platforms, Inc. disclaims any and all warranties, expressed or implied, including the warranty of merchantability
and fitness for a particular purpose, with respect to the information contained in this manual and the equipment or
software described herein. The entire risk as to the quality and performance of such information, equipment and software,
is upon the buyer or user. GE Intelligent Platforms, Inc. shall not be liable for any damages, including special or
consequential damages, arising out of the user of such information, equipment and software, even if GE Intelligent
Platforms, Inc. has been advised in advance of the possibility of such damages. The user of the information contained in the
manual and the software described herein is subject to the GE Intelligent Platforms, Inc. standard license agreement, which
must be accepted by the buyer or user before the use of such information, equipment or software.
Trademark Notices
©2013 General Electric Company. All rights reserved.
Proficy is a registered trademark of GE Intelligent Platforms, Inc. a wholly-owned subsidiary of General Electric Company.
*Trademark of GE Intelligent Platforms, Inc.
All other brands or names are property of their respective owners.
All other product names and marks identified throughout this book are trademarks or registered trademarks of their
respective companies. They are used throughout this book in editorial fashion only. No such use, or the use of any trade
names is intended to convey endorsement or affiliation.
No part of this publication may be reproduced in any form, or stored in a database or retrieval system, or transmitted or
distributed in any form by any means, electronic, mechanical photocopying, recordings or otherwise, without the prior
written permission of GE Intelligent Platforms, Information contained herein is subject to change without notice.
We want to hear from you. If you have comments, questions, or suggestions about our documentation, send them to the
following email address:
doc@ge.com
Table of Contents
About this Guide .......................................................................................................................... 1
Creating a Process Database ...................................................................................................... 2
Learning Database Basics ....................................................................................................... 2
Managing Blocks ............................................................................................................... 10
Managing Databases ......................................................................................................... 13
Working with the Spreadsheet............................................................................................ 17
Customizing Database Manager ........................................................................................ 33
Database Block Reference .................................................................................................... 36
A........................................................................................................................................ 38
B-C .................................................................................................................................... 43
D ....................................................................................................................................... 44
E-L .................................................................................................................................... 48
M-Q ................................................................................................................................... 51
R-S .................................................................................................................................... 55
T-Z .................................................................................................................................... 59
Database Block Field Reference ............................................................................................ 62
A........................................................................................................................................ 64
D ..................................................................................................................................... 123
E-L .................................................................................................................................. 171
M-Q ................................................................................................................................. 207
R-S .................................................................................................................................. 248
T-Z .................................................................................................................................. 306
Typical Uses of Database Blocks ......................................................................................... 335
A...................................................................................................................................... 337
B-C .................................................................................................................................. 338
iii
iFIX Database Reference
D ..................................................................................................................................... 339
E-L .................................................................................................................................. 341
M-Q ................................................................................................................................. 343
R-S .................................................................................................................................. 344
T-Z .................................................................................................................................. 346
Database Block Examples ................................................................................................... 347
A...................................................................................................................................... 349
B-C .................................................................................................................................. 351
D ..................................................................................................................................... 353
E-L .................................................................................................................................. 355
M-Q ................................................................................................................................. 358
R-S .................................................................................................................................. 362
T-Z .................................................................................................................................. 364
Commands Available from Database Blocks ........................................................................ 365
Device Control Block Commands ..................................................................................... 366
Event Action Block Commands ........................................................................................ 374
Program Block Commands .............................................................................................. 376
Math Features in Database Blocks ....................................................................................... 403
Boolean Block .................................................................................................................. 404
Calculation Block ............................................................................................................. 406
Device Control Block ........................................................................................................ 408
PID Block ......................................................................................................................... 411
Signal Select Block .......................................................................................................... 412
Statistical Data Block ....................................................................................................... 413
Additional Information on Alarming ....................................................................................... 417
Alarm Priorities for the Analog Alarm Block ...................................................................... 418
Alarm Transitions for the Analog Alarm Block ................................................................... 418
Alarm Types for the Analog Alarm Block .......................................................................... 420
iv
Table of Contents
Alarms in the Boolean Block ............................................................................................ 421
Alarm Handling in the Multistate Digital Input Block .......................................................... 422
Alarming Considerations in the Statistical Data Block ....................................................... 422
Alarm States in the Event Action Block ............................................................................. 423
Alarm States, Contacts, and the Digital Alarm Block ......................................................... 424
SQL Use in Database Blocks ............................................................................................... 425
Reading and Writing of SQL Data .................................................................................... 425
Behavior of SQL Data Blocks While Off Scan ................................................................... 426
Keywords Available for use in the SQL Data Block ........................................................... 426
Direction of SQL Data Block ............................................................................................. 426
SQL Trigger Block States ................................................................................................. 427
SQL Trigger Blocks in Manual Mode ................................................................................ 428
System Fields ...................................................................................................................... 428
Database and SAC System Fields ................................................................................... 428
Redundancy System Fields .............................................................................................. 430
SIM Signal Generation Registers ......................................................................................... 430
RA SIM Register .............................................................................................................. 431
RB SIM Register .............................................................................................................. 431
RC SIM Register .............................................................................................................. 431
RD SIM Register .............................................................................................................. 431
RE SIM Register .............................................................................................................. 431
RF SIM Register .............................................................................................................. 431
RG SIM Register .............................................................................................................. 432
RH SIM Register .............................................................................................................. 432
RI SIM Register ............................................................................................................... 432
RJ SIM Register ............................................................................................................... 432
RK SIM Register .............................................................................................................. 432
RX SIM Register .............................................................................................................. 432
v