Introduction › › For SQL Access

For SQL Access

With SQL access, you can process data by either Procedure Definition Language (PDL) statements or embedded SQL Data Manipulation Language (DML) statements. The data is treated as an actual collection of rows, with references made to any column by that column's name. In reality, these columns could comprise an entire row of a table or they could be a set of non‑contiguous columns as defined in a view.

Note: SQL tables follow normalized rules and do not have group fields, occur, or redefines. SQL conventions do not support the hyphen; underscore is used instead.