Inconsistent ODBC Connection to AS400 Data Tables

Al_22614
Al_22614 Altair Community Member
edited December 2019 in Community Q&A
Hello All:

I have several Monarch Models connected to AS400 data tables via ODBC connection.  Originally,  I mapped a subset of the available fields for use in the Models.  Subsequently, for additional data requirements, I added several fields from the AS400 data tables.  My problem is the additional fields are not consistently maintained in the database link.  I have checked the embedded AS400 login id and password in the ODBC connection and there is no problem there.  

Hopefully I have described my problem well.  Has anyone else experienced such problem and have recommended fix?

Thanks in advance for your help.

------------------------------
Al Rice
------------------------------
Tagged:

Answers

  • Baba_Majekodunmi_703
    Baba_Majekodunmi_703
    Altair Employee
    edited December 2019
    Hi Al,

    I'm not familiar with AS400, but I do have a question: Are you using Monarch Classic, or Data Prep Studio? There should not be a difference, but there might be.

    ------------------------------
    Baba Majekodunmi
    Solutions Consultant
    Altair Engineering Inc.
    Manassas VA
    978-275-9325
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 12-12-2019 08:14 PM
    From: Al Rice
    Subject: Inconsistent ODBC Connection to AS400 Data Tables

    Hello All:

    I have several Monarch Models connected to AS400 data tables via ODBC connection.  Originally,  I mapped a subset of the available fields for use in the Models.  Subsequently, for additional data requirements, I added several fields from the AS400 data tables.  My problem is the additional fields are not consistently maintained in the database link.  I have checked the embedded AS400 login id and password in the ODBC connection and there is no problem there.

    Hopefully I have described my problem well.  Has anyone else experienced such problem and have recommended fix?

    Thanks in advance for your help.

    ------------------------------
    Al Rice
    ------------------------------
    "
  • Al_22614
    Al_22614 Altair Community Member
    edited December 2019
    Baba Majekodunmi_21731 said:

    Hi Al,

    I'm not familiar with AS400, but I do have a question: Are you using Monarch Classic, or Data Prep Studio? There should not be a difference, but there might be.

    ------------------------------
    Baba Majekodunmi
    Solutions Consultant
    Altair Engineering Inc.
    Manassas VA
    978-275-9325
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 12-12-2019 08:14 PM
    From: Al Rice
    Subject: Inconsistent ODBC Connection to AS400 Data Tables

    Hello All:

    I have several Monarch Models connected to AS400 data tables via ODBC connection.  Originally,  I mapped a subset of the available fields for use in the Models.  Subsequently, for additional data requirements, I added several fields from the AS400 data tables.  My problem is the additional fields are not consistently maintained in the database link.  I have checked the embedded AS400 login id and password in the ODBC connection and there is no problem there.

    Hopefully I have described my problem well.  Has anyone else experienced such problem and have recommended fix?

    Thanks in advance for your help.

    ------------------------------
    Al Rice
    ------------------------------
    "

    Hello Baba Majekodunmi

    Thanks for your reply.  Please note that I am using Monarch Classis Version 15.4. 

    Hopefully, I can get some guidance from the community.

    Thanks,

    ------------------------------
    Al Rice
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 12-13-2019 04:26 PM
    From: Baba Majekodunmi
    Subject: Inconsistent ODBC Connection to AS400 Data Tables

    Hi Al,

    I'm not familiar with AS400, but I do have a question: Are you using Monarch Classic, or Data Prep Studio? There should not be a difference, but there might be.

    ------------------------------
    Baba Majekodunmi
    Solutions Consultant
    Altair Engineering Inc.
    Manassas VA
    978-275-9325
    ------------------------------

    Original Message:
    Sent: 12-12-2019 08:14 PM
    From: Al Rice
    Subject: Inconsistent ODBC Connection to AS400 Data Tables

    Hello All:

    I have several Monarch Models connected to AS400 data tables via ODBC connection.  Originally,  I mapped a subset of the available fields for use in the Models.  Subsequently, for additional data requirements, I added several fields from the AS400 data tables.  My problem is the additional fields are not consistently maintained in the database link.  I have checked the embedded AS400 login id and password in the ODBC connection and there is no problem there.

    Hopefully I have described my problem well.  Has anyone else experienced such problem and have recommended fix?

    Thanks in advance for your help.

    ------------------------------
    Al Rice
    ------------------------------
    "
  • Mahmoud
    Mahmoud
    Altair Employee
    edited December 2019
    Baba Majekodunmi_21731 said:

    Hi Al,

    I'm not familiar with AS400, but I do have a question: Are you using Monarch Classic, or Data Prep Studio? There should not be a difference, but there might be.

    ------------------------------
    Baba Majekodunmi
    Solutions Consultant
    Altair Engineering Inc.
    Manassas VA
    978-275-9325
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 12-12-2019 08:14 PM
    From: Al Rice
    Subject: Inconsistent ODBC Connection to AS400 Data Tables

    Hello All:

    I have several Monarch Models connected to AS400 data tables via ODBC connection.  Originally,  I mapped a subset of the available fields for use in the Models.  Subsequently, for additional data requirements, I added several fields from the AS400 data tables.  My problem is the additional fields are not consistently maintained in the database link.  I have checked the embedded AS400 login id and password in the ODBC connection and there is no problem there.

    Hopefully I have described my problem well.  Has anyone else experienced such problem and have recommended fix?

    Thanks in advance for your help.

    ------------------------------
    Al Rice
    ------------------------------
    "

    Hi Al,
    You may try redoing the connection to AS400 from scratch.  Create a new model, connect to the AS400 using the ODBC and select fields that you need for your model.  Add any filters, sorts, calculated fields, summaries, etc, that you created in the original model to the new model.
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 12-13-2019 04:26 PM
    From: Baba Majekodunmi
    Subject: Inconsistent ODBC Connection to AS400 Data Tables

    Hi Al,

    I'm not familiar with AS400, but I do have a question: Are you using Monarch Classic, or Data Prep Studio? There should not be a difference, but there might be.

    ------------------------------
    Baba Majekodunmi
    Solutions Consultant
    Altair Engineering Inc.
    Manassas VA
    978-275-9325
    ------------------------------

    Original Message:
    Sent: 12-12-2019 08:14 PM
    From: Al Rice
    Subject: Inconsistent ODBC Connection to AS400 Data Tables

    Hello All:

    I have several Monarch Models connected to AS400 data tables via ODBC connection.  Originally,  I mapped a subset of the available fields for use in the Models.  Subsequently, for additional data requirements, I added several fields from the AS400 data tables.  My problem is the additional fields are not consistently maintained in the database link.  I have checked the embedded AS400 login id and password in the ODBC connection and there is no problem there.

    Hopefully I have described my problem well.  Has anyone else experienced such problem and have recommended fix?

    Thanks in advance for your help.

    ------------------------------
    Al Rice
    ------------------------------
    "

Categories