ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

How to use SQL Constraint logic

Collapse
X
Collapse
 
  • Page of 2
  • Filter
  • Time
  • Show
Clear All
new posts
Previous 1 2 template Next
  • #16
    Sorry for the bad info, I got the idea from an article in microsoft's dialect of sql.

    Comment

    • #17
      No problem. It would make sense to be able to do that. In some ways MS SQL is more advanced than IBM DB2 for i - this appears to be one of them.

      Comment

      • #18
        A bit late now, but an article on handling constraint violations in RPG just dropped on ITJungle:

        Guru: Handling Constraint Violations In RPG - IT Jungle
        https://www.itjungle.com/2018/09/05/guru-handling-constraint-violations-in-rpg/
        Author’s Note: The contents of this article were originally published as two separate articles – Handling Constraint Violations in RPG and Handling Constraints Revisited. The content of the article has been updated for free form RPG and some of the coding enhancements that have been introduced, into RPG, since 2009. Constraints have been around for

        Comment

        • #19
          vector,
          Never too late for new information...

          Thank you!

          Comment

          • #20
            You're welcome

            Though I now notice the article uses job log analysis instead of get diagnostics to get the constraint name

            Comment

            Previous 1 2 template Next
            Working...
            X