Data360 Analyze

 View Only

  • 1.  DB Store node in Data360 Analyze cannot do insert to table db2 database

    Employee
    Posted 07-25-2021 23:41

    Hi Data360 Team,

    We have issue regarding of using [DB Store] to insert data to db2 table.

    Can you share how to configure DB Store node for db2 database?

    Thanks,
    Chandara

     

    Attached files

    DB Store node error db2.jpg

     



  • 2.  RE: DB Store node in Data360 Analyze cannot do insert to table db2 database

    Employee
    Posted 07-26-2021 02:17

    The execution warning SQL7008 - xxxxxx in xxxxx not valid for operation is being returned by the DB Driver from the DB, it is not being generated by the Analyze software. 

    Looking online for the details of the warning would indicate you need to turn on jounaling for the DB2 Table

     

    https://www.ibm.com/support/pages/error-delivering-data-db2-udb-iseries-access-odbc-connection

    https://www.ibm.com/support/pages/table-read-only-odbc-application-requirements-updating-os400-or-i5os-tables

     

     



  • 3.  RE: DB Store node in Data360 Analyze cannot do insert to table db2 database

    Employee
    Posted 07-26-2021 06:07

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Have you tried with JDBC Store? The DB2 driver is shipped with Analyze. However if it's something you need to configure in the database, and not some driver issue, then this probably won't help you.



  • 4.  RE: DB Store node in Data360 Analyze cannot do insert to table db2 database

    Employee
    Posted 07-27-2021 01:40

    As an alternative to enabling jounaling on the database table you may be able to modify your SQL statement to include WITH NONE or WITH NC at the end of the statement.