View Only
  • 1.  [CA IDMS ODBC Driver]Restricted date type attribute violation

    Posted Mar 22, 2024 09:18 AM

    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.

  • 2.  RE: [CA IDMS ODBC Driver]Restricted date type attribute violation

    Broadcom Employee
    Posted Mar 25, 2024 10:23 AM


    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

  • 3.  RE: [CA IDMS ODBC Driver]Restricted date type attribute violation

    Posted Mar 26, 2024 11:40 AM

    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