I'm using DB2 7.1 on Win NT but my DB is on a UNIX server. I access the DB through PSQL in telnet (putty).

My problem is that I want to send an auto email to any user who creates a new account. This will, for e.g., tell them their new username and password.

I have only been given one hint on how to do this, and that is to do the following:

put a timestamp on every insert
export new inserts to a text file
run a program that checks this text file for new updates (e.g. all inserts within the last 5 mins)
this program then sends email to all new inserts (don't ask me how!)

Is this the best way to do this? are there any other ways??

Any help would be greatly appreciated.

A trigger and udf together can do the job automatically when you create the user


http://www-106.ibm.com/developerwork...205bhogal.html

Cheers
Sathyaram