This article explains why a table that should be loaded into syscat might not be available using AcuXDBC on a Linux operating system.
A table is not available using AcuXDBC in a Linux environment. The .xfd file has been loaded, the FILE_PREFIX environment variable is correctly set, the Vision file is available, but AcuXDBC cannot see the table.
Using asql.sh, this is the error:
SQL (/? for help) ==> select count(*) from abcd;
select count(*) from art
***** ERROR: VISION: File 'abcd' does not exist
It's possible that the Vision file has an upper-case name, while the rest of the information (such as the table name inside the .xfd file) is lower-case.
Check the name of the Vision file, or set this variable in the acuxdbc.cfg file:
# Values for File_Case are Default (case ignored),
# Lower (filename converted to lower case), and
# Upper (filename converted to upper case).