Re: Running SQL from unix shell script

Posted in 1997

Jozsef Dojcsak — Thu, 06 Nov 1997 21:11:40 +0100 — source: Informix-list mailing list archive (1991-1998)

> ------- > dbaccess subscription <username> <password>; > unload to 'expired_users.txt' select aid,email from accts_esq_free where> expiry_dte < TODAY; > ------- You can try : echo "unload to 'expired_users.txt' select aid,email from accts_esq_free where expiry_dte < TODAY;" | dbaccess subscription <username> <password>; Regards, Jozsef