What tables should I use for ODBC queries?

Updated on 18 Jan 2023
Contributors

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

The FIMS schema show tables that start with "SQL_" and others, with the same table name and no prefix. Which tables should link to using ODBC or JDBC? What is the difference between the two/how does FIMS use these tables?
Display FIMS Tables and Fields

Answer:

SQL tables are views\virtual tables which were created to convert arrays, long character fields, field names to a format that does not cause SQL errors, so it is typically best to use SQL views with ODBC.

For OBDC, you can use views or tables to query on data, but again best to use SQL.

Was this article helpful?

What tables should I use for ODBC queries?

The FIMS schema show tables that start with "SQL_" and others, with the same table name and no prefix. Which tables should link to using ODBC or JDBC? What is the difference between the two/how does FIMS use these tables?Display FIMS Tables and Fields

Answer:

The FIMS schema show tables that start with "SQL_" and others, with the same table name and no prefix. Which tables should link to using ODBC or JDBC? What is the difference between the two/how does FIMS use these tables?
Display FIMS Tables and Fields