SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 08:31 AM
| ||||
| ||||
 RE: triggers christrier wrote > > I want to create some triggers for my database, one on-update > trigger, an on-insert trigger and an on-delete trigger. > I've already read the manual about how to create triggers. > > My problem is: I want to write the rows that are effected > into a file outside the database. > pseudocode: > on update unload TO 'update-file' select 'the updated row' > > I know that unload overrides the file, maybe it would be > possible to append everything in one file?! > How about -- .... output to pipe " cat > /tmp/test$$.dat" select * from account Or a variation of that. You might need without headings but you can use awk and sed in the pipe to manipulate the output. Colin Bull ================================================== ===================== This email may contain confidential and privileged information and is intended for the named or authorised recipients only. If you are not the named or authorised recipient of this email, please note that any copying, distribution, disclosure or use of its contents is strictly prohibited. If you have received this email in error please notify the sender immediately and then destroy it. The views expressed in this email are not necessarily those held by VNL, and VNL does not accept any liability for any action taken in reliance on the contents of this message. VNL does not guarantee that the integrity of this email has been maintained, nor that it is free of viruses, interceptions or interference. __________________________________________________ _____________________ This email has been scanned for all known viruses by the MessageLabs Email Security System. __________________________________________________ _____________________ sending to informix-list      |
Linear Mode
