sdetable -o create_view command

ToddMcNeil1

I have batch files on a windows 2003 server that I would like to run on a unix server without making edits to the bat files.  The bat files have the "^" character to show a carriage return or new line.  For example,

sdetable -o create_view ^
-T PLACE_HOUSING_VW ^
-t PLACE,PLACE_HOUSING ^
-c PLACE.objectid,^
PLACE.GEOID,^
PLACE.STATE,^
PLACE.STUSAB,^
PLACE.PLACE,^
PLACE.NAME,^
B25002EST1,^
B25002EST2,^
B25002EST2_PCT,^
PLACE.shape ^
-w "PLACE.GEOID = PLACE_HOUSING.GEOID(+)" ^
-u ACS_5YR_2009 ^
-p ACS5YR2009

What would I replace the "^" symbol with to get these bat files to run as a unix shell script?  Right now, I have to take out all of the "^" characters and have the entire command on one line.  It works, but is extremely time consuming to fix and manage.  Any ideas?

VinceAngelo

There are four or five different Unix shells, and all of them have more capability than DOS
(it's not even close). DOS borrowed Borne shell's redirection operators, so a script to run
all scripts in a directory, logging both stdout and stderr to different timestamped files in
Bourne would look like:

 
#!/bin/sh
# RunAll.sh - Execute all *.sh scripts in current directory (except this one)
d=`date "+%Y%m%d"`
for s in `ls *.sh`
do
        test `basename $s` = `basename $0` && continue
        echo "Executing script '$s'..."
        log1=`basename $s .sh`-${d}.log
        log2=`basename $s .sh`-${d}.err
        ./$s > $log1 2> $log2
done

There are any number of good books and websites for shell tyros (though my favorite
book is no longer in print).

- V

PS: To put both STDOUT and STDERR in the same file, use "./$s > $log1 2>&1"