Welcome to jBASE's new documentation site! Many answers to your questions can be found by searching the Knowledgebase or viewing the jBASE Documentation. We also have a Google Group for peer discussion about jBASE. If you are unable to find the information you are looking for, jBASE Support will be glad to assist in resolving your technical problems. Enjoy and please provide comments and feedback .

How can we help you?

JSQLFILENAME_CATALOG

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

e.g. non-Windows 

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

See SQLCATMAN.

Was this article helpful?