Hi,
I have my informix queries in files named sql1.sql and sql2.sql.
I am executing these queries in a remote informix db server.The data got as a result of executing sql1.sql and sql2.sql is got in file1.dat and file2.dat respectively.
cmd= ssh "$USER_NAME"@"$HOST_NAME" "export INFORMIXDIR=/informix; export INFORMIXSERVER="$INFORMIX_SERVER" ;
export LD_LIBRARY_PATH=/informix/lib:/informix/lib/esql;
if [ -d "$REMOTE_DIR"/datafiles ]
then
rm -R "$REMOTE_DIR"/datafiles;
mkdir "$REMOTE_DIR"/datafiles;
chmod 777 "$REMOTE_DIR"/datafiles;
fi;
/informix/bin/isqlrf "$DB_ENGINE" - <<EOFSQL
unload to '"$REMOTE_DIR"/datafiles/file1.dat' `cat sqlfiles/sql1.sql`;
unload to '"$REMOTE_DIR"/datafiles/file2.dat' `cat sqlfiles/sql2.sql`;
EOFSQL"
`${cmd}`
Question 1: Is There any way to move the datafiles (file1.dat and file2.dat) to my local directory within this ssh session.
Question 2: How to print statements within isqlrf.Is there anything like "PROMPT" in sqlplus?
Thanks in advance