Problems in iSeries with Entity Framework

56,495 pts.
Tags:
DB2Connect
EDMX
Entity Framework
iSeries AS/400
Working in AS/400 withDB2Connect with Entity Framework, trying to create a EDMX file in iSeries.  I can see that records have been produced but cannot save them. I get this error message:
ERROR [55019] [IBM][AS] SQL7008N  REXX variable "INVENTORY " contains inconsistent data.
My initial research suggests the problem is that the table is not journeled, but I don't know how to change that setting.  Any help?
ASKED: December 24, 2013  4:07 PM
UPDATED: December 24, 2013  4:48 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta

    It does commonly seem that the table is not journaled, especially if "INVENTORY" is the table name. Practically speaking, no remote table should be updated remotely if it's not journaled. I don't know how you configure your connection settings(, and, really, remote database updates should only be done if you do know how to configure the connections). Look for any reference to transaction isolation levels or commits.

    But it could also be that you have one (or more) columns that have data types that are not compatible with the data types of the values you are sending.

    Tom

    125,585 pointsBadges:
    report
  • TomLiotta
    And why are so many recent questions answered months or years ago in other forums, worded almost exactly the same? I've noticed it multiple times lately. -- Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following