I know what you mean.. Even after contacting the VAR this was not resolved. Since it involves multiple systems I'm really wondering what the source of the issue is. Which side has the problem? Is it something related to a buffer size setting on either side? Is it a quirk with the combination of ODBC & a trigger?
Who else have used triggers effecting a DIR file? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of john reid Sent: Thursday, October 12, 2006 2:21 PM To: [email protected] Subject: Re: [U2] Trigger behavior i'm trying to sucker (I mean ask politely) a couple of individuals into trying it here, just for curiousity sake. On 10/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > no problem -- I'm just frustrated > > It's a chicken or the egg thing > > > > -- > Debster > > -------------- Original message -------------- > From: "john reid" <[EMAIL PROTECTED]> > > > Sorry for the misunderstand about the hash file, and dir. > > j > > > > On 10/11/06, [EMAIL PROTECTED] wrote: > > > The trigger is not ON a directory it is on a hash file where the trigger is > > also supposed to update a DIR file. Triggers cannot be on a directory in > > Unidata, but you are supposed to be able to effect a DIR type > > > > > > Considering that the problem only exists when coming in from the outside I > > suspect it has to do with > > > > > > Tuxedo from the other side > > > > > > Permissions? (but all other rights are fine on all Unidata files) > > > > > > ODBC can it be a buffer setting or something else? This is the first DIR > > type that the outside has access to so.. > > > > > > > > > > > > It DOES work successfully provided the person is not coming in from the > > outside. Hence my questioning buffers, effects of ODBC connections > > > > > > > > > > > > -- > > > Debster > > > > > > -------------- Original message -------------- > > > From: "john reid" > > > > > > > Do you have triggers on other directories? > > > > I get the following when attempting to create a trigger on a > > > > directory, in Universe: > > > > CREATE TRIGGER TESTJ AFTER INSERT OR UPDATE OR DELETE ON JMRBP FOR EACH ROW > > CALL > > > > ING '*MAIN.TRIGGER'; > > > > UniVerse/SQL: Invalid file type specified. > > > > Warning: SICA information could not be read properly!! > > > > > > > > > > > > On 10/10/06, Debster wrote: > > > > > Here is the scenario > > > > > > > > > > Remote non-pick box runs an ODBC process coming through Tuxedo > > > > > > > > > > Unidata 6.0/IAIX 5.x is running on the Pick box > > > > > > > > > > A file that contains a trigger is updated -- the trigger updates not only > > > > > hashed files but also attempts to update a DIR type file. > > > > > > > > > > > > > > > The DIR file cannot be opened or read from the remote non-pick system, the > > > > > Hash files have no problem. Return code is 1 > > > > > > > > > > > > > > > The DIR file Can be opened, read and written to from the pick side > > > > > > > > > > There are three flat files contained in this directory > > > > > > > > > > What type of OPEN/READ should be performed? > > > > > > > > > > > > > > > By using the ODBC process are the remote users relagated to hash files? > > > > > (i.e. perform as PICK type) > > > > > > > > > > > > > > > Is it just permissions? > > > > > > > > > > > > > > > > > > > > ~ Debbie > > > > > ~~~~~~~~~~~~ > > > > > "Anyone can hold the helm when the sea is calm" > > > > > > > > > > -Syrus Publilius > > > > > > > > > > www.infinite-systems.net > > > > > ------- > > > > > u2-users mailing list > > > > > [email protected] > > > > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > > > > > > > > > > > > > -- > > > > john > > > > ------- > > > > u2-users mailing list > > > > [email protected] > > > > To unsubscribe please visit http://listserver.u2ug.org/ > > > ------- > > > u2-users mailing list > > > [email protected] > > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > > > > > -- > > john > > ------- > > u2-users mailing list > > [email protected] > > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > -- john ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
