-
Oracle 10g+
- Using statement delimiter of ;
- PL/SQL blocks starting with DECLARE or BEGIN and finishing with END; /
- MySql 5.1+
- PostgreSql 9.0+
- Derby 10.8.2.2+
- SAP HANA
- SQL Server 2008+
- MariaDB 10.0+
- Vertica 6.5+
- H2 1.2.137+
- solidDB 6.5+
- SQL Azure
- DB2 9.7+
- AWS Redshift
- Hsql 1.8+
- Sybase ASE12.5+
- SQLite 3.7.2+
- DB2 z/OS 9.1+
- EnterpriseDB 9.4+
- Phoenix 4.2.2+
- Greenplum 4.3+
FDJDBC_DRIVER_PATH).
Project Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
Ignore Failure Default |
| No | When populating or evaluating files, set the Ignore SQL Compilation Errors attribute to true for files with these extensions. |
Ignore Compile Error Extensions |
| No | When populating or evaluating files, set Ignore Failure to true for files with these extensions. |
Property Replacement Default |
| No | When populating or evaluating files, default Property Replacement to this. |
Retry Count Default |
| No | When populating or evaluating files, default the Retry Count to this. (0-5) |
SQL Extension Order |
| No | The order of sql extensions that you want to use when populating and sorting files. Files should be sorted as needed at or before build time. Defaults to “seq,tbl,idx,typ,tps,tpb,sql,pkh,plb,pks,pkb,pls,pck,fnc,trg,spc,bdy,prc” |
Project File Includes |
| No | Controls files included in Project Files. Enter expressions separated by ##. Leave empty to select all files. Begin or end the expression with * for simple wildcards. Otherwise, regex |
Project File Excludes |
| No | Controls files excluded from Project Files. Enter expressions separated by ##. Leave empty to select all files. Begin or end the expression with * for simple wildcards. Otherwise, |