[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Executing UNIX shell scripts from inside an SQR program
- Subject: [sqr-users] Executing UNIX shell scripts from inside an SQR program
- From: John Czekaj <jrc4adp@yahoo.com>
- Date: Wed, 25 Oct 2006 11:38:16 -0700 (PDT)
- Delivery-date: Wed, 25 Oct 2006 14:40:57 -0400
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;b=kY9VZwIbF+j399CKm5Dnxudf9E8F9BGJBbiBvzaGM0f+OvFIVyRSlsrkP+eBD4+0BsYUbtbIsS/7HrN1AJPtDMWbhibZRTh/gV7+9g48zsFJZTu49s5MF/lIjYFKYw/LoFMOK0O99ztBwdN0Ajf1RvJtBkcl10UmP7ZGXy6Qkug=;
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
I have a client who is attempting to invoke a UNIX shell script from inside an
SQR. Sometimes these shell scripts copy files into archive directories and
send emails. Other times there are other UNIX commands being executed. They
are having two issues:
(1) The SQRs they are being initiated via the Process Scheduler (ADP Enterprise
Version 4C running on a Sun box using Solaris 9). When the shell scripts are
run, any output that goes to STDOUT is going into the Process Scheduler log
file instead of the initiating SQR's log file, which is what used to happen
when they were running SQR V3. They are now running SQR V8.1
(2) Apparently, the shell scripts themselves cannot be more than 200 lines
long. If they are longer, they just quit at the point of the 200th line.
Is there a way to redirect STDOUT to write to the initiating SQR log file
instead of the Process Scheduler log file? Is there some environment setting
that controls the size of a command file that is executed by a CALL SYSTEM
command?
If anyone has any insight on these issues and/or workarounds, I would
appreciate the information. Thanks in advance for your help.
John
John Czekaj
Senior Upgrade Specialist
ADP National Accounts - Upgrade & Patch Services
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users