Re: Obtaining the complete code for a trigger from systrigbody

If you are trying to get the SQL for the current triggers, try running "dbschema -d database -t table". Or is there some reason that you need to go through the catalog tables? > We have a three part software product and we want to add new rules using > triggers, since Informix only permits one trigger per operation per > table, we must incorporate the existing triggers, so we thought in > obtaining that information from systrigbody, so we using shell unload > the data,trigid, seqno to a text file and read it from there. The only > problem I'm having is that in one trigger when we are at the last line > of each seqno, the next one should have a white space and it hadn't, > like select * from|1|1| > table Mark Collins mcollins@us.dhl.com Dilbert is a documentary.