Updated: 10/28/2020, 12:05:40 PM
Created: 10/28/2020, 12:05:40 PM
Last Updated By: Mike Street
Read Time: 1 minute(s)
This environment variable is used to designate the file used by SQL queries to a jBASE database to expose regular jBASE files/dictionaries as tables/columns for either local or remote (ODBC) SQL queries.
The file can be a jBASE hashed file or a directory, as long as it's location is in your JEDIFILEPATH.
CREATE-FILE c:\jbase\SQLCATALOG 1 11 set JSQLFILENAME_CATALOG=c:\jbase\SQLCATALOG
CREATE-FILE /dbms/SQLCATALOG 1 11 set JSQLFILENAME_CATALOG=/dbms/SQLCATALOG