I have a mainframe database, and I am moving the data to a sql server.
I have CA IDMS ODBC driver installed.
I am querying a table which contains 5 columns. out of which 1 column is packed data. And while syncing the data from mainframe to sql server, using a query, I am receiving an error.
And for other columns in the same table which are not regular data type (numeric, char , etc., not packed data) the query is executed and result is output.
Error:
STAT:2 ERR:-2147467259 SQLSTATE:S1000 Microsoft OLE DB Provider for ODBC Driver : [CA][CA IDMS ODBC Driver]Restricted data type attribute violation
Query:
Select column_4 from database.dbo.table_3
I have also tried to run a query - if null 0 else 1. But received the same error
Query:
SELECT
CASE
WHEN column_4 IS NULL THEN 0
ELSE 1
END AS new_column
FROM database.dbo.table_3;
Question:
How to resolve this issue ?
Is there anything need to be configured on ODBC data source ?