Structure Query Language (SQL): Chapter 4 – Backup.
The main task in a Database manager is to not just make sure all data is inserted, but also that these data continue existing. Regardless of the contingency system, the…
Category: DataBases
Structure Query Language (SQL): Chapter 6 – SQL Commands.
This article illustrates a few SQL commands. To illustrate how they are used, the following tables will work as reference: Store_Information table: Store_Name Sales Date_Time Los Angeles 1500 05-Jan-1999…
Structure Query Language (SQL): Chapter 5 – Best practices for setting up Historics and Queries.
Historics are the modules responsible for storing application data in a Database for further analysis. You can create as many Historics as needed, each containing several Tags or expressions. Each…
Structured Query Language (SQL): Introduction.
This is the introduction to a series that will discuss SQL, the widely known language used for relational databases. The Structured Query Language (SQL), a very popular one for interacting…
Structure Query Language (SQL): Chapter 1 – Manipulating information in the DB.
Basically, information can be manipulated in the Database in three different ways: DML – Data Manipulation Language Statements: INSERT, UPDATE, DELETE, SELECT DDL – Data Definition Language Statements: CREATE, ALTER,…
Structure Query Language (SQL): Chapter 2 – SQL Server Database’s Files and Logs.
Every SQL Server database has at least two operational system files: a data file and a log file. The data files contain both data and objects, such as tables, indexes,…
Structure Query Language (SQL): Chapter 3 – Data Discard and DB Limits.
There is an important tool in Elipse E3 to help monitor a database, called data discard (available when setting up Historics, Storages, and Alarm Tables). This option enables data discard…
Checking the space being used by an SQL database.
Question: How can I check the size of an SQL database? Solution: To do so, you must run a Stored Procedure, available in the database. To run it in E3,…
KB-31594: Processing data from a Query.
Question: On a network containing a machine dedicated specifically to the Data Server and others to E3, where is the data from a Query inside the Viewer processed: in the…
KB-13968: Executing a StoredProcedure via E3.
Question: How can I execute an Oracle’s StoredProcedure via E3? Solution: In a Query, use the SQL command “call” + StoredProcedure name. For example: – E3 Query: call HourmeterIncrement(‘I724EMD1111’,1) –…