Category Archives: Reference

esProc’s reference.

Reference:11. Flow of Program in esProc

In esProc, you can use various judgment and loop statements just as in the normal program language to implement the program design of choice structure and repetitive structure. Unlike JAVA and other high level languages, esProc use the straightforward format … Continue reading

Posted in Reference | Tagged , , , | Leave a comment

Reference:10. Modify Sequence and TSeq

The same syntax for array assignment in Java also applies to the sequence modification in esProc, that is, you can just assign directly to the member at appointed position to implement it.  Besides, similar to SQL statement, you can also … Continue reading

Posted in Reference | Tagged , , , | Leave a comment

Reference:9. Grouping Record in TSeq

To collect statistics and analyze data often requires grouping the records of a TSeq or RSeq according to certain conditions. The commonest group is the Equal Group. Distribute the records from a TSeq or RSeq to several groups according to … Continue reading

Posted in Reference | Tagged , , | Leave a comment

Reference:8.Sort on Record in TSeq

Since the field of record has no data type requirement, you can assign any value. To assign the value to another record, you can conveniently implement the foreign key reference.  8 After executing the derive command, in the TSeq of … Continue reading

Posted in Reference | Tagged , , | Leave a comment

Reference:7.Locate and Filter the Record in TSeq

When analyzing the data in the TSeq, you will usually need to search for the records satisfying the conditions according to the requirements. In esProc, if there is a value in a cell, then the value of this cell can … Continue reading

Posted in Reference | Tagged , , | Leave a comment

Reference:6. Collect Statistics on TSeq

To collect statistics based on the data from database, we often perform the count, sum, min value computations, and other operations on the database record. In esProc, you can perform various converge computation in the TSeq, such as count, sum, … Continue reading

Posted in Reference | Leave a comment

Reference:5.Retrieve TSeq from Database

To retrieve TSeq from database, you will have to connect with the relational database in the Datasource Manager of esProc: 1) Click the Tool -> Datasource connection menu item, open the Datasource Manager. 2) Create a new datasource, and select … Continue reading

Posted in Reference | Tagged , , | Leave a comment