Skip to main content

API actions (sql)

Action

Description

getRecordsUsingSQL

"getRecordsUsingSQL" uses SQL to retrieve a set of records.

runSqlStatements

"runSqlStatements" runs one or more SQL statements, such as drop, create, alter, call, insert, update, and delete statements.

Structured Query Language (SQL) is a standardized programming language that is used to manage relational databases and perform various operations on the data in them.

FairCom's SQL engine is ANSI compliant and has almost all SQL features up through the SQL:2003 standard.