#!/bin/sh

USER=dwalin
HOST=cms

ssh $USER@$HOST /usr/bin/ksh <<END
. /opt/informix/bin/setenv
CLIENT_LOCALE='en_us.utf8'
export CLIENT_LOCALE
dbaccess cms@cms_ol - > /dev/null 2>/dev/null <<ENDQUERY
unload to '/tmp/dbaccess.out' delimiter ','
$1
ENDQUERY
cat /tmp/dbaccess.out
rm /tmp/dbaccess.out
END