SQL commands
The following SQL commands are used in the examples:
- select: select *: Sections Data input with SQL statements, Dense vs. sparse data format, Reading several arrays from a single table, Reading an array from several tables, select with specification of fields: Sections Data input with SQL statements, Outputting solution values, Reading an array from several tables, Selection of columns/fields, select with conditions: Section SQL selection statements.
- insert: Sections Data output with SQL statements, Outputting solution values, Outputting several arrays into a single table, Selection of columns/fields.
- create table: Sections Outputting several arrays into a single table, Selection of columns/fields.
- delete: Section Data output with SQL statements.
- drop table: Section Selection of columns/fields.
- update: Sections Outputting solution values, Selection of columns/fields.
© 2001-2020 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.