category:Getting Started

Getting Started about esProc

esProc Getting Started: Option Syntax

1. esProc’s function options Many functions in esProc can use function options with which the same function can have different work patterns. The basic format of function options is f@o(…) in which o is f function’s option. For example:   A B 1 2004-5-5 2014-7-7 2 =interval(A1,B1)   3 =interval@y(A1...

2015-02-18 36 0 0

esProc Getting Started: Use of Common Data

To make data analysis, first you need to load the original data. The data used most frequently comes from the text files or the databases. In esProc, you can load data from the text files or the databases easily and quickly. 1. Text file data esProc can loaddata from a text file as a table sequence. For example, the te...

2015-02-11 36 0 0

esProc Getting Started: Multilayer Parameters

esProc provides a large number of functions, many of which use many parameters. In order to clearly judge the positions of these parameters and make writing and reading easier, esProc is specially equipped with multilayer separators of function parameters. 1. Separators of function parameters Colon (:), comma (,) and s...

2015-02-10 33 0 0

esProc Getting Started: Constants

In esProc computing, we use constants frequently or sometimes store the data in the cellset directly. In this article, let’s learn the usage of constants in the esProc. 1. Directly using constant in the expressions Constants can be directly used in the esProc expressions:   A 1 =64*32 2 =round(1.45*5.5) 3...

2014-11-13 35 0 0

Getting Started: Basic Usage of JDBC

esProc can be embedded into Java program. So the latter can call the cellset program written in esProc using a way of connection such as JDBC. The method of calling the esProc program is the same as that of calling the stored procedure. The following is a brief introduction to esProc JDBC.  1. Description of the j...

2014-11-12 59 0 0

esProc Getting Started: Basic Data Types

1. Data types in esProc In esProc, the following basic data types are available: Integer Any integer between -231 and 231-1, i.e. the value range is -2147483648~2147483647. The type conversion function int() can be used to convert other types of data into integer. Long integer -263~263-1, which is a value range bigger ...

2014-11-05 34 0 0

esProc Getting Started :Cell Editing

1. Cell Copy and Paste In esProc, you can press Ctrl+C and Ctrl+V to copy data or an expression in some cell and paste it on the target done. But unlike EXCEL, the copy and paste operations on the cell will not perform the adjust-paste on the expression automatically. If you need to adjust the cell quoted by the expre...

2014-11-04 36 0 0

esProc Getting Started: Types of Cells

In esProc, cells are automatically classified into different types according to their values or the expressions they contain. In a cellset, each type of cell has its own appearance, which highlights the code in the cells. 1.Types of cells 1.1    Constant cell A cell in which the cell string can be interpreted as the co...

2014-11-04 42 0 0

esProc Getting Start : Installation and Basic Use

esProc is a tool for programmed data computing. It can execute various types of data analysis and structured data computing, as well as get access to the database freely and perform online data analysis. 1. Installation You can download esProc installation package on the following official website: http://www.raqs...

2014-11-03 48 0 0