API Data Provider - Online Help

SQL Compliance

The API Profile supports several operations on profile data, including selecting and executing procedures.

SELECT Statements

The API Profile supports SQL-92 Syntax. SELECT Statements includes a comprehensive list of the suported keywords and clauses, as well as syntax reference and examples.

SQL Functions

In addition to standard SELECT statement clauses, the API Profile supports additional functionaliy. See SQL Functions for documentation and examples of SQL functions that are supported in SELECT queries, including STRING Functions, DATE Functions and MATH Functions.

EXECUTE Statements

Use EXECUTE or EXEC statements to execute stored procedures, when functionality cannot be represented diretly as a SELECT, INSERT, UPDATE or DELETE statement. See EXECUTE Statements for a syntax reference and procedure examples.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7711.0