add sql trigger in iSeries Navigator

[phillip.groschwitz@xxxxxxxxx]

I'm trying to add an SQL trigger in iSeries Navigator.

I'm doing this:

BEGIN ATOMIC

DELETE FROM PHILLIB.MYFILE1
     WHERE OLD.MYKEY1 = PHILLIB.MYFILE2.MYKEY1;
END

I can't find where I can change the naming from SQL to *SYS so that I don't
need to specify the library.  The JDBC driver that's used when running SQL
scripts is set to *SYS.  I thought it would use the same one but apparently
not.

Thanks for the help!

Phil