# JSQLFILENAME_CATALOG

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.

e.g. Windows

CREATE-FILE c:\jbase\SQLCATALOG 1 11
set JSQLFILENAME_CATALOG=c:\jbase\SQLCATALOG
1
2

e.g. non-Windows

CREATE-FILE /dbms/SQLCATALOG 1 11
set JSQLFILENAME_CATALOG=/dbms/SQLCATALOG
1
2

See SQLCATMAN.