Does the problem still occur if you add the SHELL option to the PROCESS
START request?
staf local process start SHELL command "c:\script\createtables.bat"
WORKDIR "c:\script" wait returnstdout stderrtostdout
David Bender
STAF/STAX Development
(512-286-5315)
IBM Austin Bldg. 903-5B002
Internet: bda...@us.ibm.com
<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
