Reputation: 1
SSMA 18.8 - No column returned from DB2 table?
I am trying to migrate a DB2 table on a System i to SQL Server 2019. The migration assistant returns this error from DB2.
Unable to show data for the unloaded table for the following reason: Loading columns for table or view failed. Column or global variable *N not found. SQLSTATE: 42703, SQLCODE: -206||No columns were returned from the database for table.
How do i correct this?
Upvotes: 0
Views: 398
Answers (2)
Reputation: 21
I had the same issue, the assistant made an SQL query that was not valid on System i (select on a NULL column) when it discovers table structure.
This issue is fixed on the latest version of SSMA for DB2 (v8.20) : "Fix tables discovery for DB2 for i". I updated to the v8.20 and it works for me.
You can check the changelog in the documentation: https://learn.microsoft.com/en-us/sql/ssma/db2/what-s-new-in-ssma-for-db2-db2tosql?view=sql-server-ver15
Upvotes: 2
Related Questions
- DB2 ERRORCODE=-4229, SQLSTATE=null
- DB2 query Unknown column name ERRORCODE=-4460, SQLSTATE=null
- SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null
- IBM Db2 net driver SQL error. Not finding table name?
- Zero not returning in DB2 when select query yields no result
- Error Code -193 on db2
- Column or global variable not found
- Why won't DB2 use my MQT table?
- DB2 + JPA throwing an error: column not found in the table
- Existing DB2 column reported as not being a column of the table