...
Example: work with a database table (actions PG_ ...)
The third method is a modification of the first one. The modification is based on the fact, that work with a database table does not require the CONNECT and DISCONNECT actions.
...
use the action:
Transfer of handle to database connection between the running ESL scripts
Conversion and representation of values in the database
...
| Kotva | ||||
|---|---|---|---|---|
|
...
Reading/writing data from/to archive, deleting data.
- CALCARCHEXPR
- CALCARCHEXPRCALCONDEMANDSTAT
- CALCSTATFUNC
- CALCSTATFUNCARR
- DELETEARCHDATA
- GETARCHARR
- GETARCHARR_TO_CNT
- GETARCHCOL
- GETARCHROW
- GETARCHSTRUCT
- GETARCHVAL
- INSERTARCHARR
- UPDATEARCHVAL
...
Working with large-scale local structures sometimes requires to classify a structure, insert or delete a row, or find a row. ESL permits such operations, but they require the iteration of a particular structure in a loop. It is a time-consuming task. ESL, therefore, defines the following actions, which execute the described operations more effectively:
- COPYCOL
- COPYCOLIDX
- DELETE
- EXPORT_CSV
- EXPORT_CSV_TEXT
- FIND_TRUE
- GETCOLTIME
- GETROWDESC
- IMPORT_CSV
- INSERT
- SETCOLTIME
- SORT
- TRANSCOLTOROW
- TRANSROWTOCOL
...