Axional development libraries
Server side javascript
AX Library
db
db
Preview
Content
14
Media
2
Back to parent
Database interface
Database connection
Multiple connections
Direct non pooled connections
Return data types
Prepared statement cache
Temporary tables
Debugging SQL statements
Profiling SQL statements
Debugging SPL statements
Exception handling
Altering tables in production
Complex types
BLOB data type
ROW data type
MULTISET data type
BSON data type
Database functions
Database functions
SUBSTR(source_string,start_position,length)
LENGTH(source_string)
UPPER(source_string)
LOWER(source_string)
TRIM(source_string)
RTRIM(source_string [,pad_string])
LTRIM(source_string [,pad_string])
LPAD(source_string, lenght [, pad_string])
RPAD(source_string)
NVL(expr1, expr2)
Database Metadata
Objects existence
Getting metadata
DML Statements
Sample table
Insert statement
Update statement
Delete statement
Update or Insert statements
Moving (reordering) rows
DQL Data Query Language
Writing a statement
Quering a database
Executing statements
Select statement
Database ResultSets
Pivot ResultSet
ResultSet to HTML
ResultSet to JSON
ResultSet to PDF
ResultSet to XML
ResultSet to CSV
Memory ResultSets
Data mapping
Stored Procedures
Calling functions
Calling Procedures
Table Copy
Using table copy
Copy a database
TableMetaData
Get table metadata
Column metadata
Table Statements
Table lock
Table copy
TCL commands (transactions)
Automatic commit on finish
Transaction rollback
Programatic control
Holdable resultsets
Text Search
Text search functions
Creating a BTS Index
SQL Best Practices.60
Union to force cartesian products
CTE and Derived Tables
Multiuser Environment and Process Concurrency
API
DB
JSResultSet
Image
Name
Size (kB)
cars.csv
609.74
DataType-Row-1.png
609.74
cars.csv
DataType-Row-1.png
×