Search Results

Knew it would be something simple! Thanks.

FILE_DATE=$(date +"%Y%m%d_%H%M")_
FILE_PREFIX=${FILE_DATE}
echo $FILE_PREFIX
JS_LOG_DIR="E:\DecisionStream Jobs\Invoice Balance Fact Jobs"
echo $JS_LOG_DIR

--This is where the problem...

I want to set a variable to be any number of dashes. Rather than doing the following:
MYVAR="------------------"

I'd like to be able to set the variable to, say, 80 dashes but don't want to have...

Try this:

RETURN=`sqlplus -s $USER <<END
select <column> from <table_name>;
quit
END`
if [ -z "$RETURN" ]; then
echo "Error - No rows returned "
exit 0
else
printf...