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.