![]() |
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Delimiters missing | Indalecio | Shell Programming and Scripting | 2 | 02-23-2007 04:28 AM |
| Missing functions HELP! | sha1024 | High Level Programming | 1 | 02-05-2007 03:06 PM |
| missing CDE | frankkahle | SUN Solaris | 5 | 05-25-2006 05:35 PM |
| /tmp is missing ???? | BAM | UNIX for Dummies Questions & Answers | 1 | 11-05-2002 02:50 PM |
| /dev/fb* missing | heinb | UNIX for Dummies Questions & Answers | 5 | 02-12-2002 05:22 AM |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
||||
|
I have the following portion of a script
Code:
Check()
{
echo "\n\nChecking that all constraints are Enabled"
echo "..."
sleep 2
CHECK_COUNT='sqlplus -s $1 <<-EOSQL4
set feed off pause off pages 0 head off;
set linesize 150 echo off;
select count(*) from user_constraints where status='DISABLED';"
quit;
EOSQL4'
if [ $CHECK_COUNT -eq 0 ]
then
echo "\nThe following $CHECK_COUNT constraint(s) could not be enabled!"
#sqlplus -s $1 <<-EOSQL
#set feed off pause off pages 0 head off;
#spool ref_con_errors.log;
#select constraint_name,table_name from user_constraints where status='DISABLED';
#spool off;
#quit;
#EOSQL
#echo "\nPlease view 'ref_con_errors.log' for details on which constraints"
echo ""
else
echo "\nAll Constraints are enabled"
echo ""
fi
}
Checking that all constraints are Enabled ... Check[12]: -s: unknown test operator All Constraints are enabled How do I get rid of this error? Thanks, Zelp |
|
||||
|
Code:
CHECK_COUNT='sqlplus -s $1 <<-EOSQL4 set feed off pause off pages 0 head off; set linesize 150 echo off; select count(*) from user_constraints where status='DISABLED';" quit; EOSQL4' Remove the red dash |
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|