Easysoft ODBC-Zortec System Z Driver

Why does Query Builder in DTS fail to copy data from Zortec System Z?

Last Reviewed:
18th January 2024

When using the DTS to copy data, you can choose to copy a table or use the query builder to copy selective data. The Copy Table option correctly displays the "Z" schema name and works. The Query Builder does not show the "Z" schema name and misses it from the produced query. As a result, when you run Query Builder, the SQLPrepare DTS issues fails with "base table or view not found". To get around this problem in DTS, add no_schema=1 to the DSN in your odbc.ini file. See the INSTALL file in /usr/local/easysoft/sqi/systemz for further details about the available DSN options.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)