5 Use SPL in applications ★

 

0. Integrated application method

0.1 How to Call an SPL Script in Java

0.2 How to Call an Remote SPL Script in Java

0.3 How to Call an SPL Script in BIRT

0.4 How to Call an SPL Script in C#

0.5 How to Call an SPL Script in JasperReport

0.6 How to Call an SPL Script using HTTP Service

0.7 esProc Boot Time Auto-Start Service

0.8 Use external libraries

1. Review articles

1.9 Looking for the Best Java Data Computation Layer Tool

1.10 Cross-database Computing Methods

1.11 Looking for the Best Class Library for Computing MongoDB Data

1.12 Looking for the Best SQL-On-File Tool

1.13 Looking for the Best Post-SQL Scripting Tool

1.14 Looking for the Best Programming Language for Processing Excel Files

1.15 Looking for the Best Class Library for Computing JSON Data

1.16 Looking for the Best Class Library for Computing XML Data

1.17 Drawbacks of Using Stored Procedures to Compute Data

2.Comparison with SQL

2.18 Set operations

2.19 Select operation

2.20 Ordered operation

2.21 Grouping   2   3

2.22 Join   2   3

2.23 Transposition   2   3

2.24 Recursion

3. Structured data calculation

3.25 Loop operations

3.26 Accessing members of data set by sequence numbers

3.27 Locate operations on ordered sets

3.28 Alignment operations between ordered sets

3.29 TopN operations

3.30 Existence checking

3.31 Membership test

3.32 Unconventional aggregation

3.33 Alignment grouping

3.34 Select operation

4. File calculation

4.35 General table operations

4.36 Merging and splitting files

4.37 Comparing files

4.38 Performing distinct on files

4.39 Quering SQL on files

4.40 Parsing Excel files

4.41 Generating various Excel files

4.42 Processing big text files

SPL CookBook——Classified examples

More Java&SQL calculation examples