Skip to main content

SQL actions

List of JSON DB API actions for running SQL

Abstract

List of SQL actions in the JSON DB API, which you can use to query data, manipulate data, and manage database objects. These actions work for all FairCom products that include the FairCom database engine.

List of SQL actions in the JSON DB API, which you can use to query data, manipulate data, and manage database objects. These actions work for all FairCom products that include the FairCom database engine.

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.

Notice

JSON DB API transactions do not support SQL stored procedures, stored functions, and triggers. It also does not support "revertTransactionToSavepoint" when the transaction contains a call to "getRecordsUsingSQL" or "runSqlStatements". Unsupported actions return an error.

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.