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

Easysoft ODBC-Zortec System Z Driver

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

Article :	00728
Last Reviewed :	19th July 2005
Revision :	1

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 of DSN options.

Applies To

Products
- Easysoft ODBC-Zortec System Z Driver

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft ODBC-Zortec System Z Driver

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

Applies To

Knowledge Base Feedback