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

Reply via email to