Sage 100 Providex SQL Syntax for ETL+ Extract SQL Statement panel

🚧 Work in progress. SQL syntax allowed and not allowed in the ETL+ Extract SQL Statement Panel for Sage 100 ProvideX / ODBC data sources.

SQL Syntax Examples

SQL

SELECT  1 AS myInt FROM AP_Division        -- Syntax OK
SELECT 1 as myint, {d'1900-01-01'} as myDate FROM AP_Division

? SELECT DateUpdated AS filterDate FROM AP_Division  -- retest

SQL Comments

SQL

SELECT 1 as myint
-- {d'1900-01-01'} as myDate    
FROM AP_Division

Line 2 commented out

SQL Syntax Not Allowed

Not working on ETL+ version v2023.10.1905.52

SQL

SELECT  GETDATE() AS mydate FROM AP_Division       -- illegal syntax for Providex
SELECT  CURDATE() AS myDate  FROM AP_Division

Error Messages

Error message for illegal syntax in
ETL+ ETL+ Extract SQL Statement Panel

Related Pages

"The connection failed during the table mapping" – Error message for syntax in ETL+ Extract SQL Statement Panel
ETL+ Load Replace with Date-time fields
ETL+ for Sage 100 Providex
Sage 100 Documentation: https://manual.pvxplus.com/PXPLUS/odbc/using_odbc_driver/scalar_functions.htm – see section on Time and Date Functions