tag:blogger.com,1999:blog-399188050419294563.post5843585404355810168..comments2023-04-27T07:38:57.596-04:00Comments on IBMi Information Tech in the trenches: SQL Update a Multi-Table View using INSTEAD OF TriggersRichard Bryanthttp://www.blogger.com/profile/07019592358910271871noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-399188050419294563.post-21571525574610912722013-11-28T01:49:40.562-05:002013-11-28T01:49:40.562-05:00Thanks for share helpful information guys
Website ...Thanks for share helpful information guys<br /><a href="http://www.sinelogix.com/services/website-design.html" rel="nofollow">Website Design Company in Bangalore</a>Sinelogixhttps://www.blogger.com/profile/03753447067548332551noreply@blogger.comtag:blogger.com,1999:blog-399188050419294563.post-68420046527929599282013-02-21T10:53:44.696-05:002013-02-21T10:53:44.696-05:00ooppps again....it's tough teaching yourself h...ooppps again....it's tough teaching yourself how things work...the library needs to be qualified. Duh! The trigger in on the view so I have to create two triggers one for production file and one for test file. This probably will not work for test since I refresh test every night from production. SQL and the library list are don't seem to work as I know it.<br /><br />create trigger r50mods/ediinvdel <br />Instead of delete on b50files/ediinvw <br />referencing old as EdiInvwOld <br />for each row mode DB2SQL <br />begin atomic <br /> delete from b50files/vedinih <br /> where ihedoc = EdiInvwOld.ihedoc; <br /> delete from b50files/vedinid <br /> where idedoc = EdiInvwOld.idedoc; <br /> delete from b50files/vediniss <br /> where iaedoc = EdiInvwOld.iaedoc; <br /> delete from b50files/vedinis <br /> where isedoc = EdiInvwOld.isedoc; <br />end Richard Bryanthttps://www.blogger.com/profile/07019592358910271871noreply@blogger.comtag:blogger.com,1999:blog-399188050419294563.post-57048713906620301272013-02-21T10:23:07.359-05:002013-02-21T10:23:07.359-05:00ooops....I made a small mistake copying code and f...ooops....I made a small mistake copying code and forgot to change the file names for file 3 and 4.<br /><br />create trigger r50mods/ediinvdel <br />Instead of delete on ediinvw <br />referencing old as EdiInvwOld <br />for each row mode DB2SQL <br />begin atomic <br /> delete from vedinih <br /> where ihedoc = EdiInvwOld.ihedoc; <br /> delete from vedinid <br /> where idedoc = EdiInvwOld.idedoc; <br /> delete from vediniss <br /> where iaedoc = EdiInvwOld.iaedoc; <br /> delete from vedinis <br /> where isedoc = EdiInvwOld.isedoc; <br />end Richard Bryanthttps://www.blogger.com/profile/07019592358910271871noreply@blogger.com