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 <[EMAIL PROTECTED]> 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/
