Sends a DBMS-specific SQL statement to a DBMS that FedSQL supports.
| Category: | FedSQL Pass-through |
| Data source: | Aster, DB2 under UNIX and PC, Greenplum, HAWQ, HDMD, Hive, MySQL, Netezza, ODBC, Oracle, PostgreSQL, SAP HANA, Sybase IQ, Teradata |
| See: | Data Source Connection |
| FedSQL Explicit Pass-Through Facility | |
| SQL documentation for your DBMS |
specifies a native SQL query that can be run on the catalog’s driver. The EXECUTE statement accepts statements that produce a result set, as well as statements that do not produce a result set.
| Restriction | PROC FEDSQL does not support native syntax that contains embedded bare semicolons. You can, however, use the FedSQL language processor to run these statements. |
| Note | The SQL statement might be case-sensitive, depending on your data source, and it is passed to the data source exactly as you enter it. |
specifies the name of a catalog in the existing FedSQL connection.
execute(create table t_blob (col1 blob)) by saphana; execute(drop table t_blob) by saphana;
execute(select i, rank() over (order by j) rank from table_a ) by oracle;