Comments inline.
Many thanks,
Saneesh Joseph.
________________________________
From: Sharon Lucas [mailto:luc...@us.ibm.com]
Sent: Wednesday, May 13, 2009 8:15 PM
To: Joseph, Saneesh
Cc: staf-users@lists.sourceforge.net
Subject: Re: [staf-users] Batch script terminates halfway under STAF.
A PROCESS START request provides a STDIN option to specify a standard
input file to a command. Try the following:
1) STAF local PROCESS START COMMAND "C:/script/createtables.bat" WORKDIR
"C:/script" WAIT RETURNSTDOUT STDERRTOSTDOUT STDIN "password.txt"
Does that work? If not what is the output? If it doesn't work try:
[Joseph, Saneesh] That works. But I cant adopt this approach in my test
environment as createtables.bat is also being run manually, not only
under STAF. Moreover, the same script has command lines taking input
from different files, not only password.txt.
2) Create a empty file, e.g. C:/script/empty.txt, and do:
STAF local PROCESS START COMMAND "C:/script/createtables.bat" WORKDIR
"C:/script" WAIT RETURNSTDOUT STDERRTOSTDOUT STDIN "empty.txt"
If that doesn't work, try removing the < password.txt from your bat
file and then try the PROCESS START request in 1).
[Joseph, Saneesh] That works too, but cannot be adopted.
--------------------------------------------------------------
Sharon Lucas
IBM Austin, luc...@us.ibm.com
(512) 286-7313 or Tieline 363-7313
<saneesh.jos...@rsa.com>
05/13/2009 08:14 AM
To
<staf-users@lists.sourceforge.net>
cc
David Bender/Austin/i...@ibmus
Subject
Re: [staf-users] Batch script terminates halfway under STAF.
I found out the issue is because of the input redirection from
password.txt. The less than symbol ( < ) causes the issue. But didn't
get a solution yet... :-(
Many thanks,
Saneesh Joseph.
________________________________
From: Joseph, Saneesh
Sent: Wednesday, May 13, 2009 6:30 PM
To: 'staf-users@lists.sourceforge.net'
Cc: 'bda...@us.ibm.com'
Subject: Batch script terminates halfway under STAF.
Folks,
I have a windows batch file which is running properly when I run it. But
when I run it using STAF, it doesn't complete its execution
Createtable.bat
=======
@echo off
echo create table mytable(id integer)>myscript.sql
echo CREATING TABLES
psql -h localhost -p 5432 -U postgres -d postgres -f myscript.sql <
password.txt
echo DONE!
=========
When I run it manually (using command prompt), it shows
C:\script>createtables.bat
CREATING TABLES
Password:
CREATE TABLE
DONE!
When I run it using STAF,
C:\script>staf local process start command "c:\script\createtables.bat"
WORKDIR "c:\script" wait returnstdout stderrtostdout
Response
--------
{
Return Code: 255
Key : <None>
Files : [
{
Return Code: 0
Data : CREATING TABLES
Password:
CREATE TABLE
More?
}
]
}
Precisely, it executes psql command and then exits. After that it shows
"More?" in the response!!!. I have no idea what is happening... :-(
Please help me out..
Many thanks,
Saneesh Joseph.
------------------------------------------------------------------------
------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks
to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled.
http://p.sf.net/sfu/kodak-com___________________________________________
____
staf-users mailing list
staf-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/staf-users
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables
unlimited royalty-free distribution of the report engine
for externally facing server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
staf-users mailing list
staf-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/staf-users
