I'm always interested in SQL questions. For those of us watching could you include:
The record layout -- change any element names you need to, leave in all the group structures if any.
The SQL command that is failing.
I also research using IDMSBCF to see if I get the same errors.
I like the HEX(column_name) to see what is there. And route the IDMSBCF output to a file instead of SYSLST
Original Message:
Sent: Mar 25, 2024 10:22 AM
From: Ken Grant
Subject: [CA IDMS ODBC Driver]Restricted date type attribute violation
Hi,
The ODBC driver supports the conversion of packed decimals, so obviously there is something about the data that it cannot process. It is difficult to say if it is all the data in the column or only data in particular rows. One thing you could try is to set the Invalid Decimal Action to a value such as Ignore, Return Null or Return 0. To get to this option do the following:
- Configure the data source in the ODBC Driver Manager
- Select the Current button under the Advanced Options.
- Change the value for Invalid Decimal Action
- Save the changes and retest
Note that this is only to get around the problem but not solve it. For more assistance please open a ticket with support.
Ken Grant
IDMS Support
Original Message:
Sent: Mar 21, 2024 12:44 PM
From: Manoj Narindi
Subject: [CA IDMS ODBC Driver]Restricted date type attribute violation
I am trying to run a query, Database is mainframe, to fetch result.
select column_4 from database.dbo.table_2;
but receiving an error "[CA][CA IDMS ODBC Driver]restricted data type attribute violation". And this error is only for column_4, not for column_1,2,3,5 in a table. This single column is packed data type.
Can anyone help configure CA IDMS server windows ODBC driver to resolve this issue. and fetch the column data.