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/
