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:
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).
--------------------------------------------------------------
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? L
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? L 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
------------------------------------------------------------------------------
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
