RE: How to Add Triggers on Dicts
On the nail. Thanks WOL! CREATE TRIGGER has no problem with this. Now writing a proggie to create a dict pointer for every file required... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 05 March 2004 04:06 To: U2 Users Discussion List Subject: RE: How to Add Triggers on Dicts When you specify "DICT FILENAME", UV treats it internally as if there existed a VOC entry 0001: F 0002: D_FILENAME 0003: \uv_account\DICT.DICT There is no reason whatsoever why you shouldn't create an explicit VOC entry of exactly this form. After all, as far as UV is concerned, the D_FILENAME file is a data file, just like any other ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daly, Mark Sent: 02 March 2004 14:28 To: 'U2 Users Discussion List' Subject: RE: How to Add Triggers on Dicts Well.. It wouldn't surprise me if the CREATE TRIGGER command doesn't recognize the 'DICT' keyword. Triggers generally deal with data updates. I guess you could create a dummy file pointer that points to the dictionary as though it were a data file. Then reference that pointer when creating the trigger. BUT - I haven't tried it. Not sure I would try it. Good luck! -Original Message- From: Dennis Bartlett [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 9:20 AM To: 'U2 Users Discussion List' Subject: RE: How to Add Triggers on Dicts The trigger is currently working fine on DATA files. It's just the adding of it to DICT files that's boggling me at present. Once I've got that right, I'll have to think of some way to monitor Type 1/19 files, but that's another day. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to Add Triggers on Dicts
When you specify "DICT FILENAME", UV treats it internally as if there existed a VOC entry 0001: F 0002: D_FILENAME 0003: \uv_account\DICT.DICT There is no reason whatsoever why you shouldn't create an explicit VOC entry of exactly this form. After all, as far as UV is concerned, the D_FILENAME file is a data file, just like any other ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daly, Mark Sent: 02 March 2004 14:28 To: 'U2 Users Discussion List' Subject: RE: How to Add Triggers on Dicts Well.. It wouldn't surprise me if the CREATE TRIGGER command doesn't recognize the 'DICT' keyword. Triggers generally deal with data updates. I guess you could create a dummy file pointer that points to the dictionary as though it were a data file. Then reference that pointer when creating the trigger. BUT - I haven't tried it. Not sure I would try it. Good luck! -Original Message- From: Dennis Bartlett [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 9:20 AM To: 'U2 Users Discussion List' Subject: RE: How to Add Triggers on Dicts The trigger is currently working fine on DATA files. It's just the adding of it to DICT files that's boggling me at present. Once I've got that right, I'll have to think of some way to monitor Type 1/19 files, but that's another day. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to Add Triggers on Dicts
> > ED VOC DICT.IN.MASTER > 0001: F > 0002: E:\accounts\_source.DEV\D_IN.MASTER > 0003: E:\accounts\_source.DEV\D_IN.MASTER > Conceptually, I don't see anything wrong with what you are doing. This VOC pointer seems to be all right. The work I was on UNIX running 10.1... I don't have a Windows system handy at the moment, so I can't give you're scenario a try. > Ran this > CREATE TRIGGER AUDIT_DICT AFTER INSERT OR UPDATE OR DELETE > ON > DICT.IN.MASTER FOR EACH ROW CALLING 'RC.DATA.TRIGGER Looks good. > > Adding trigger "AUDIT_DICT" > UniVerse/SQL: Unable to open > "E:\accounts\_source.DEV\D_IN.MASTER/DICT.IN.MASTER". > UniVerse/SQL: Could not add trigger "AUDIT_DICT". No idea why the system is trying to open "E:\accounts\_source.DEV\D_IN.MASTER/DICT.IN.MASTER". The error is correct in stating that this path does not exists. But, I have no clue why the system would concatenate the VOC ITEM name -- DICT.IN.MASTER -- to the path name in attribute 2 -- E:\accounts\_source.DEV\D_IN.MASTER -- to derive the path of the file. That does not seem right. I'd probably try setting up a scenario where the values in attribute 2 and 3 are simply the name of the file -- D_IN.MASTER. Otherwise, you might give IBM a call to see if they can help. Tom Firl -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How to Add Triggers on Dicts
Dennis Bartlett wrote: Hi Mats Have you inserted it ( the dict entry ) into DICT DICT.DICT and CD'd it? Sounds promising, but a tad baffling in itself... I've found the DICT.DICT file, and viewed a sample 200 of them to see if I can find an example - alas! Please elaborate! - by {the dict entry} do you mean E:\accounts\D_the.file or ??? I know CD to be the compile thang used to compile I-type descriptors...?? If you're saying I should CD it, should it be an I-type? dennis Oh sorry, I think I've mixed up real triggers and the fake ones that have been used before the event of real triggers. I.e. an I-descriptor 'triggered' by being an index for the file. So by the dict item I was indeed refering to an I-descriptor. Anyway You may want to try fooling uv to see the dict as a file by making a VOC entry : F path to your dict path to DICT.DICT and exercise the ADD TRIGGER to this 'file'. HTH -- mats used before -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to Add Triggers on Dicts
Hi Tom >> I created an F-pointer that specified the D_FileName in both attributes 2 and 3. I tried this, ED VOC DICT.IN.MASTER 0001: F 0002: E:\accounts\_source.DEV\D_IN.MASTER 0003: E:\accounts\_source.DEV\D_IN.MASTER Ran this CREATE TRIGGER AUDIT_DICT AFTER INSERT OR UPDATE OR DELETE ON DICT.IN.MASTER FOR EACH ROW CALLING 'RC.DATA.TRIGGER and got Adding trigger "AUDIT_DICT" UniVerse/SQL: Unable to open "E:\accounts\_source.DEV\D_IN.MASTER/DICT.IN.MASTER". UniVerse/SQL: Could not add trigger "AUDIT_DICT". Any ideas? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to Add Triggers on Dicts
Hi Mats >> Have you inserted it ( the dict entry ) into DICT DICT.DICT and CD'd it? Sounds promising, but a tad baffling in itself... I've found the DICT.DICT file, and viewed a sample 200 of them to see if I can find an example - alas! Please elaborate! - by {the dict entry} do you mean E:\accounts\D_the.file or ??? I know CD to be the compile thang used to compile I-type descriptors...?? If you're saying I should CD it, should it be an I-type? dennis -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to Add Triggers on Dicts
I successfully used this technique a few months back during a little troubleshooting exercise... I simply created an F-pointer that specified the D_FileName in both attributes 2 and 3. Essentially, you end up with an entity that gives you similar behavior to the reflexive Q-pointers you see on the traditional PICK platforms. Tom Firl Columbia Ultimate -Original Message- From: Daly, Mark [mailto:[EMAIL PROTECTED] Sent: Tue 3/2/2004 6:28 AM To: 'U2 Users Discussion List' Cc: Subject: RE: How to Add Triggers on Dicts Well.. It wouldn't surprise me if the CREATE TRIGGER command doesn't recognize the 'DICT' keyword. Triggers generally deal with data updates. I guess you could create a dummy file pointer that points to the dictionary as though it were a data file. Then reference that pointer when creating the trigger. BUT - I haven't tried it. Not sure I would try it. Good luck! -Original Message- From: Dennis Bartlett [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 9:20 AM To: 'U2 Users Discussion List' Subject: RE: How to Add Triggers on Dicts The trigger is currently working fine on DATA files. It's just the adding of it to DICT files that's boggling me at present. Once I've got that right, I'll have to think of some way to monitor Type 1/19 files, but that's another day. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How to Add Triggers on Dicts
Dennis Bartlett wrote: Hi Vincent, Is your subroutine GLOBAL cataloged ? Thanks for the prompt reply! Yes, it is cataloged using the INFORMATION FLAVOR catalog command. (our system runs on a PICK flavor account) The trigger is currently working fine on DATA files. It's just the adding of it to DICT files that's boggling me at present. Once I've got that right, I'll have to think of some way to monitor Type 1/19 files, but that's another day. Lost the start of this thread but: Have you inserted it ( the dict entry ) into DICT DICT.DICT and CD'd it? HTH -- mats -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to Add Triggers on Dicts
Well.. It wouldn't surprise me if the CREATE TRIGGER command doesn't recognize the 'DICT' keyword. Triggers generally deal with data updates. I guess you could create a dummy file pointer that points to the dictionary as though it were a data file. Then reference that pointer when creating the trigger. BUT - I haven't tried it. Not sure I would try it. Good luck! -Original Message- From: Dennis Bartlett [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 9:20 AM To: 'U2 Users Discussion List' Subject: RE: How to Add Triggers on Dicts The trigger is currently working fine on DATA files. It's just the adding of it to DICT files that's boggling me at present. Once I've got that right, I'll have to think of some way to monitor Type 1/19 files, but that's another day. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to Add Triggers on Dicts
Hi Vincent, >> Is your subroutine GLOBAL cataloged ? Thanks for the prompt reply! Yes, it is cataloged using the INFORMATION FLAVOR catalog command. (our system runs on a PICK flavor account) The trigger is currently working fine on DATA files. It's just the adding of it to DICT files that's boggling me at present. Once I've got that right, I'll have to think of some way to monitor Type 1/19 files, but that's another day. dennis -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How to Add Triggers on Dicts
Dear Dennis, Is your subroutine GLOBAL cataloged ? Vincent - Original Message - From: "Dennis Bartlett" <[EMAIL PROTECTED]> To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]> Sent: Tuesday, March 02, 2004 2:48 PM Subject: How to Add Triggers on Dicts > I'm attempting to write a mini-revision control system. We > use original > System Builder, which stores file-related screens in the > dict of those > files, plus of course having to record changes to dict > records too. > > I've tried the example posted to the list by Bryan Thorell, > a work of > beauty for adding triggers to data files. > > CREATE TRIGGER AUDIT_XXX AFTER INSERT OR UPDATE OR DELETE ON > XXX FOR > EACH ROW CALLING 'DATA.TRIGGER' ; > > I've tried various ways of modding this statement to add the > trigger to > a dict, but alas no success. > > Any ideas? > > dennis bartlett > > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users