01-28-2020
Perhaps the SPOOL command will only write to a new file and refuse to append or overwrite an existing one.
Do you get any messages if you remove the SET FEEDBACK OFF and try it again with the file existing?
I hope that this helps.
Robin
10 More Discussions You Might Find Interesting
1. Solaris
Hi all......I'm sorry if my english is not that good. Can somebody help me to about this error. I found it in message.log
Jan 16 18:22:42 ASM imapd: get_balanced_partition: -- chosen
Jan 16 18:22:50 ASM SUNW,UltraSPARC-III+: NOTICE: Corrected system bus (CE) Event detected by CPU1 at TL=0,... (2 Replies)
Discussion started by: komang
2 Replies
2. Shell Programming and Scripting
Hi All,
I want to send a message through email to 5 people in unix script. Please let me know, how to do it.Please do reply it is urgent.How to do it?Please reply.thanks!
Thanks,
Mary. (2 Replies)
Discussion started by: MARY76
2 Replies
3. UNIX for Advanced & Expert Users
Hi All,
I want to send a message through email to 5 people in unix script. Please let me know, how to do it.Please do reply it is urgent.
Thanks,
Mary. (3 Replies)
Discussion started by: MARY76
3 Replies
4. Shell Programming and Scripting
Hi All,
When I am trying to execute the below shell script I got this error message.
script
==========
#!/bin/bash
/usr/java/jdk1.5.0_10/bin/java - classpath /var/lib/asterisk/agi-bin/mysql-connector-java-3.0.15-ga-bin.jar/:
/var/lib/asterisk/agi-bin/jarfiles:... (4 Replies)
Discussion started by: ajayyaduwanshi
4 Replies
5. Shell Programming and Scripting
Hello again all. I have a user editable script that I'd like to have point out the user error to. Problem is I'm having troubles getting an echoed error message to give me the line. Here's what I'm trying to do. grep -n $loc /this/script.sh where '$loc' is the argument passed to the script.... (9 Replies)
Discussion started by: DC Slick
9 Replies
6. Shell Programming and Scripting
I have one script that calls another script during execution. The other script does some processing, then either returns with exit 0 (if successful), or exits with error code numbers (if failed). However, in addition to the error code, I would like for that second script to be able to pass a... (4 Replies)
Discussion started by: AcerAspirant
4 Replies
7. Shell Programming and Scripting
Hi
I have a script that pick up a file on another server, and place it on a solaris server, but I came across the following error:
mget HLR01_21092014? 200 Port command successful
150 Opening data channel for file transfer.
HLR01_21092014: No space left on device
426 Connection closed;... (18 Replies)
Discussion started by: fretagi
18 Replies
8. Shell Programming and Scripting
Hi All,
I have created a unix script to mail the xls file.This is being done using mailx command
fdate=`tail -1 abc.xls | cut -c1-8`
SUBJECT="CARD GL Exceptions : ${ENV} for ${fdate}"
destname=CARD_GL_Exceptions_$fdate
sed 's/#BUSINESS/BUSINESS/1' abc.xls > abc2.xls
mv abc2.xls abc.xls... (2 Replies)
Discussion started by: karthik adiga
2 Replies
9. Shell Programming and Scripting
Hi
OS: Redhat
Version 7.5 Enterprise
Trying to post message from shell script to Slack channel and trying below code:
text="$msg"
text1="$lmsg"
if ]
then
echo "No text specified"
exit 1
fi
escapedText=$(echo $text | $text1 | sed 's/"/\"/g' | sed "s/'/\'/g" )... (13 Replies)
Discussion started by: onenessboy
13 Replies
10. UNIX for Beginners Questions & Answers
Greeting!!
I wrote the below script to e-mail me only file names in a specific directory when a file is delayed for some time in a that directory. I am getting unexpected eof error message.
I don't want any email if the folder is blank.(if the condition is not met) I am not getting the email at... (4 Replies)
Discussion started by: Hope
4 Replies
LEARN ABOUT REDHAT
set_constraints
SET
CONSTRAINTS(7) SQL Commands SET CONSTRAINTS(7)
NAME
SET CONSTRAINTS - set the constraint mode of the current transaction
SYNOPSIS
SET CONSTRAINTS { ALL | constraint [, ...] } { DEFERRED | IMMEDIATE }
DESCRIPTION
SET CONSTRAINTS sets the behavior of constraint evaluation in the current transaction. In IMMEDIATE mode, constraints are checked at the
end of each statement. In DEFERRED mode, constraints are not checked until transaction commit.
Note: This command only alters the behavior of constraints within the current transaction. Thus, if you execute this command outside
of an explicit transaction block (such as one started with BEGIN), it will not appear to have any effect. If you wish to change the
behavior of a constraint without needing to issue a SET CONSTRAINTS command in every transaction, specify INITIALLY DEFERRED or INI-
TIALLY IMMEDIATE when you create the constraint.
When you change the mode of a constraint to be IMMEDIATE , the new constraint mode takes effect retroactively: any outstanding data modifi-
cations that would have been checked at the end of the transaction (when using DEFERRED) are instead checked during the execution of the
SET CONSTRAINTS command.
Upon creation, a constraint is always give one of three characteristics: INITIALLY DEFERRED, INITIALLY IMMEDIATE DEFERRABLE, or INITIALLY
IMMEDIATE NOT DEFERRABLE. The third class is not affected by the SET CONSTRAINTS command.
Currently, only foreign key constraints are affected by this setting. Check and unique constraints are always effectively initially immedi-
ate not deferrable.
COMPATIBILITY
SQL92, SQL99
SET CONSTRAINTS is defined in SQL92 and SQL99. The implementation in PostgreSQL complies with the behavior defined in the standard, except
for the PostgreSQL limitation that SET CONSTRAINTS cannot be applied to check or unique constraints.
SQL - Language Statements 2002-11-22 SET CONSTRAINTS(7)