RE: [sqr-users] facing problem while running unix command fromsq r

[Rahul_Kumar@adp.com]

Hi,
Thanks for reply....i hav found the resolution to that issue
I appreciate ur response

Rahul Kumar

AAHC-ACS

-- No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.


-----Original Message-----
From: George Jansen [mailto:GJANSEN@aflcio.org] 
Sent: Thursday, December 14, 2006 7:25 PM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] facing problem while running unix command from sqr

There are I suppose several dozen shells and scripting languages for
Unix, all or most of which will handle this quite comfortably. In the
very worst case, I suppose you could write a Korn shell script into
/tmp, chmod it and then use call system on the shell script. In Korn
shell, something like

#!/usr/bin/ksh


for i in 3 2
do
 j=`expr $i - 1`
 old=bak$j
 new=bak$i
 for fn in `ls *.$old`
 do
   mv $fn ${fn%%.$old}.$new
  done
done


BUT does this really need to be done through SQR? SQR is a reporting &
database interface program with a few commands thrown in for talking to
the command shell. Using it for the task you name is rather like using
Korn shell to run database commands via file-here invocations of
SQL*Plus. That is, it is doable but awkward. Can't you directly use ksh,
bash, Perl, or one of the many other shells or scripting languages?




_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
-----------------------------------------
This message and any attachments are intended only for the use of
the addressee and may contain information that is privileged and
confidential. If the reader of the message is not the intended
recipient or an authorized representative of the intended
recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this
communication in error, notify the sender immediately by return
email and delete the message and any attachments from your system.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users